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 Admin application using delphix_admin credentials or as the owner of the VDB. 
  3. Click Manage.
  4. Select My Datasets.
  5. Select the VDB to be upgraded.
  6. Click the Configuration tab.
  7. Move the slider from Enabled to Disabled
  8. In the upper right-hand corner of the tab, click the upgrade  icon.
  9. The Upgrade Database screen will open.
  10. From the New Instance dropdown, Select the SQL Server instance to which you want the VDB to upgrade.
  11. Click OK.
  12. Enable the VDB. (See Enabling and Disabling SQL Server VDBs.)
  13. Repeat step 3 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.