Hello Vijayender,
Unfortunately, the method I gave you is the only way to do it. There is an 8 year old new feature request that asks for an easier, less disruptive way of doing it that has not gained any traction.
Thanks,
Neal
------------------------------
Neal Stack
Senior Principal Technical Support Engineer
Delphix
------------------------------
Original Message:
Sent: 03-29-2023 10:09:01 AM
From: Vijayender Singidi
Subject: Convert windows source environment as target
Hi Neal,
we would like to convert without dropping source DBs on the environment.
------------------------------
Vijayender Singidi
Original Message:
Sent: 03-29-2023 10:02:35 AM
From: Neal Stack
Subject: Convert windows source environment as target
Hello,
You can convert a Windows source environment to a target environment using the following procedure:
-
Install Delphix Connector on the source Windows host.
-
Unlink/detach all of the dSources in the environment ( https://documentation.delphix.com/docs/detaching-and-re-attaching-sql-server-dsources?highlight=unlink%20dsource ). This disassociates them from the environment temporarily.
-
Delete the source environment in Delphix. Delphix won't allow you to delete the environment until there are no dependent objects which is why we have to detach them first.
-
Add the same host back as a target environment.
-
Now you can link/attach the previously detached dSources back to this target environment.
I hope this helps.
------------------------------
Neal Stack
Senior Principal Technical Support Engineer
Delphix
Original Message:
Sent: 03-29-2023 09:47:09 AM
From: Vijayender Singidi
Subject: Convert windows source environment as target
is there any way to convert windows source environment as target for SQL server?
------------------------------
Vijayender Singidi
------------------------------