Post reply

Transfering databases..

  • July 15, 2002 at 7:39 am

    #64240

    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

    http://www.darte.com.br


    David Falcão
    www.darte.com.br

  • July 15, 2002 at 7:49 am

    #432695

    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

    http://www.sqlservercentral.com/columnists/awarren/

    Andy
    Connect with me on LinkedIn

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply