Upgrading a dSource after a SQL Server Upgrade
Delphix Administration / SQL Server Environments and Data Sources / Virtualizing Databases Using Delphix with SQL Server / Managing SQL Server dSources / Additional dSource Topics / Upgrading a dSource after a SQL Server Upgrade

This topic describes how to upgrade dSources after an SQL Server database upgrade.

Prerequisites

  • The source SQL Server database has been upgraded by attaching to a higher version of SQL Server instance.

Procedure

  1. Login to the Delphix Management application using delphix_admin credentials or another account with admin privileges.
  2. In the top menu bar, click Manage.
  3. Select Environments to display the servers registered with the Delphix Engine as environments.
  4. In the left navigation pane, find the Delphix environment which represents the Windows server on which the recently-upgraded source database resides. Click the environment name to expand the bar. This will also display the Environment Details in the main screen.

  5. In the left navigation pane, click the Refresh icon  for the environment. This will cause the Delphix Engine to re-discover all instances and all databases on that Windows server.

    The refresh/rediscover operations do not affect the operations of any dSources or VDBs on the environment.

  6. When the refresh/rediscover operation completes, click Manage in the top menu bar.
  7. Select Datasets.
  8. Select the dSource to be upgraded.
  9. Disable the dSource.
    1. From the Actions (...) menu select Disable.
    2. In the Disable dialog select Disable.
  10. From the Actions (...) menu select the Upgrade. 
  11. The Upgrade Database panel will open. The SQL Server instance that is hosting the recently-upgraded source database will appear in the drop-down list. Select that instance.
  12. Select an appropriate staging environment and SQL instance for the dSource's staging database. The staging SQL instance must be the same version as the SQL Server instance hosting the upgraded source database.
  13. Accept the change by clicking the Checkmark icon. 
  14. Enable the dSource.
    1. From the Actions (...) menu select Enable.
    2. In the Enable dialog select Enable.
  15. On the Configuration tab, click the snapshot icon  to run a SnapSync for the dSource.