http://dotnutz.tribe.net/thread/857f3457-9f75-433f-a6eb-28cfb8d58728?format=rss Tribe.net. Local Connections http://dotnutz.tribe.net/thread/857f3457-9f75-433f-a6eb-28cfb8d58728#06f8dc9b-43d2-4305-8fff-9596b44b61ee thanks jake Sun, 11 Jun 2006 19:48:15 GMT http://dotnutz.tribe.net/thread/857f3457-9f75-433f-a6eb-28cfb8d58728#06f8dc9b-43d2-4305-8fff-9596b44b61ee justin 2006-06-11T19:48:15Z http://dotnutz.tribe.net/thread/857f3457-9f75-433f-a6eb-28cfb8d58728#c91b9224-2ed6-40e5-8f1d-207abb44fe01 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. Tue, 06 Jun 2006 15:58:43 GMT http://dotnutz.tribe.net/thread/857f3457-9f75-433f-a6eb-28cfb8d58728#c91b9224-2ed6-40e5-8f1d-207abb44fe01 Jacob Wilson, 2006-06-06T15:58:43Z http://dotnutz.tribe.net/thread/857f3457-9f75-433f-a6eb-28cfb8d58728#ef78bc5f-1393-4dbf-b68d-7c395d2baec3 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 Tue, 06 Jun 2006 04:48:51 GMT http://dotnutz.tribe.net/thread/857f3457-9f75-433f-a6eb-28cfb8d58728#ef78bc5f-1393-4dbf-b68d-7c395d2baec3 justin 2006-06-06T04:48:51Z