https://community.esri.com/t5/arcgis-pro-questions/arcpy-tool-for-modifying-the-source-of-a-query/m-p/1122677#M48649 <P>I have a Pro project with 16 maps that each contain 6 layers. All of the layers are query layers pulling data from the same SQL database. Next month, the database is going to be moved to a production server, which means that I need to change the connection that all 96 layers use. Needless to say, I am not looking forward to that many clicks! Is there something in the arcpy library that I could use to script out the process of repointing these layers? I've never used a script to modify a Pro project before, so I'm mainly looking for ideas on where to start.</P> Fri, 03 Dec 2021 22:20:51 GMT AmyRoust 2021-12-03T22:20:51Z https://community.esri.com/t5/arcgis-pro-questions/arcpy-tool-for-modifying-the-source-of-a-query/m-p/1122677#M48649 <P>I have a Pro project with 16 maps that each contain 6 layers. All of the layers are query layers pulling data from the same SQL database. Next month, the database is going to be moved to a production server, which means that I need to change the connection that all 96 layers use. Needless to say, I am not looking forward to that many clicks! Is there something in the arcpy library that I could use to script out the process of repointing these layers? I've never used a script to modify a Pro project before, so I'm mainly looking for ideas on where to start.</P> Fri, 03 Dec 2021 22:20:51 GMT https://community.esri.com/t5/arcgis-pro-questions/arcpy-tool-for-modifying-the-source-of-a-query/m-p/1122677#M48649 AmyRoust 2021-12-03T22:20:51Z https://community.esri.com/t5/arcgis-pro-questions/arcpy-tool-for-modifying-the-source-of-a-query/m-p/1122725#M48663 <P><A href="https://pro.arcgis.com/en/pro-app/latest/arcpy/mapping/updatingandfixingdatasources.htm" target="_blank">Updating and fixing data sources—ArcGIS Pro | Documentation</A></P><P>seems to be the place to start</P> Sat, 04 Dec 2021 10:53:41 GMT https://community.esri.com/t5/arcgis-pro-questions/arcpy-tool-for-modifying-the-source-of-a-query/m-p/1122725#M48663 DanPatterson 2021-12-04T10:53:41Z https://community.esri.com/t5/arcgis-pro-questions/arcpy-tool-for-modifying-the-source-of-a-query/m-p/1123051#M48710 <P>Thank you, Dan! That's exactly what I needed. I am pleased to find that it works on query layers without any modifications, too.</P> Mon, 06 Dec 2021 17:52:39 GMT https://community.esri.com/t5/arcgis-pro-questions/arcpy-tool-for-modifying-the-source-of-a-query/m-p/1123051#M48710 AmyRoust 2021-12-06T17:52:39Z