Can Delphix provides the facility to clone only Schema Structure without the data

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
As Production data is very confidential, can Delphix gives the facility to get only schema structure. is it possible to do without having initial backup. if yes, please provide the steps to do this.
Photo of Jitendra Kumar

Jitendra Kumar

  • 252 Points 250 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of Ranzo Taylor

Ranzo Taylor, Employee

  • 1,736 Points 1k badge 2x thumb
Official Response
Yes and No.

Delphix clones databases at the block level.  It is not like an Oracle Export or other dump utilities which create the schema and then slowly populate it with insert statements.  Rather, it virtually copies all the database blocks.

But we have a Masking product which takes the value out of the production data, allowing you to focus your security dollars on protecting production.  We change the sensitive data into realistic but fake data.

Our solution to the problem, used successfully by many Fortune 500 customers, is to create a full virtual copy of production in your safe production zone, mask it one time, and distribute it many times to downstream customers in less secure areas (including offshore).  This is much faster and more efficient than "dump and load" or subsetting techniques, and ultimately a lot more useful for developers and testers.  In addition, your production zone Delphix engine can assist with more use cases:  Production break/fix, Business Intelligence/Operational Reporting, and Compliance/Archiving.
Photo of Tim Gorman

Tim Gorman, Delphix Field Services

  • 3,996 Points 3k badge 2x thumb
Official Response

Delphix will capture the entire source database, and it will initially provision the entire database as a VDB, as described by Ranzo above.

But it is certainly possible to automate the drop of objects and schemas -- except the ones you wish to retain -- in the newly-provisioned VDB as a seamless integrated post-provisioning step, using custom-built programmatic callouts known as "hooks".

Hope this helps!