Best (and simplest) practice for refreshing Test data

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 ..").