Subsetting Production Data

Just about every database out there has at least three copies of itself: production, test, and development. Some shops take this even further with separate test and stress-test instances. It’s pretty obvious that production is the real deal and hence the source of data for the copies. But how do you make relationally correct, subset copies of production data for both test and development? Oracle provides no tools for simply taking 10% of the production data and copying it to another database. The DBA or developer must either write extensive scripts themselves or utilize TOAD’s new Data Subset Wizard (debuted in TOAD 7.3).

TOAD’s Data Subset Wizard is a simple four-step utility for automatically generating relationally ...

Get TOAD® Handbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.