Post reply

Moving DTS

  • November 9, 2004 at 7:26 am

    #85979

    How to Move DTS pacakages itself from server to another.

    I have 300 DTS pacakages and I am moving my database to another server how should I do it?

    Nick

    I HAVE 300 DTS shall I go and do each manually or I can do all 300 at a time??

  • November 9, 2004 at 7:42 am

    #529451

    Open the DTS Package, Save it as script file.

    copy it to destination server.

    Go to DTS open package and then save on the server.

  • November 9, 2004 at 8:18 am

    #529460

    Thanks Also

    Also I am having issue with replication how to do restore replication on another server, we are using transactional repl.

     

    Thanks

    N...

  • November 9, 2004 at 10:19 am

    #529483

    Generate the scripts for replication and run them on the next server.

  • November 9, 2004 at 11:37 am

    #529493

    A quick search on SQLServerCentral.com yielded the following article on transferring DTS packages -

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

    There were also numerous threads in the forums that showed up in that search.

    My search was simply the words "copy" and "dts" in the search box.  I figure ANYTHING would be better than manually copying 300 DTS packages between servers!!!!

    Steve

  • November 9, 2004 at 11:44 am

    #529495

    OH! OH! OH!  Just found this!!!! (Well, ok, I didn't find it, I found another thread that references it.  Thanks Frank!!!)

    http://www.sqldts.com/default.aspx?105

    Steve

  • November 9, 2004 at 3:07 pm

    #529523

    The DTS Backup package works well,

    There is a switch on one of the panels to retain formatting.

    Don't forget to check it, even so a few will need to be laid out again. Although they work fine.


    KlK

  • November 10, 2004 at 5:20 am

    #529591

    Hi

    I use the DTSbackup2000 utility ( freeware ) .....smooth and easy.....recomandable..

    GKramer

Viewing 8 posts - 1 through 7 (of 7 total)

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