topic Re: Change database connection for all layers in ArcGIS Pro Questions

Change database connection for all layers

DavidVent — Wed, 17 Jun 2015 09:23:24 GMT

Hello,

how is it in ArcGis Pro possible to change the database connection datasource for all Layers.

Thank your for you help.

Experience: With ArcCatalog it was possible to change mxd files datasouce of layers.

Re: Change database connection for all layers

QuinnFrancis — Wed, 17 Jun 2015 16:20:01 GMT

Hi David,

You can change the data source of layers by right clicking on the layer in the Contents pane > Properties > Source tab > Change data source.

Repair broken data links—ArcGIS Pro | ArcGIS for Professionals

Re: Change database connection for all layers

MichaelRobb — Wed, 17 Jun 2015 19:40:36 GMT

ArcGIS Server question?

You can only do the Change data Source for multiple IF the links are broken. Depending on the situation, one would/could update broken links layer by layer. Update all broken links in Dataframe at once. But what if there are No broken links but want to change the source?

David does not state 'broken layers' anywhere...but rather 'how to change the database conneciton datasource in all layers'

I use py to re-source all layers with the following example:

*caveat: the new datasource must include all the FeatureClasses etc used in the original

Import arcpy

mxd = arcpy.mapping.MapDocument("CURRENT")

mxd.findAndReplaceWorkspacePaths(r"Database Connections\xxxxx.sde",r"Database Connections\xxxx.sde")

Re: Change database connection for all layers

MarcelSt-Germain — Wed, 12 Feb 2020 15:43:40 GMT

Yes, one layer by one layer. For now it's in planing phase for change datasource.

Esri doesn't understand this need so no rush on this.

In the waiting time, i'm doing this by creating a broken link (putting a x before the name of the database) after the project is closed. Then, I repair multiple link with these instructions.

Réparer des liaisons de données endommagées—ArcGIS Pro | Documentation

Hope this will be of some help.

Re: Change database connection for all layers

MikeMillerGIS — Wed, 12 Feb 2020 16:57:19 GMT

Not sure if this will work in you situation, but I sometimes export the map to a mapx, open in notepad++ and use find and replace. Mapx is a json file

Re: Change database connection for all layers

MarcelSt-Germain — Thu, 28 May 2020 13:55:36 GMT

Thanks,

But, just changing the source in pro by creating a broken link is simpler for me. Maybe one day they will include link management.

Re: Change database connection for all layers

MikeMillerGIS — Thu, 28 May 2020 14:03:59 GMT

2.6 has some good stuff coming.

Re: Change database connection for all layers

MarcelSt-Germain — Thu, 28 May 2020 15:20:28 GMT

Yes, can't wait to see. Date of release for 2.6 ?