Migrate SQL Server VDBs

  • 1
  • 1
  • Question
  • Updated 3 years ago
  • Answered
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.
Photo of Jim Larsen

Jim Larsen

  • 592 Points 500 badge 2x thumb

Posted 3 years ago

  • 1
  • 1
Photo of Jaclyn Schoof

Jaclyn Schoof

  • 5,092 Points 5k badge 2x thumb
Official Response
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!
Photo of Jim Larsen

Jim Larsen

  • 592 Points 500 badge 2x thumb

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?

Photo of Jim Larsen

Jim Larsen

  • 592 Points 500 badge 2x thumb

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

Photo of Srish Sriram

Srish Sriram, Employee

  • 1,280 Points 1k badge 2x thumb
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
Photo of Jim Larsen

Jim Larsen

  • 592 Points 500 badge 2x thumb

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

Photo of Srish Sriram

Srish Sriram, Employee

  • 1,280 Points 1k badge 2x thumb
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
Photo of Jim Larsen

Jim Larsen

  • 592 Points 500 badge 2x thumb

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?


Photo of Srish Sriram

Srish Sriram, Employee

  • 1,280 Points 1k badge 2x thumb
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
Photo of Jim Larsen

Jim Larsen

  • 592 Points 500 badge 2x thumb

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


Photo of Srish Sriram

Srish Sriram, Employee

  • 1,280 Points 1k badge 2x thumb
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