ECX | Database | Reports & Papers | IBM | NetApp | Pure Storage | October 2016
Organizations require copies of production data for use in application development, QA, analysis, and reporting, especially for databases such as Oracle and SQL Server. For various reasons such as performance impact, security implications, and data integrity, performing anything considered a Dev or Test function on production data is rarely a good idea. Instead, organizations restore to SQL cloning and Oracle cloning to create frequent copies of production data sets and continually refresh them to allow secondary functions to be performed with real data. This leads to numerous IT challenges. This report details the specific challenges organizations face, and shows how an effective Copy Data Management solution can meet those challenges and deliver added value, especially in the areas of SQL test data management and Oracle test data management.