when dealing with very large and many of them, databases in a data center being relocated and and you have to find all the dependancies, hard coded paths in stored procedures and dts packages...
any good tools jump to mind?
i found an article about DLINQ stuff with .net 2005 .... but, not dived into this yet, hoping to find a built toolset.... that can expose and therefore facilitate automating renaming all this stuff.. talking terabytes of total apps files and sql servers
anyone ?
thanks
any good tools jump to mind?
i found an article about DLINQ stuff with .net 2005 .... but, not dived into this yet, hoping to find a built toolset.... that can expose and therefore facilitate automating renaming all this stuff.. talking terabytes of total apps files and sql servers
anyone ?
thanks
posted by:
|
Colorado
|
-
Re: any data migration wizards ?
Tue, June 6, 2006 - 8:58 AMwow. nothing I know of. if you at least know all the fields in the database that have hard coded paths, you could write something with regular expressions to parse it and re-path it. 2005 would be your other option. I am not really a database guy per se, more of a C# guy so all of my solutions would be programmatic.
it sucks to have bad design like that and then deal with its migration. like most of the companies I work for.
