Upgrading SQL Server VDBs
Delphix Administration / SQL Server Environments and Data Sources / Virtualizing Databases Using Delphix with SQL Server / Managing SQL Server VDBs / Additional VDB Topics / Upgrading SQL Server VDBs

This topic describes how to upgrade a SQL Server VDB to a higher version of SQL Server instance.

Procedure for VDB In-Place Upgrade

  1. Remove any VDB Refresh Policy assigned to the VDB.
  2. Upgrade the target SQL Server instance.
  3. Refresh the target environment.

Procedure to Upgrade a VDB to a New SQL Instance

  1. Refresh all environments.
  2. Login to the Delphix Management application using delphix_admin credentials or as the owner of the VDB. 
  3. Click Manage.
  4. Select Datasets.
  5. Select the VDB to be upgraded.
  6. From the Actions menu (...) select Disable.
  7. Click Disable to confirm.
  8. From the Actions menu (...) select upgrade.
    The Upgrade Database window will open.
  9. Select the SQL Server instance to which you want the VDB to upgrade.
  10. Click OK.
  11. Enable the VDB. (See Enabling and Disabling SQL Server VDBs.)
  12. Repeat step 5 to 12 for each VDB you want to upgrade. 

Notes

Upgrading a SQL Server 2005 VDB to SQL Server 2008 or 2008 R2 is not supported.