CODEWITHSUNDEEP
sql-serverssis
plditallo
plditallo

Reputation: 701

SSIS/SQL Server: Can I copy CDC prod data to look alike tables in the dev environment?

I don't know the inner workings enough to know whether this is even worth trying. The bottom line is I want to test a sampling of production data by writing a test SSIS package using the cdc component. Anyone out there done this?

Upvotes: 0

Views: 390

Answers (1)

Jayvee
Jayvee

Reputation: 10873

If you just need net changes, you can also consider Change Tracking instead of CDC as a more efficient option: http://technet.microsoft.com/en-us/library/bb933994.aspx

If it's only about generating test data I would recommend redgate's SQL Data Generator: http://www.red-gate.com/products/sql-development/sql-data-generator/

Upvotes: 1

Related Questions