We have 2 databases - Prod and Dev. They are not syncronized and has a slightly different stored proc-s and table structure (column added/ or removed).
So Prod and Dev are not in sync, they are not mirrors.
Production db has production data.
How I can transition/move/map data from Prod to Dev?
For example, both databases have table Users :(f_name, l_name, field1, field2). And I need to populate dev db with prod data.
What strategy should I follow? What tools showld I use? How I can automate the it?
Should I use Import wizard or DTS?
SQL Server 2000
Thank you
Based on the information you provide both the DTS Import Wizard or a Copy SQL Server Objects Task DTS package will work and both can be automated by a job schedule. Basically they are the same.
If you need to tranform data, which you con't mention you can use a DTS package with tranforms or write you own truncate/insert code and schedule either as a job.
No comments:
Post a Comment