August 11, 2009 at 11:24 am
Hey everyone,
This is my first project as being a Jr. DBA so if you guys can help me out I'll look golden.
We have a large project moving all of our existing 2000 DBs over to 2005. How to do the migration isn't an issue currently but what is a problem is discovering all the DTS packages that write/read/transform a specific database; we're doing the database moves one by one not completely server by server. If there was more documentation this wouldn't be an issue but considering there are hundreds of DBs to move investigating each package to see which effects the db in question isn't really an option.
Does anyone know of a free tool/process/ect that will make this less painful?
Thanks for any help,
Kraig Turner
August 11, 2009 at 2:32 pm
You could script the packages to vb files and edit them to search for connections. There's at least one script in SSC's script section that will script all the packages in an instance to vb.
You might check out DTS XChange from Pragmaticworks.com http://www.pragmaticworks.com/. It has a profiling function for planning package migration that might show connection info. I've been interested in it, but haven't demo'd it yet.
Greg
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply