Change connection properties of layers in an .mxd without actually opening it?

Discussion created by jread on Feb 10, 2012
Latest reply on Feb 13, 2012 by jread
Does anyone know if there is a way to do this?

We will soon be changing the name of one of our servers that we have been connecting to for many years.  The problem with this is that we have literally thousands of .mxds with connections saved to the old server name, and they will all be broken when the name goes away.

Rather than have people manually repair all of these .mxds (which would take forever), we would like to write a tool that will search for all files in a directory with the .mxd extension, find any layers in the .mxds with connections to the old server name, and programmatically switch them to the new server name.  All this without actually having to open the .mxds in ArcMap.

Any suggestions would be most-appreciated.