If we took our existing SDE database schema and moved it to a new server, how would that effect our existing MXDs?
Would we be able to just resource a single layer, and then all the rest would get resolved, or would we have to resource each layer, one at a time??
a couple of things:
You can try these other approachs (it is not needed to open the mxds):
- Use the "Set Data Source(s)" func. in ArcCatalog to change the datasource of one/selected/all layers in your mxds.
- If all your mxd use the same connection file, change the paramameters of the conections file so it points to the correct database.
Thanks for the options. We are considering some sort of tool to help with repointing the layers. I think as part of the migration from our current Oracle to a new SQL based SDE will also be the renaming of all of our layers. I think that will pose problems with repairing the broken links with just a single-click.
With changing the connection file, how would you do that? I've opened it in a text editor, but it is just jibberish.
Do you mean change from Oracl to SQL Server? Are you going to change the name of the layers or the complete name: databae.schema.name ?
I meant changing the parameters of the connection file directly with ArcCatalog. The connection parameters can vary: DB type, service, user, etc .. but the file name can remain the same.
A python script would be helpfull....