March 10, 2005 at 3:15 pm
We wish to move a DTS job to a new server with the same database name.
Is there an easy way to do this?
===============================
Deep in a forest
I found a Shiny Black Box
It wouldn't open.
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
March 11, 2005 at 2:17 am
If you are trying to move a DTS package, edit the package and just save it to the new server.
March 11, 2005 at 7:25 am
You could also save it as a Structured Storage File and then open it on the new server and save it.
March 11, 2005 at 7:57 am
Make sure your connections within the package are changed to reflect the new server name. Or localhost works too.
Here is a good link:
http://vyaskn.tripod.com/sql_server_dts_best_practices.htm - moving dts packages
March 11, 2005 at 7:59 am
If you want to do it via a script.....in Sql Server 7 you can save the package as a file. Then you need to open up this .DTS file and replace the server name with the new server name. When you run the script on the new server it should be correct.
March 11, 2005 at 8:02 am
To fizzleme
You can use Server Compare and Sync tool.
Some comments about Server Compare are below:
The Server Compare application provides a simple and quick way to compare and synchronize two SQL server’s instances. You can compare server configuration parameters and other server objects such as logins, jobs, linked servers, and DTS packages. The application generates the T-SQL synchronization script based on the compare results, and can be run immediately, opened in Toad, or saved to disk. A history of all synchronizations with detailed reports and rollback scripts is available in this tool.
http://www.toadsoft.com/ServerCompareBeta.zip
http://www.toadsoft.com/ServerCompareDemo.exe (flash demo)
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply