Delphix Products

Expand all | Collapse all

Migrate SQL Server VDBs

  • 1.  Migrate SQL Server VDBs

    Posted 02-03-2016 01:59:00 PM
    Is there a way to migrate SQL Server VDBs or sources? Note: This conversation was created from a reply on: Tip of the Day: Using the CLI to Migrate an Oracle VDB.


  • 2.  RE: Migrate SQL Server VDBs
    Best Answer

    Posted 02-03-2016 04:14:00 PM
    Hi Jim,
    You can definitely do this via the CLI or the GUI, check out https://docs.delphix.com/display/DOCS43/Migrating+a+SQL+Server+VDB for both procedures!


  • 3.  RE: Migrate SQL Server VDBs

    Posted 02-03-2016 05:02:00 PM

    Thanks Jaclyn, is there any way to migrate a source database to a new server?

    The staging server will be the same, but the physical source needs to move to a new server.  Is there any way to migrate that?



  • 4.  RE: Migrate SQL Server VDBs

    Posted 02-03-2016 05:24:00 PM

    I found this link:

    https://docs.delphix.com/display/DOCS43/_Detaching+and+Re-Attaching+dSources

    I tried reattaching the source, but I am confused on what to put for some of the fields.

    Like pptRepository, what goes in that field?

    Thanks

    Jim



  • 5.  RE: Migrate SQL Server VDBs

    Posted 02-03-2016 05:45:00 PM
    Hi Jim,

    The pptRepository field needs to be set to the name of the SQL instance on the staging server. You can find a detailed description on how to run these CLI commands on our help article "CLI Cookbook: Detaching and Attaching a SQL Server dSource".

    I hope this helps. Please let me know if you have any questions.

    Thanks!

    Srish


  • 6.  RE: Migrate SQL Server VDBs

    Posted 02-03-2016 06:06:00 PM

    Thanks Srish,

    That helped, so my last question is this.

    If we do the detach and reattach to move the source to a new server.

    Will there be any impact on the VDBs and Containers provisioned from that source?

    Thanks

    Jim



  • 7.  RE: Migrate SQL Server VDBs

    Posted 02-03-2016 06:32:00 PM
    Hi Jim,

    No, there will be no impact. The VDBs are considered a separate entity and will not be impacted by dSource detachment.

    Thanks!

    Srish


  • 8.  RE: Migrate SQL Server VDBs

    Posted 02-03-2016 06:44:00 PM

    I did a quick test of backing up a source database and restoring it to the new server and then attempting the re-attach and found that it failed because the "Recovery Fork GUID" were different.

    What I found though is that if you create the target database on the new server using the V2P functionality in Delphix that the "Recovery Fork GUID" is the same between the original Source and the new database.


    Would you foresee any problems doing the following:

    1) Begin downtime on current source and remove all users

    2) Take Snapshot of current source

    3) Create source database on target new server using V2P of most snapshot taken in step 2

    4) Unlink dSource

    5) Relink dSource to source on new server using CLI


    Do you think that would work?




  • 9.  RE: Migrate SQL Server VDBs

    Posted 02-03-2016 08:29:00 PM
    Hi Jim,

    You should make sure that the dSource exists in your new target server before performing the V2P action described in Step 3. Otherwise, those steps you described should work.

    Thanks!

    Srish


  • 10.  RE: Migrate SQL Server VDBs

    Posted 02-03-2016 09:05:00 PM

    I am not sure I understand, I would create the target physical database on the target server ahead of time and then the V2P would overwrite it?

    I did a test of a small dummy database and in that case the physical server didn't exist ahead of time




  • 11.  RE: Migrate SQL Server VDBs

    Posted 02-04-2016 08:29:00 PM
    Hi Jim,

    I want to correct what I said earlier. The steps you mentioned would work. If you have any questions, please let me know. I apologize for the confusion.

    Thanks!

    Srish