Migrating a SQL Server Staging Database

This topic describes how to migrate a SQL Server staging database to a different environment. For an overview of what a staging database is used for, see Setting Up SQL Server Environments: An Overview .

Prerequisites

• The dSource for the staging database has to be disabled first before the migration. Follow the steps in Enabling and Disabling dSources to disable the dSource.
• The target environment for the migrated staging database should already have been added to the Delphix Engine. Follow the steps in Adding a SQL Server Standalone Target Environment to add the environment as a target environment. The environment should also meet the requirements for hosting a staging database as described in Requirements for SQL Server Target Hosts and Databases.

Procedure

1. Go to Manage >  Database > My Databases
   
2. Select the dSource for the staging source.
   
3. Modify the Staging Environment for the dSource by clicking the Pencil icon next to it.
4. Select the new target environment for the staging source.
5. Select the SQL Server instance on the new target environment.
6. Accept the change.

Post-Requisites

• Enable the dSource following the steps outlined in Enabling and Disabling dSources.

Related Links

• Setting Up SQL Server Environments: An Overview
• Adding a SQL Server Standalone Target Environment
• Enabling and Disabling dSources
• Requirements for SQL Server Target Hosts and Databases