What is the best and simplest way to script a straightforward refresh of Test data from Production data in MS SQL 2005/Transact-SQL? (Just the data, not the objects.) Thanks.
If you have not yet had an opportunity to explore the Data Generator included with Visual Studio Team System for Database Professionals, I highly recommend that you download the 180 day eval and let the Data Generator 'blow your socks off'.
http://msdn2.microsoft.com/en-us/teamsystem/aa718807.aspx
http://msdn2.microsoft.com/en-us/teamsystem/aa718764.aspx
http://msdn2.microsoft.com/en-us/teamsystem/bb507197.aspx
Here you can download a virtualized version:
http://www.microsoft.com/downloads/details.aspx?FamilyID=9D60655E-814C-40A8-9762-53A40D8E7B37&displaylang=en
After you see the potentials for Test and Development data generation, you will no long try writing your own scripts.
|||A series o scripts with "bcp out" from Production then another series with "bcp in" to Development (after a series of "truncate table ..").
