Sample Test Data from Production in SQL Server 2008

15 pts.
Tags:
Data Extraction
SQL 2008
SQL Server 2008
T/SQL
Is there a data generation tool that can populate tables in a test database with a percentage of actual data from a production database? For example, to extract data based for a date range from a specific table, and all related tables to be populated based on the corresponding related referenctail data. 

Software/Hardware used:
SQL Server 2008

Answer Wiki

Thanks. We'll let you know when a new response is added.

SSIS can do this, it will require some work, but it isn’t all that hard to do.

Discuss This Question: 4  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Subhendu Sen
    Mrdenny's suggestion is good. The production database which u want to use and has multiple schemas, create SSIS for each schema. And truncate all of the tables in a schema & test, then load the data from production. Remember, Don't need to restore whole database. The package could also restrict the amount of data, and restrict the copy of sensitive data. Not necessarily access to production database to run SSIS, because SQL Server Agent has trick to access. One of the most advantage of SSIS u can set it up to create tables in test that exist in production database, and if necessary may copy the data.
    27,800 pointsBadges:
    report
  • Meandyou
    Does SSIS obfuscate the data? This is an important aspect of using production data for testing.
    5,220 pointsBadges:
    report
  • Denny Cherry
    If you wanted it to obfuscate the data you would need to build this into the package. There isn't any native checkbox or anything to do this.
    66,065 pointsBadges:
    report
  • Teguma
    [...] 3. Mrdenny, Rechil and Meandyou gave some great suggestions and considerations for a member looking for sample test data from production in SQL server 2008. [...]
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following