October 4, 2002 at 10:05 am
I was wondering if there was a way to just copy over the DTS packages without taking msdb? I can't dettach/attach msdb because I still need it for the other server and I can't backup/restore because its two different versions(enterprise/standard). Any ideas?
October 4, 2002 at 10:40 am
If both SQL Servers are on the same network you should be able to open the DTS package and then save as and change the server name to the server you want to move the package to.
Robert Marda
SQL Server will deliver its data any way you want it
when you give your SQL Programmer enough developing time.
Robert W. Marda
Billing and OSS Specialist - SQL Programmer
MCL Systems
October 4, 2002 at 6:04 pm
You can also export the data from sysdtspackages and import to the other. Or you can do a backup and restore to another name (like tmpRestore) then insert to the msdb sysdtspackages table from the one in the tmpRestore db. Should work well if you have a lot to move but you will need to open each and verify they still work properly based on configuration differences.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply