Can Delphix perform V2P for MSSQL / Sql Server?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
I know this works for Oracle, but how bout MSSQL?
Photo of Thom T

Thom T

  • 838 Points 500 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Photo of Ranzo Taylor

Ranzo Taylor, Employee

  • 1,572 Points 1k badge 2x thumb
Official Response
Yes, Delphix can perform Virtual to Physical for MSSQL / SQL Server.

From the Docs: https://docs.delphix.com/display/DOCS/V2P+with+a+SQL+Server+VDB

Procedure
  1. Log into the Delphix Admin application as a Delphix Admin user, or group or object owner.
  2. Select the dSource or VDB you want to export.
  3. Select the snapshot of the dSource or VDB state you want to export.
  4. If you want to export the state of the database from a specific point in time, slide the LogSync slider on the top of the snapshot card to the right, and then select the point in time from which you want to create the export.
  5. Click V2P or Deploy.

  6. Select the target environment.
  7. Enter the Target  Directory for the export.
    The target directory you enter here must exist in the target environment, and you must have permission to write to it. See Requirements for SQL Server Target Hosts and Databases for more information on user requirements for target environments.
  8. Select an option for Run recovery after V2P.
    If you select No, you can use the scripts that are created in the target environment to manually recover the database at a later time. See Manually Recovering a Database after V2P for more information.
  9. Click Advanced to customize the target directory layout. See Customizing Target Directory Structure for Database Export for more information.
  10. Click Next.
  11. Select whether you want to have an email sent to you when the export process completes, and then click Finish.
Post-Requisites

If you selected No for Run Recovery after V2P, follow the instructions in Manually Recovering a Database after V2P to complete the V2P process.