webdork
asked on
Transfer DTS Packages
I'm trying to move a SQL Server instance from on Server to another. I've successfully moved the tables now I want move the DTS packages.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Where is the msdb file?
By default, in C:\Program Files\Microsoft SQL Server\MSSQL\Data or something like that. You need the .mdf (data) and the .ldf (log) files. This will also copy SQL Server agent stuff, maintenance plans and the like, so given what you are trying to achieve, it might work quite well. Do back up the old files before you start though ...
Or, save directly to the new server (using Save As in the DTS designer).
Stop the MS SQL Server in the services panel on both computer. Copy the msdb on the new server to a backup directory. Now copy the msdb from the old server to the new server. Restart both services. Your done.