July 22, 2015 at 12:21 pm
We need to migrate a SQL 2000 db environment to SQL 2014. As part of the migration there are a lot of DTS packages that needs to be migrated. How/What are the ways I can accomplish this. Please share your experience/thoughts on this. Any help much appreciated as I haven't worked with DTS packages before.
Many thanks.
July 22, 2015 at 12:31 pm
SQL!$@w$0ME (7/22/2015)
We need to migrate a SQL 2000 db environment to SQL 2014. As part of the migration there are a lot of DTS packages that needs to be migrated. How/What are the ways I can accomplish this. Please share your experience/thoughts on this. Any help much appreciated as I haven't worked with DTS packages before.Many thanks.
There's no magic way to migrate DTS to SSIS. Time permitting, I would manually recreate each package, and at the same time, I'd consider what changes can be done to make the package more efficient in SSIS. With DTS, we sometimes had to come up with weird ways to do things, because there was not proper way to do this. SSIS offers much better options.
If you have many packages to migrate, then you might want to consider 3rd party tools for doing so. the only one I'm aware of is from a well known company, Pragmatic Works. http://pragmaticworks.com/Services/MigrationsAndConsolidations/DTS-Migration
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
July 22, 2015 at 12:33 pm
You might be stuck redeveloping them. I don't even think the DTS migration wizard exists in SQL Server 2014(microsoft gave you something like 12 years to migrate them or redevelop them), and even if it did I never had any luck getting it to work in versions it was supported in with any remotely complicated package.
July 22, 2015 at 1:00 pm
Alvin Ramard (7/22/2015)
If you have many packages to migrate, then you might want to consider 3rd party tools for doing so. the only one I'm aware of is from a well known company, Pramatic Works.
AKA Pragmatic Works 🙂
July 22, 2015 at 1:03 pm
I'm with Alvin. In fact I'll be more blunt: the packages should be rewritten.
Many of the things DTS can do cannot be directly translated to SSIS. Hundreds of the things SSIS does are better than DTS, or not even possible, and you don't want to miss the opportunity to take advantage of them by attempting a straight conversion.
July 22, 2015 at 1:04 pm
Phil Parkin (7/22/2015)
Alvin Ramard (7/22/2015)
SQL!$@w$0ME (7/22/2015)
We need to migrate a SQL 2000 db environment to SQL 2014. As part of the migration there are a lot of DTS packages that needs to be migrated. How/What are the ways I can accomplish this. Please share your experience/thoughts on this. Any help much appreciated as I haven't worked with DTS packages before.Many thanks.
There's no magic way to migrate DTS to SSIS. Time permitting, I would manually recreate each package, and at the same time, I'd consider what changes can be done to make the package more efficient in SSIS. With DTS, we sometimes had to come up with weird ways to do things, because there was not proper way to do this. SSIS offers much better options.
If you have many packages to migrate, then you might want to consider 3rd party tools for doing so. the only one I'm aware of is from a well known company, Pramatic Works. http://pragmaticworks.com/Services/MigrationsAndConsolidations/DTS-Migration
AKA Pragmatic Works 🙂
oops. Brain was running faster than my fingers. 😀
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply