Dev Instance Data Refresh

« Return to Notes Listing

Author:Aaron
Last Updated:December 13, 2022 11:35 AM

DEV INSTANCE DATA REFRESH

Follow the steps to restore a copy of the production database over dev. It is important to start with a new backup of prod so all data is up to date.

  1. Restore prod backup over host-dev-2 database
    • Your PROD backup file should already be in \\sql-dev-1\DatabaseRefresh
    • Open a PowerShell window on your local PC at M:\_tpi\LegacyUpgrades\Databaseupgrade as administrator
    • Run RestoreDatabase.ps1

Pre v6.9.5 Database Upgrade to v7

If the instance is pre v6.9.5, you will need to upgrade to v7 in THREE STEPS:

  1. Run UpgradeLegacyDB script against the restored production database (M:\_tpi\LegacyUpgrades\DatabaseUpgrade\UpgradeLegacyDB.ps1) to upgrade to 6.9.0.0 
    REMEMBER: This is only necessary if the instance is less than 6.9.0.0 
     
  2. Once the database has been upgraded to 6.9, you need to upgrade it to 6.9.5.xx BEFORE you upgrade to v7. To do this, install the latest 6.9.5 package into the site using the Platform Installer (TPI)
     
  3. Upgrade to the latest version of Titan using TPI
     
  4. Finally, copy the File Pile from Prod using RoboCopy
    EXAMPLE: robocopy \\host-prod-1\Files\Sites\[ClientID]\Titan\Public\FilePile\Pile1 \\host-dev-2\Files\Sites\[ClientID]\Titan\Public\Wkst\FileServer /mir /mt:30
top