Migrating a SQL Server VDB

This topic describes how to migrate a SQL Server VDB to a different environment.

Prerequisites

• The VDB has to be disabled first before migrating it by following the steps outlined in Enabling and Disabling Virtual Databases.
• The target environment where the VDB is to be migrated should already have been added to the Delphix Engine. Follow the steps outlined in Adding a SQL Server Standalone Target Environment.

Procedure via GUI

1. Select the VDB you would like to  migrate
2. Disable VDB 
3. Select the Migrate VDB icon 
4. Select the New Environment and Installation
5. Hit the Check Mark
6. After job finishes Enable VDB

Procedure via CLI

1. Select the source associated with the VDB.

   delphix> source
   delphix source > select "vexample"

2. Select the source config associated with the source.

   delphix source "vexample"> get config
       vexample
   delphix source "vexample"> /sourceconfig 
   delphix sourceconfig > select "vexample"
   delphix sourceconfig "vexample">

3. Update the repository to the repository on the target environment for the migration, and the environment user associated with the source config.

   delphix sourceconfig "vexample"> update
   delphix sourceconfig "vexample" update *> set repository="new target environment"/"MSSQL instance"
   delphix sourceconfig "vexample" update *> set environmentUser="new target environment"/"new target's user"
   delphix sourceconfig "vexample" update *> commit
   delphix sourceconfig "vexample">

Post-Requisites

• Enable the VDB following the steps outlined in Enabling and Disabling Virtual Databases.

Related Links

• Adding a SQL Server Standalone Target Environment
• Enabling and Disabling Virtual Databases