Delphix Products

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.

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!

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?

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

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

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

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

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?

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

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

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