Resourcing layers in a new database connection

Question

Hi,

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??

Thanks,

Anonymous User · Answer

Hello

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

Jesús

BBulla · Answer

Martin, Jesus,

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.

Thanks,

Anonymous User · Answer

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.

Best regards

Jesús