Sandbox Portal Data Refresh

This article outlines the process of a ‘data refresh’. This involves taking Production Portal data and restoring to the Sandbox Portal so updates applied to the Sandbox Portal first, reflect current Production Portal content.

Note: Passageways can assist with the data refresh for a fee.

1. Verify that the Production and Sandbox Portals are on the same framework AND module versions. This is a critical step & will result in Portal errors if not followed.
1. Update the Portals so that they are on the same versions for all modules and framework if needed, before proceeding to the next step. Please contact Passageways Technical Support by emailing support@passageways.com or calling 765-535-1880 opt.1 if issues are encountered while updating.
2. Take backups of all Production Portal databases.
3. Restore Production Portal databases over the Sandbox Portal databases.
1. Verify the Sandbox user in connection strings is database owner.
4. Copy all the Production Portal file structure contents. :\inetpub\wwwroot\production portal
5. Paste the contents into the sandbox structure contents. DO NOT REPLACE!! When it asks if you want to replace say no. We only want to move over any missing files. :\inetpub\wwwroot\sandbox
6.  Update the Customnavigationnodes.config to reflect the Sandbox URL. This can be found here - Drive:\inetpub\wwwroot\Test Portal\customnavigationnodes.config
7.  Perform a URL change on the Test Portal Databases. URL Change scripts are located here: https://support.passageways.com/hc/en-us/articles/204571820-How-To-Change-the-Passageways-Portal-URL

10. Make sure the Sandbox Portal is up and running properly.

11. If no issues are found with the refreshed Sandbox Portal, you are now ready to proceed with updates to the Sandbox Portal to better test with Production Portal content.

Helpful Articles

Database Backup- http://msdn.microsoft.com/en-us/library/ms187510.aspx

Database Restore- http://msdn.microsoft.com/en-us/library/ms177429.aspx