Transfering databases..
-
Good morning..
I have to transfer all data between 2 databases (they have some differencies in their tables) that are in 2 different servers too. The destination database has almost 200 tables and the source table has almost a hundred. Is there a way of doing this task with DTS? Or will I have to create a lot of stored procedures to import data and modify the structure of the destination database to do this?
David Falcão
Microsoft Certified Professional
D'Arte Systems
David Falcão
www.darte.com.br -
You can do it with DTS. No matter how you do it it will take some work. I'd suggest if you can trying to do it in batches of a few tables, easier to work with conceptually and less to redo if something fails.
Andy
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply