Delphix Products

Back to discussions
Expand all | Collapse all

Tip of the Day: Upgrading a SQL Server dSource

  Thread closed by the administrator, not accepting new replies.

  • 1.  Tip of the Day: Upgrading a SQL Server dSource

    Posted 12-01-2014 06:27:00 PM
    No replies, thread closed.
    This procedure is if you have upgraded a SQL Server database and now need to have that change reflected in Delphix:

    1. Refresh all environments.
    2. Log into the Delphix Admin application using delphix_admin credentials. 
    3. Select Manage > Databases > My Databases.
    4. Disable the dSource to be upgraded.
    5. Click the Expand icon to open its card.
    6. Click the crown icon on the bottom of the dSource card.
      The Upgrade Database screen will open. The new instance should appear in the dropdown list. If it does not, go to Manage->Environments, select a card with the environment containing the new instance, and click Refresh Environment on that card.
    7. Select the new SQL Server instance that the source database is attached to.
    8. Select the appropriate staging environment and instance. The staging instance must be the same version as the new SQL Server instance.
    9. Click OK.
    10. Enable the dSource.
    11. Click Snapshot on the dSource card to run SnapSync for the dSource.