Moving Database

[scotward]

I have moved our SQL Server 2000 databases to a new server. Is there a way to move the DTS packages as well or will I have to re-create them?

 

[wsmall73]

I am pretty sure that you can script the DTS packages out...

 

[MaffewW]

If you want to move single packages you should be able to do file, save as, then specify the new server. The packages are stored in the MSDB database so copying the database over should also work I think, someone else can hopefully confirm this

Good luck

 

[scotward]

Thanks for you help. It seems that the only way to do it is the individual save as, changing the server designation. We had about 50 DTS to move, so I was hoping to do it with one copy.

 

[tlbroadbent]

There is an article at the SQLDTS web site on "Transferring DTS Packages."

http://www.sqldts.com/default.aspx?6,105,204,0,1

If you want to get the best answer for your question read faq183-874 and thread183-468158.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

 

[MaffewW]

Terry, theres no reference to copying or restoring the MSDB database in that article, do you know if that method works?

 

[tlbroadbent]

MSDB contains a lot more than DTS packages. I wouldn't recommend restoring MSDB to another server. The methods described at the SQLDTS site copy from the MSDB.dbo.syspackages table entries to MSDB.dbo.syspackages on the other server. If you want to get the best answer for your question read faq183-874 and thread183-468158.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm