Restore databases

Perform these steps on the server with the new installation of DWD.

  1. In the Microsoft SQL Server Management Studio, right-click Databases > Restore Database .
  2. In the Source section, specify Device.
  3. Click the ellipsis to specify the backup devices.
  4. Click Add.
  5. Click OK.
  6. Select the Restore check box next to the database backup file.
  7. Click OK.
  8. Repeat these steps for all four DWD databases per DWD profile:

    • Catalog

    • Datamarts

    • Repository

    • Staging

  9. After migrating all the databases, recompile all DWD Objects in the solution.
    Note: 

    To avoid SQL collation conflict, the collation of the database backups and the target Microsoft SQL Server instance for restore should be the same.