Post reply

How to backup DTS packages..

  • August 20, 2007 at 2:19 pm

    #61320

    I have a server migration which needs movement of all the databases, logins, and DTS packages frm the server1 to server2.

     

    All the databases present on server1 will be on server2.

     

    Please suggest me how to move all the SQL Agent jobs and DTS packages..

     

    Please also through some light on Generate Sctipts..

  • August 20, 2007 at 3:26 pm

    #728140

    You can script all SLQ Server Agrnt jobs by right clicking on EM->Management->SQL Server Agent->Jobs and select All Tasks->Generate SQL Script... and select the options you want

    As for DTS Packages you can choose "save as" in each package and:

    1) Replace the old server name with the new server name and click ok which will save the DTS package at the new server

    2) Save package as "Structured Storage File" to local drive. Move files to new server. Open each file through "Data Transformation Services"->Open Package

  • August 20, 2007 at 5:21 pm

    #728154

    Another suggestion for moving DTS packages:

    DTSBackup 2000 is a free tool at http://www.sqldts.com/242.aspx.  It will copy multiple packages so you don't have to open each one and save them individually.

    Greg

    Greg

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

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