March 16, 2002 at 12:00 am
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/awarren/copyingdtspackagestoadifferentserver.asp>http://www.sqlservercentral.com/columnists/awarren/copyingdtspackagestoadifferentserver.asp
March 18, 2002 at 7:28 am
Red Gate Software are working on a new product to help people out in comparing and synchronizing the different settings between different SQL Servers. It will be called SQL Server Compare. It will compare DTS packages, logins, jobs and server settings. The idea is to save DBAs who have to administer and set up multiple SQL Servers a whole load of time. It should be launched before the end of April. People interested in the Beta (and in influencing what functionality we include) please contact us at: sqlservercompare@red-gate.com
Cheers,
Simon Galbraith
March 20, 2002 at 10:26 am
moving DTS packages is as easy as using save-as and picking the other server...
March 20, 2002 at 11:09 am
Depends on how many you're moving doesn't it? I wrote this after someone asked for help moving more than 200 packages.
Andy
March 20, 2002 at 11:14 am
I haven't had a chance yet to test it, but it is an interesting concept for moving DTS packages that I will have to play with it. Good job.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
March 20, 2002 at 11:39 am
I guess my point was if you have to go in to review each DTS package to check if pathing whatever is correct then file save as works as well as spending the time to get this working. I'm not saying this isn't a slick way to automate if you can be sure. Sorry I didn't express that better the first time.
March 20, 2002 at 1:35 pm
The limitation of the wizard not allowing you to transfer system tables can be overcome by building the package manually.
Transferring DTS Packages
http://www.sqldts.com/main.asp?nav=1,6,204,0
Darren Green
SQLDTS.com | SQLIS.com | Konesans Ltd
March 20, 2002 at 1:50 pm
Retreif - I agree. You either have to spend extra time (possibly anyway) when you build it to make it portable or live with the consequences if/when you have to move it. I figure you could at least do the bulk move, then edit the ones you knew you had to fix, then see whats left!
Darren - thanks for the link. Should have looked there first! Fun to explore though. Have you considered participating in the beta test mentioned above?
Andy
March 20, 2002 at 4:25 pm
I sometimes think only in my world too, I never know what to expect in the package I develop in and maintain. Too many different "styles" to count on any thing working like that. I'm also glad not to be working in app with 200 or more DTS packages transferring data between data sources!
March 20, 2002 at 4:33 pm
March 20, 2002 at 7:53 pm
Great article.
Let me just add my thoughts on minimizing having to edit your dts packages when you move them to a different server.
One way to avoid the need to change all those server connections in dts packages when you move them to another server is to use UDLs. you can setup UDLs in a centtral repository, say a file server and access them from that location. just make sure that you check the "always read properties from UDL file" check box.
March 20, 2002 at 8:23 pm
Thanks for the feedback. UDL's are handy, not just for DTS packages. Every little bit helps later on.
Andy
April 2, 2002 at 7:18 am
Just remember that UDLs are only usefull in SQL 2000 because in SQL 7.0 they where consumed at design-time not run-time.
Darren Green
SQLDTS.com | SQLIS.com | Konesans Ltd
April 4, 2002 at 6:48 am
Having experienced migrating a Data Warehouse from SQL 7.0 to SQL 2000 (a MUST, believe me!), I discovered some very interesting issues with the DTS packages. You will discover that if you attempt to migrate DTS packages from one SQL2000 server to another, you will NOT be able to edit or delete the DTS packages if the new server has a different name....Seems that rather than embed Local in the msdb entries, it hard codes the server names into the entries...Not pretty.
July 25, 2002 at 11:32 am
Does this VB script to move DTS, moves owner id along with the package, because when I use save as
use my userid, and then the developer cannot use it.
Thanks
Anwar
Viewing 15 posts - 1 through 15 (of 40 total)
You must be logged in to reply to this topic. Login to reply