Transfering data between databases

[Titan]

I'm using SQL 2005 and have three databases.

Live
Test (Restore of Live as of June 2008)
CopyOfTest

I created TEST then used MS KB 871973 (How to setup a test comapny with live
data using SQL Server 7.0, SQL Server 200, or SQL Server 2005) to have live
data in TEST.

CopyOfTest was created the same way.

I want to use the same procedure to update TEST with live data as of last
night but I need data from 10 tables in TEST to remain from the June 2008
copy.

In the past (SQL 2000) I used DTS to move data between databases. How can I
accomplish this task in SQL 2005?

[Todd C]

Forgive us, but what was the methodology described in MS KB 871973?

Can you not just truncate and re-load tables from LIVE Db? If you have
One-to-Many relationships, you might need to re-load in the reverse order
from which you truncate.

I assume these 10 tables are key or cornerstone or lookup tables?
--
Todd C

Post by Titan
I'm using SQL 2005 and have three databases.
Live
Test (Restore of Live as of June 2008)
CopyOfTest
I created TEST then used MS KB 871973 (How to setup a test comapny with live
data using SQL Server 7.0, SQL Server 200, or SQL Server 2005) to have live
data in TEST.
CopyOfTest was created the same way.
I want to use the same procedure to update TEST with live data as of last
night but I need data from 10 tables in TEST to remain from the June 2008
copy.
In the past (SQL 2000) I used DTS to move data between databases. How can I
accomplish this task in SQL 2005?
--
Thanks
Titan