Tribe.net. Local Connections justin http://dotnutz.tribe.net/thread/857f3457-9f75-433f-a6eb-28cfb8d58728#06f8dc9b-43d2-4305-8fff-9596b44b61ee 2006-06-11T19:48:15Z 2006-06-11T19:48:15Z

thanks jake

justin 2006-06-11T19:48:15Z Jacob Wilson, http://dotnutz.tribe.net/thread/857f3457-9f75-433f-a6eb-28cfb8d58728#c91b9224-2ed6-40e5-8f1d-207abb44fe01 2006-06-06T15:58:43Z 2006-06-06T15:58:43Z

wow. 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.

Jacob Wilson, 2006-06-06T15:58:43Z justin http://dotnutz.tribe.net/thread/857f3457-9f75-433f-a6eb-28cfb8d58728#ef78bc5f-1393-4dbf-b68d-7c395d2baec3 2006-06-06T04:48:51Z 2006-06-06T04:48:51Z

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

justin 2006-06-06T04:48:51Z