nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Replacing datasource does not work through arcpy

JoeHershman

Writing a script to replace the datasource in a project. I have tried doing this by replacing the .sde file path on the apex object. Tried by replacing at the map level and also at the layer level. none of these methods work. It runs without error but open the project back up and everything still pints to the original source.

Following samples located here:

Updating and fixing data sources—ArcPy | ArcGIS Desktop

Has anyone ever gotten this to actually work?

Encuentra más publicaciones etiquetadas con

Accepted answers

All comments

JeffMoulds

Starting at ArcGIS version 2.6, we improved this workflow so that you can use Enterprise Geodatabase Connection Files in the first parameter of the UpdateConnectionProperties function. Instead of using the above arcpy CIM workaround, you can now do something like the following code sample.

<SPAN class="keyword token">import</SPAN> arcpy 
aprx <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>mp<SPAN class="punctuation token">.</SPAN>ArcGISProject<SPAN class="punctuation token">(</SPAN>r<SPAN class="string token">'C:\Projects\YosemiteNP\Yosemite.aprx'</SPAN><SPAN class="punctuation token">)</SPAN>
aprx<SPAN class="punctuation token">.</SPAN>updateConnectionProperties<SPAN class="punctuation token">(</SPAN>r<SPAN class="string token">'C:\Projects\YosemiteNP\DBConnections\TestGDB.sde'</SPAN><SPAN class="punctuation token">,</SPAN>
                                r<SPAN class="string token">'C:\Projects\YosemiteNP\DBConnections\ProductionGDB.sde'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

More info and code samples can be found here: Updating and fixing data sources—ArcGIS Pro | Documentation

JoeHershman

Hopefully this helps someone in the future. We had to make the changes by hand 6+ months ago

JeffMoulds

The UpdateConnectionProperties doesn't handle different Feature Dataset names (when changing the SQL Server database, the Feature Dataset name changes, e.g. from "myDB.myUSER.myFeatureDataSet" to "myNewDB.myUSER.myFeatureDataSet". We hope to fix this in a future release. Starting in version 2.4, there is a work around using the arcpy cim module. Python CIM access is available which will provide finer-grained access to more settings/capabilities. We dont have data source examples in the help yet, but here is the overview help topic and a video.

Help topic: https://pro.arcgis.com/en/pro-app/arcpy/mapping/python-cim-access.htm

Video: https://www.youtube.com/watch?v=8wgt8bKD0Ww&feature=youtu.be

The following script will update layer data sources from one SQL Server Enterprise Geodatabase to another. It will also handle the differences in feature dataset names between the two databases (see line 49).

<SPAN class="comment token"># Existing Enterprise Geodatabase server and database</SPAN>
oldServer <SPAN class="operator token">=</SPAN> <SPAN class="string token">"ss2014-104"</SPAN>
oldDatabase <SPAN class="operator token">=</SPAN> <SPAN class="string token">"sde1041en"</SPAN>

<SPAN class="comment token"># New Enterprise Geodatabase server and database</SPAN>
newServer <SPAN class="operator token">=</SPAN> <SPAN class="string token">"ss2016-105"</SPAN>
newDatabase <SPAN class="operator token">=</SPAN> <SPAN class="string token">"gdb1051en"</SPAN>

<SPAN class="comment token"># folder to search</SPAN>
folder <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"C:\Temp\Projects"</SPAN> 

<SPAN class="keyword token">import</SPAN> arcpy<SPAN class="punctuation token">,</SPAN> os

<SPAN class="keyword token">for</SPAN> file <SPAN class="keyword token">in</SPAN> os<SPAN class="punctuation token">.</SPAN>listdir<SPAN class="punctuation token">(</SPAN>folder<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
    <SPAN class="keyword token">if</SPAN> os<SPAN class="punctuation token">.</SPAN>path<SPAN class="punctuation token">.</SPAN>splitext<SPAN class="punctuation token">(</SPAN>file<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>lower<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">==</SPAN> <SPAN class="string token">'.aprx'</SPAN><SPAN class="punctuation token">:</SPAN>
        <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>
        <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>f<SPAN class="string token">"APRX      : {file}"</SPAN><SPAN class="punctuation token">)</SPAN>
        aprx <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>mp<SPAN class="punctuation token">.</SPAN>ArcGISProject<SPAN class="punctuation token">(</SPAN>os<SPAN class="punctuation token">.</SPAN>path<SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>folder<SPAN class="punctuation token">,</SPAN> file<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
        <SPAN class="keyword token">for</SPAN> m <SPAN class="keyword token">in</SPAN> aprx<SPAN class="punctuation token">.</SPAN>listMaps<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
            <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>f<SPAN class="string token">"  MAP     : {m.name}"</SPAN><SPAN class="punctuation token">)</SPAN>
            <SPAN class="keyword token">for</SPAN> lyr <SPAN class="keyword token">in</SPAN> m<SPAN class="punctuation token">.</SPAN>listLayers<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
                <SPAN class="keyword token">if</SPAN> lyr<SPAN class="punctuation token">.</SPAN>supports<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"dataSource"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
                    <SPAN class="keyword token">if</SPAN> lyr<SPAN class="punctuation token">.</SPAN>dataSource<SPAN class="punctuation token">.</SPAN>find<SPAN class="punctuation token">(</SPAN>f<SPAN class="string token">"Server={oldServer}"</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">!=</SPAN> <SPAN class="operator token">-</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">:</SPAN>
                        <SPAN class="comment token"># FOUND A LAYER TO UPDATE!</SPAN>
                        <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>f<SPAN class="string token">"    LAYER : {lyr.name} -> UPDATING LAYER'S DATASOURCE!"</SPAN><SPAN class="punctuation token">)</SPAN>
                        
                        <SPAN class="comment token"># Access layer CIM</SPAN>
                        lyrCIM <SPAN class="operator token">=</SPAN> lyr<SPAN class="punctuation token">.</SPAN>getDefinition<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"V2"</SPAN><SPAN class="punctuation token">)</SPAN>
                        dc <SPAN class="operator token">=</SPAN> lyrCIM<SPAN class="punctuation token">.</SPAN>featureTable<SPAN class="punctuation token">.</SPAN>dataConnection
                        
                        <SPAN class="comment token"># Update the connection properties - 3 steps</SPAN>
                        <SPAN class="comment token"># ==========================================</SPAN>
                        
                        <SPAN class="comment token"># 1.) Update the connection string (server, instance, database, version, etc)</SPAN>
                        cs <SPAN class="operator token">=</SPAN> dc<SPAN class="punctuation token">.</SPAN>workspaceConnectionString
                        cs <SPAN class="operator token">=</SPAN> cs<SPAN class="punctuation token">.</SPAN>replace<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"SERVER="</SPAN> <SPAN class="operator token">+</SPAN> oldServer<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"SERVER="</SPAN> <SPAN class="operator token">+</SPAN> newServer<SPAN class="punctuation token">)</SPAN>
                        cs <SPAN class="operator token">=</SPAN> cs<SPAN class="punctuation token">.</SPAN>replace<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"INSTANCE=sde:sqlserver:"</SPAN> <SPAN class="operator token">+</SPAN> oldServer<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"INSTANCE=sde:sqlserver:"</SPAN> <SPAN class="operator token">+</SPAN> newServer<SPAN class="punctuation token">)</SPAN>
                        cs <SPAN class="operator token">=</SPAN> cs<SPAN class="punctuation token">.</SPAN>replace<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"DB_CONNECTION_PROPERTIES="</SPAN> <SPAN class="operator token">+</SPAN> oldServer<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"DB_CONNECTION_PROPERTIES="</SPAN> <SPAN class="operator token">+</SPAN> newServer<SPAN class="punctuation token">)</SPAN>
                        cs <SPAN class="operator token">=</SPAN> cs<SPAN class="punctuation token">.</SPAN>replace<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"DATABASE="</SPAN> <SPAN class="operator token">+</SPAN> oldDatabase<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"DATABASE="</SPAN> <SPAN class="operator token">+</SPAN> newDatabase<SPAN class="punctuation token">)</SPAN>
                        cs <SPAN class="operator token">=</SPAN> cs<SPAN class="punctuation token">.</SPAN>replace<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"VERSION=sde.DEFAULT"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"VERSION=dbo.DEFAULT"</SPAN><SPAN class="punctuation token">)</SPAN>
                        dc<SPAN class="punctuation token">.</SPAN>workspaceConnectionString <SPAN class="operator token">=</SPAN> cs
                        
                        <SPAN class="comment token"># 2.) Update the dataset name</SPAN>
                        <SPAN class="comment token">#     E.g. change "myDB.myUSER.myFeatureClass" to "myNewDB.myUSER.myFeatureClass"</SPAN>
                        dc<SPAN class="punctuation token">.</SPAN>dataset <SPAN class="operator token">=</SPAN> dc<SPAN class="punctuation token">.</SPAN>dataset<SPAN class="punctuation token">.</SPAN>replace<SPAN class="punctuation token">(</SPAN>oldDatabase<SPAN class="punctuation token">,</SPAN> newDatabase<SPAN class="punctuation token">)</SPAN>
                        
                        <SPAN class="comment token"># 3.) If the data is in a Feature Dataset, then update it  </SPAN>
                        <SPAN class="comment token">#     E.g. change "myDB.myUSER.myFeatureDataSet" to "myNewDB.myUSER.myFeatureDataSet"</SPAN>
                        <SPAN class="keyword token">if</SPAN> hasattr<SPAN class="punctuation token">(</SPAN>dc<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"featureDataset"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
                            dc<SPAN class="punctuation token">.</SPAN>featureDataset <SPAN class="operator token">=</SPAN> dc<SPAN class="punctuation token">.</SPAN>featureDataset<SPAN class="punctuation token">.</SPAN>replace<SPAN class="punctuation token">(</SPAN>oldDatabase<SPAN class="punctuation token">,</SPAN> newDatabase<SPAN class="punctuation token">)</SPAN>
                        
                        <SPAN class="comment token"># Update layer CIM</SPAN>
                        lyr<SPAN class="punctuation token">.</SPAN>setDefinition<SPAN class="punctuation token">(</SPAN>lyrCIM<SPAN class="punctuation token">)</SPAN>
                        
                    <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
                        <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>f<SPAN class="string token">"    LAYER : {lyr.name}"</SPAN><SPAN class="punctuation token">)</SPAN>
                    
        <SPAN class="comment token"># save a copy of the updated APRX</SPAN>
        aprx<SPAN class="punctuation token">.</SPAN>saveACopy<SPAN class="punctuation token">(</SPAN>os<SPAN class="punctuation token">.</SPAN>path<SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>folder<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'output'</SPAN><SPAN class="punctuation token">,</SPAN> file<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
        
<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">''</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'+++++++++'</SPAN><SPAN class="punctuation token">)</SPAN> 
<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'+ DONE! +'</SPAN><SPAN class="punctuation token">)</SPAN> 
<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'+++++++++'</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

JoeHershman

Thanks.

Anonymous User

It seems there is a bug in arcpy.mp.updateConnectionProperties where if you are trying to update feature class is in a feature dataset in an Enterprise Geodatabase (.sde) to another EGDB. According to this thread Esri knows about it and will fix in future release (unconfirmed) https://community.esri.com/thread/228083-updating-connection-info-via-python-from-sde-to-file-geodb-with-a-feature-dataset

JoeHershman

Was hoping to not have to go down that path if possible. But likely the only route, although if it is a bug (or unsupported feature) as I suspect, it is doubtful I would have any resolution within a timeframe that would be useful. Not to mention that amount of time that will need to be spent with tech support repeating everything in this thread with multiple people

JoeHershman

Thank you for the sample, but this is different from what I am doing. There is a difference in sql server in that it has a database name. This is different from changing an instance, which is what is being done above. Because of how the data connection seems to be maintaining the database name, it is not making the change correctly. If I where only changing the server or instance but keeping the database name the same this issue does not arise. I can change from dbServer01 to dbServer02 as long as the name of the Sql Server database is the same

In Sql Server the identifier is not 'Database/Instance', it is 'Server/Instance' or usually just 'Server' because in most cases the default instance is used which does not have an identifier

Thanks

-Joe

SrihariDarapaneni

This sample code i am running sucessfully on oracle db

import arcpy, os, pprint
import traceback
from os import path

project_folder = r'D:\Project\'
project_file = r'sample.aprx'

project_path = os.path.join(project_folder, project_file)
aprx = arcpy.mp.ArcGISProject(project_path)

Source_fc = 'SM.sm__installs'
target_fc = 'SM.sm__installs'

targetInstance = 'sde:oracle$sde:oracle11g:ABCD_P'
targetUser = 'sde'
targetPwd = 'sde123'

for map in aprx.listMaps():
   for layer in map.listLayers():
      if layer.connectionProperties == None:
         continue

   sourceConn = layer.connectionProperties
   targetConn = sourceConn
   print(sourceConn)
   targetConn['dataset'] = target_fc #which is not required if pointing to same fc in other database
   targetConn['connection_info']['instance'] = targetInstance
   targetConn['connection_info']['user'] = targetUser
   targetConn['connection_info']['password'] =targetPwd
   #targetConn['connection_info']['db_connection_properties'] ='xDatabase/xInstance' # this is required for SQL db
   print(targetConn)
   layer.updateConnectionProperties(sourceConn, targetConn)

aprx.save()
del aprx

curtvprice

Have you asked Esri support yet? They can probably explain what workflow you need.

JoeHershman

If you have this working please post the exact code that works. I have changed to set the dataset to the unqualified name of the dataset as you suggest and the result is the same, only the layer at the top level will change anything in feature dataset does not update correctly.

Your post that shows the json is unclear, it shows setting the database item to FeatureClassName which makes no sense, although I did try just in case. This is not Oracle so there is no instance in the way Oracle uses instance, it is a different database in the same Sql Server 'Instance'

<SPAN class="comment token"># source</SPAN>
<SPAN class="punctuation token">{</SPAN><SPAN class="string token">'connection_info'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="string token">'authentication_mode'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'DBMS'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'database'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Staging'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'db_connection_properties'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'portal07'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'dbclient'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'sqlserver'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'instance'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'sde:sqlserver:portal07'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'password'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'<*********>'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'server'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'portal07'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'user'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'gis'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'version'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'sde.DEFAULT'</SPAN><SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">,</SPAN>
 <SPAN class="string token">'dataset'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Staging.GIS.PipelineAssembly'</SPAN><SPAN class="punctuation token">,</SPAN>
 <SPAN class="string token">'workspace_factory'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'SDE'</SPAN><SPAN class="punctuation token">}</SPAN>

<SPAN class="comment token">#target</SPAN>
<SPAN class="punctuation token">{</SPAN><SPAN class="string token">'connection_info'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="string token">'authentication_mode'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'DBMS'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'database'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'fort_collins'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'db_connection_properties'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'portal07'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'dbclient'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'sqlserver'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'instance'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'sde:sqlserver:portal07'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'password'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'gis'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'server'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'portal07'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'user'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'gis'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'version'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'sde.DEFAULT'</SPAN><SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">,</SPAN>
 <SPAN class="string token">'dataset'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'PipelineAssembly'</SPAN><SPAN class="punctuation token">,</SPAN>
 <SPAN class="string token">'workspace_factory'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'SDE'</SPAN><SPAN class="punctuation token">}</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

I have run the code replacing everything and also just running with 'database' and 'dataset' being changed. Both have the same result, classes within a Feature Dataset become invalid and it shows the Feature Dataset incorrect. I ran the same code a second time changing the database back and when this is done the datasource becomes valid again (because now the Feature Dataset is correct). I see no way to change the Feature Dataset to an unqualified name so do not know what I am missing

Again, if you have a working sample fo changing the database please post. I am thinking perhaps there is a difference with Oracle and Sql Server but I could just be missing something.

Thanks

SrihariDarapaneni

There are lot of confusions over names dataset from arcpy's 'connection_info' to desktop ArcGIS Pro layer properties.

arcpy's 'connection_info' dataset means featureclass name but in desktop ArcGIS Pro is different.

only instance, and db_connection_properties in connection_info has to be set properly, as you know, in database and in Arc Pro property there is know value for dataset , if you keep instace, db_connection_properties properly and dataset as featureclass name it will resolve the issue.

and if change feature class name in layer properties then it fine dont worry about other values, still esri has to modify their layer property dialog box.

It is not important to this method where featureclass is whether it is in dataset(Arc Catalog/ArcMap terminolgy) or at root level.

I am successfully changing databases with is method without watching layer property dialog box.

JoeHershman

Just for yucks I ran the same code on a Feature Class at the root level instead of in a Feature Dataset. In this scenario the the update does work. Still odd because in the properties window the instance setting is inconsistent

In the one that was changed:

When set by adding in standard methods it looks like this where the instance shows the database name, but through code it has the path. I did try to change set the instance to use the database name in the target dictionary but that gave a bad datasource

JoeHershman

I notice I did not set the validate parameter to false. I changed this to

layer<SPAN class="punctuation token">.</SPAN>updateConnectionProperties<SPAN class="punctuation token">(</SPAN>source_properties<SPAN class="punctuation token">,</SPAN> target_properties<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">''</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="token boolean">False</SPAN><SPAN class="punctuation token">)</SPAN>‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

I am now even more convinced replacing database does not work, because this makes the changes but breaks the connection, because it is not possible to update the fully qualified name of the Feature Dataset through this method.

Using this the new output when evaluating the layer.connectionProperties is what was hoped for

<SPAN class="punctuation token">{</SPAN><SPAN class="string token">'connection_info'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="string token">'authentication_mode'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'DBMS'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'database'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'fort_collins'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'db_connection_properties'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'portal07'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'dbclient'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'sqlserver'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'instance'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'sde:sqlserver:portal07'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'password'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'<*********>'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'server'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'portal07'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'user'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'gis'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'version'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'sde.DEFAULT'</SPAN><SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">,</SPAN>
 <SPAN class="string token">'dataset'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'fort_collins.GIS.PipelineAssembly'</SPAN><SPAN class="punctuation token">,</SPAN>
 <SPAN class="string token">'workspace_factory'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'SDE'</SPAN><SPAN class="punctuation token">}</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Now the dataset is invalid.

I notice a couple things. There is no longer a Database shown in the list after the update. The name of the Feature Dataset is still the old name. However, there is nothing in the connectionProperties that allows one to update the Feature Dataset specifically unless I am not seeing it somewhere.

I am at a loss, I am fully convinced esri did not think of this need but shaking my head if that is the case because to me it seems one of the most useful reasons one would want to change a datasource

JoeHershman

This is the original code with debug output to show exactly what is being used as source and replace. This is what happens running inside Pro. I have moved the print output inline to help, also shown at bottom.

The first print shows the connectionProperties on the layer before running any code.
The next shows the same thing but as variable used in the updateConnectionProperties method
The next shows the replace variable. Unless I am not seeing something this is replacing every parameter just using the new settings.
- The database is replaced with the new database name
- The dataset is replaced with the new fully qualified name of the dataset
The final shows the layer.connectionProperties immediately after the replace operation
I did run with the 'workspace_factory' property but included but accidentally copied this output and too much effort to redo the entire code shot below

After that I break out to simplify and only show the single layer

aprx <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>mp<SPAN class="punctuation token">.</SPAN>ArcGISProject<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"CURRENT"</SPAN><SPAN class="punctuation token">)</SPAN>
db_source <SPAN class="operator token">=</SPAN> <SPAN class="string token">'Staging'</SPAN>
db_target <SPAN class="operator token">=</SPAN> <SPAN class="string token">'fort_collins'</SPAN>

<SPAN class="keyword token">for</SPAN> map <SPAN class="keyword token">in</SPAN> aprx<SPAN class="punctuation token">.</SPAN>listMaps<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
    <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>map<SPAN class="punctuation token">.</SPAN>name<SPAN class="punctuation token">)</SPAN>
    <SPAN class="keyword token">for</SPAN> layer <SPAN class="keyword token">in</SPAN> map<SPAN class="punctuation token">.</SPAN>listLayers<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
        <SPAN class="keyword token">if</SPAN> layer<SPAN class="punctuation token">.</SPAN>connectionProperties <SPAN class="operator token">==</SPAN> None<SPAN class="punctuation token">:</SPAN> 
            <SPAN class="keyword token">continue</SPAN>
        <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>layer<SPAN class="punctuation token">.</SPAN>name<SPAN class="punctuation token">)</SPAN>
        pprint<SPAN class="punctuation token">.</SPAN>pprint<SPAN class="punctuation token">(</SPAN>layer<SPAN class="punctuation token">.</SPAN>connectionProperties<SPAN class="punctuation token">)</SPAN>
<SPAN class="punctuation token">{</SPAN><SPAN class="string token">'connection_info'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="string token">'authentication_mode'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'DBMS'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'database'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Staging'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'db_connection_properties'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'portal07'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'dbclient'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'sqlserver'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'instance'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'sde:sqlserver:portal07'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'password'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'<*********>'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'server'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'portal07'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'user'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'gis'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'version'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'sde.DEFAULT'</SPAN><SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">,</SPAN>
 <SPAN class="string token">'dataset'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Staging.GIS.PipelineAssembly'</SPAN><SPAN class="punctuation token">,</SPAN>
 <SPAN class="string token">'workspace_factory'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'SDE'</SPAN><SPAN class="punctuation token">}</SPAN>

        <SPAN class="comment token">#replace db name in fully qualified dataset name</SPAN>
        source_dataset <SPAN class="operator token">=</SPAN> str<SPAN class="punctuation token">(</SPAN>layer<SPAN class="punctuation token">.</SPAN>connectionProperties<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'dataset'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
        target_dataset <SPAN class="operator token">=</SPAN> str<SPAN class="punctuation token">(</SPAN>source_dataset<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>replace<SPAN class="punctuation token">(</SPAN>db_source<SPAN class="punctuation token">,</SPAN> db_target<SPAN class="punctuation token">)</SPAN>

        source_info <SPAN class="operator token">=</SPAN> layer<SPAN class="punctuation token">.</SPAN>connectionProperties<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'connection_info'</SPAN><SPAN class="punctuation token">]</SPAN>
      
        <SPAN class="comment token"># target_info is connection_info dictionary with new parameters</SPAN>
        target_info <SPAN class="operator token">=</SPAN> dict<SPAN class="punctuation token">(</SPAN>source_info<SPAN class="punctuation token">)</SPAN>
        target_info<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'database'</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> db_target
        target_info<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'user'</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="string token">'gis'</SPAN>
        target_info<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'password'</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="string token">'gis'</SPAN>

        <SPAN class="comment token"># setup source and target connection_properties</SPAN>
        source_properties <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="string token">'connection_info'</SPAN><SPAN class="punctuation token">:</SPAN> source_info<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'dataset'</SPAN><SPAN class="punctuation token">:</SPAN> source_dataset<SPAN class="punctuation token">}</SPAN>
        target_properties <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="string token">'connection_info'</SPAN><SPAN class="punctuation token">:</SPAN> target_info<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'dataset'</SPAN><SPAN class="punctuation token">:</SPAN> target_dataset<SPAN class="punctuation token">}</SPAN>

        pprint<SPAN class="punctuation token">.</SPAN>pprint<SPAN class="punctuation token">(</SPAN>source_properties<SPAN class="punctuation token">)</SPAN>
<SPAN class="punctuation token">{</SPAN><SPAN class="string token">'connection_info'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="string token">'authentication_mode'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'DBMS'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'database'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Staging'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'db_connection_properties'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'portal07'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'dbclient'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'sqlserver'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'instance'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'sde:sqlserver:portal07'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'password'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'<*********>'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'server'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'portal07'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'user'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'gis'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'version'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'sde.DEFAULT'</SPAN><SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">,</SPAN>
 <SPAN class="string token">'dataset'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Staging.GIS.PipelineAssembly'</SPAN><SPAN class="punctuation token">}</SPAN>
        pprint<SPAN class="punctuation token">.</SPAN>pprint<SPAN class="punctuation token">(</SPAN>target_properties<SPAN class="punctuation token">)</SPAN>
<SPAN class="punctuation token">{</SPAN><SPAN class="string token">'connection_info'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="string token">'authentication_mode'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'DBMS'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'database'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'fort_collins'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'db_connection_properties'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'portal07'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'dbclient'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'sqlserver'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'instance'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'sde:sqlserver:portal07'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'password'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'gis'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'server'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'portal07'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'user'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'gis'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'version'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'sde.DEFAULT'</SPAN><SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">,</SPAN>
 <SPAN class="string token">'dataset'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'fort_collins.GIS.PipelineAssembly'</SPAN><SPAN class="punctuation token">}</SPAN>

        layer<SPAN class="punctuation token">.</SPAN>updateConnectionProperties<SPAN class="punctuation token">(</SPAN>source_properties<SPAN class="punctuation token">,</SPAN> target_properties<SPAN class="punctuation token">)</SPAN>

        pprint<SPAN class="punctuation token">.</SPAN>pprint<SPAN class="punctuation token">(</SPAN>layer<SPAN class="punctuation token">.</SPAN>connectionProperties<SPAN class="punctuation token">)</SPAN>
<SPAN class="punctuation token">{</SPAN><SPAN class="string token">'connection_info'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="string token">'authentication_mode'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'DBMS'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'database'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Staging'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'db_connection_properties'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'portal07'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'dbclient'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'sqlserver'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'instance'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'sde:sqlserver:portal07'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'password'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'<*********>'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'server'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'portal07'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'user'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'gis'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'version'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'sde.DEFAULT'</SPAN><SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">,</SPAN>
 <SPAN class="string token">'dataset'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Staging.GIS.PipelineAssembly'</SPAN><SPAN class="punctuation token">,</SPAN>
 <SPAN class="string token">'workspace_factory'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'SDE'</SPAN><SPAN class="punctuation token">}</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍
        <SPAN class="keyword token">break</SPAN>
    <SPAN class="keyword token">break</SPAN>
Map
Pipeline Assembly

<SPAN class="comment token"># connectionProperties on layer</SPAN>
<SPAN class="punctuation token">{</SPAN><SPAN class="string token">'connection_info'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="string token">'authentication_mode'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'DBMS'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'database'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Staging'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'db_connection_properties'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'portal07'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'dbclient'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'sqlserver'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'instance'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'sde:sqlserver:portal07'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'password'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'<*********>'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'server'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'portal07'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'user'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'gis'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'version'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'sde.DEFAULT'</SPAN><SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">,</SPAN>
 <SPAN class="string token">'dataset'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Staging.GIS.PipelineAssembly'</SPAN><SPAN class="punctuation token">,</SPAN>
 <SPAN class="string token">'workspace_factory'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'SDE'</SPAN><SPAN class="punctuation token">}</SPAN>

<SPAN class="comment token">#source_properties variable</SPAN>
<SPAN class="punctuation token">{</SPAN><SPAN class="string token">'connection_info'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="string token">'authentication_mode'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'DBMS'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'database'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Staging'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'db_connection_properties'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'portal07'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'dbclient'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'sqlserver'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'instance'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'sde:sqlserver:portal07'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'password'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'<*********>'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'server'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'portal07'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'user'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'gis'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'version'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'sde.DEFAULT'</SPAN><SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">,</SPAN>
 <SPAN class="string token">'dataset'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Staging.GIS.PipelineAssembly'</SPAN><SPAN class="punctuation token">}</SPAN>

<SPAN class="comment token">#target_properties variable</SPAN>
<SPAN class="punctuation token">{</SPAN><SPAN class="string token">'connection_info'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="string token">'authentication_mode'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'DBMS'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'database'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'fort_collins'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'db_connection_properties'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'portal07'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'dbclient'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'sqlserver'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'instance'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'sde:sqlserver:portal07'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'password'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'gis'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'server'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'portal07'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'user'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'gis'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'version'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'sde.DEFAULT'</SPAN><SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">,</SPAN>
 <SPAN class="string token">'dataset'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'fort_collins.GIS.PipelineAssembly'</SPAN><SPAN class="punctuation token">}</SPAN>

<SPAN class="comment token">#after update layer.connectionProperties</SPAN>
<SPAN class="punctuation token">{</SPAN><SPAN class="string token">'connection_info'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="string token">'authentication_mode'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'DBMS'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'database'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Staging'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'db_connection_properties'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'portal07'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'dbclient'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'sqlserver'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'instance'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'sde:sqlserver:portal07'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'password'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'<*********>'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'server'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'portal07'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'user'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'gis'</SPAN><SPAN class="punctuation token">,</SPAN>
                     <SPAN class="string token">'version'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'sde.DEFAULT'</SPAN><SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">,</SPAN>
 <SPAN class="string token">'dataset'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Staging.GIS.PipelineAssembly'</SPAN><SPAN class="punctuation token">,</SPAN>
 <SPAN class="string token">'workspace_factory'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'SDE'</SPAN><SPAN class="punctuation token">}</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

MatthewDriscoll

I see. I think its more important to change the db_connection_properties. Really you should probably change all the connectionProperties when changing to a different databases, it seems you are only changing some of the properties.

Try to find and replace every single property. See the ESRI sample below which includes every property, without joins or relates, I believe.

<SPAN class="punctuation token">{</SPAN><SPAN class="string token">'connection_info'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="string token">'authentication_mode'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'OSA'</SPAN><SPAN class="punctuation token">,</SPAN>                     
                     <SPAN class="string token">'database'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Uhuru'</SPAN><SPAN class="punctuation token">,</SPAN>                     
                     <SPAN class="string token">'db_connection_properties'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Dunbar'</SPAN><SPAN class="punctuation token">,</SPAN>                     
                     <SPAN class="string token">'dbclient'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'sqlserver'</SPAN><SPAN class="punctuation token">,</SPAN>                     
                     <SPAN class="string token">'instance'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'sde:sqlserver:Dunbar'</SPAN><SPAN class="punctuation token">,</SPAN>                     
                     <SPAN class="string token">'password'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'*********'</SPAN><SPAN class="punctuation token">,</SPAN>                     
                     <SPAN class="string token">'server'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Dunbar'</SPAN><SPAN class="punctuation token">,</SPAN>                     
                     <SPAN class="string token">'user'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Sly'</SPAN><SPAN class="punctuation token">,</SPAN>                     
                     <SPAN class="string token">'version'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'sde.DEFAULT'</SPAN><SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">,</SPAN> 
<SPAN class="string token">'dataset'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Uhuru.SDE.RangerStations'</SPAN><SPAN class="punctuation token">,</SPAN> 
<SPAN class="string token">'workspace_factory'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'SDE'</SPAN><SPAN class="punctuation token">}</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

JoeHershman

Seems that maybe the title needs to be changed to cannot replace the 'database' property. I ran your code switching out the 'user' and 'password' and it works as expected. But it does not work if changing the 'database' property. This was one reason I thought going to the layer level might work better because then I could also change the 'dataset' property to the new fully qualified dataset.

In ArcMap I had a process to script changing the datasource and then to publish the maps, save the copy, and publish feature services to a new server from the new maps. This provided a very streamlined approach to moving from dev to qa to prod. As there are over 20 maps this was a big time saver. At this point we will need to do this manually as it seems one cannot change the database through python

SrihariDarapaneni

Few observations I found from you code,

target_info; may be you can use replace method; arcpy 
don't have rich JSON functions. 

this is source connection property  
{'dataset': 'FeatureClass Name, 'workspace_factory': 'SDE', 'connection_info': 
{'authentication_mode': 'DBMS', 'database': 'FeatureClassName', 'dbclient': 'oracle', 
'db_connection_properties': 'database/instance', 'password': '<*********>', 
'instance': 'sde:'database/instance', 'server': 'serverName',
 'user': 'user', 'version': 'SDE.DEFAULT'}}

but target_properties is{'dataset': 'FeatureClass Name, 'workspace_factory': 'SDE', 'connection_info': 
{'authentication_mode': 'DBMS', 'database': 'FeatureClassName', 'dbclient': 'oracle', 
'db_connection_properties': 'database/instance', 'password': '<****>', 
'instance': 'sde:'database/instance', 'server': 'serverName',
 'user': 'user', 'version': 'SDE.DEFAULT'},{'dataset': 'FeatureClass Name, 
'workspace_factory': 'SDE', 'connection_info': {'authentication_mode': 'DBMS', 
'database': 'FeatureClassName', 'dbclient': 'oracle', 
'db_connection_properties': 'database/instance', 'password': '<****>', 
'instance': 'sde:'database/instance', 'server': 'serverName',
 'user': 'user', 'version': 'SDE.DEFAULT'}}

Make sure db_connection_properties,'instance' has to be set properly based on 
database changes. 

And Also

db_source = has to be existing feature class name, 
db_target = has to be target feature class name

most of the time both are same when we doing one database connection to 
other connection. 

- Problem occurring only when you replacing source info to target info values

- more over tool is not giving errors, this may be bug. 

I am able run the tools successfully.  <CODE>target_info<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">[</SPAN><SPAN class="" style="color: #669900; border: 0px; font-weight: inherit;">'database'</SPAN><SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">]</SPAN> <SPAN class="" style="color: #a67f59; background: rgba(255, 255, 255, 0.5); border: 0px; font-weight: inherit;">=</SPAN> db_target ----- this is not setting the property instead it is 
adding additional values to

JoeHershman

I tried all methods, I only put the sample code for this approach because it is the most granular so I believe as a last effort would show that this does not work. Also my sample has debug code removed as this is not really relevant to what is being done in the functional code. But in all approaches I did as you suggest and had debug code to check if the layer.connectionProperties was changing prior to saving.

Documentation for the method also states:

When working with enterprise geodatabase layers, a path to a database connection (.SDE) file can only be used for the new_connection_info parameter. The information in the .SDE file can't be used for the current_connection_info parameter because the connection information is coming from the layer in the project, not the file. A more complete discussion and examples of connection property dictionaries are also provided in the connectionProperties section below.

Although there is no mention of what should be used as the current_connection_info in this case:

But this has been tried without success

<SPAN class="keyword token">import</SPAN> arcpy<SPAN class="punctuation token">,</SPAN> os<SPAN class="punctuation token">,</SPAN> pprint
<SPAN class="keyword token">import</SPAN> traceback
<SPAN class="keyword token">from</SPAN> os <SPAN class="keyword token">import</SPAN> path

project_folder <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'D:\...'</SPAN>
project_file <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'project.aprx'</SPAN>

project_path <SPAN class="operator token">=</SPAN> os<SPAN class="punctuation token">.</SPAN>path<SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>project_folder<SPAN class="punctuation token">,</SPAN> project_file<SPAN class="punctuation token">)</SPAN>
aprx <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>mp<SPAN class="punctuation token">.</SPAN>ArcGISProject<SPAN class="punctuation token">(</SPAN>project_path<SPAN class="punctuation token">)</SPAN>

current <SPAN class="operator token">=</SPAN> <SPAN class="string token">'full path to currect .sde file'</SPAN>
new <SPAN class="operator token">=</SPAN> <SPAN class="string token">'full path to new .sde file'</SPAN>

aprx<SPAN class="punctuation token">.</SPAN>updateConnectionProperties<SPAN class="punctuation token">(</SPAN>current<SPAN class="punctuation token">,</SPAN> new<SPAN class="punctuation token">,</SPAN> <SPAN class="token boolean">False</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="token boolean">True</SPAN><SPAN class="punctuation token">)</SPAN>
aprx<SPAN class="punctuation token">.</SPAN>save<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">del</SPAN> aprx<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

I have run inside of Pro and run from Visual Studio, neither working.

MatthewDriscoll

This is what I use, first I get the current connection info and then replace it using parameters.

import arcpy


arcpy<SPAN class="punctuation token">.</SPAN><SPAN class="token function">SetProgressor</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"1234"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"working on updating sources..."</SPAN><SPAN class="punctuation token">)</SPAN>

aprx <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>mp<SPAN class="punctuation token">.</SPAN><SPAN class="token function">ArcGISProject</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"CURRENT"</SPAN><SPAN class="punctuation token">)</SPAN>

find_dict <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="string token">'connection_info'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="string token">'user'</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="string token">'username'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'password'</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="string token">'userpassword'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'version'</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="string token">'sde.DEFAULT'</SPAN><SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'workspace_factory'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'SDE'</SPAN><SPAN class="punctuation token">}</SPAN>

newuser <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN><SPAN class="token function">GetParameterAsText</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">)</SPAN>
newpassword <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN><SPAN class="token function">GetParameterAsText</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">)</SPAN>
version <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN><SPAN class="token function">GetParameterAsText</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">)</SPAN>


replace_dict <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="string token">'connection_info'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="string token">'user'</SPAN><SPAN class="punctuation token">:</SPAN>newuser<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'password'</SPAN><SPAN class="punctuation token">:</SPAN>newpassword<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'version'</SPAN><SPAN class="punctuation token">:</SPAN>version<SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'workspace_factory'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'SDE'</SPAN><SPAN class="punctuation token">}</SPAN>

aprx<SPAN class="punctuation token">.</SPAN><SPAN class="token function">updateConnectionProperties</SPAN><SPAN class="punctuation token">(</SPAN>find_dict<SPAN class="punctuation token">,</SPAN> replace_dict<SPAN class="punctuation token">,</SPAN><SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN>False<SPAN class="punctuation token">)</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

curtvprice

Seems to me like the updateConnectionProperties method on ArcGISProject (the "apex object"?) is the one you want, as that would be a lot less work!

I suggest going back to trying the method on the project, and add some debug code to your script to verify the connection properties are getting modified at all before you bother to .save(). Another thing to try is set the validate parameter of updateConnectionProperties to False and see what happens.

If [validate is] set to True, the connection properties will only be updated if the new_connection_info value is a valid connection. If it is not valid, the connection will not be replaced. If set to False, the method will set all connections to match the new_connection_info, regardless of a valid match. In this case, if a match does not exist, then the data sources would be broken.
(The default value is True)

JoeHershman

This is the basic code that is being used

<SPAN class="keyword token">import</SPAN> arcpy<SPAN class="punctuation token">,</SPAN> os<SPAN class="punctuation token">,</SPAN> pprint
<SPAN class="keyword token">import</SPAN> traceback
<SPAN class="keyword token">from</SPAN> os <SPAN class="keyword token">import</SPAN> path

project_folder <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'D:\...'</SPAN>
project_file <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'project.aprx'</SPAN>

project_path <SPAN class="operator token">=</SPAN> os<SPAN class="punctuation token">.</SPAN>path<SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>project_folder<SPAN class="punctuation token">,</SPAN> project_file<SPAN class="punctuation token">)</SPAN>
aprx <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>mp<SPAN class="punctuation token">.</SPAN>ArcGISProject<SPAN class="punctuation token">(</SPAN>project_path<SPAN class="punctuation token">)</SPAN>

db_source <SPAN class="operator token">=</SPAN> <SPAN class="string token">'source'</SPAN>
db_target <SPAN class="operator token">=</SPAN> <SPAN class="string token">'target'</SPAN>

<SPAN class="keyword token">for</SPAN> map <SPAN class="keyword token">in</SPAN> aprx<SPAN class="punctuation token">.</SPAN>listMaps<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
    <SPAN class="keyword token">for</SPAN> layer <SPAN class="keyword token">in</SPAN> map<SPAN class="punctuation token">.</SPAN>listLayers<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
        <SPAN class="keyword token">if</SPAN> layer<SPAN class="punctuation token">.</SPAN>connectionProperties <SPAN class="operator token">==</SPAN> None<SPAN class="punctuation token">:</SPAN> 
            <SPAN class="keyword token">continue</SPAN>

        <SPAN class="comment token">#replace db name in fully qualified dataset name</SPAN>
        source_dataset <SPAN class="operator token">=</SPAN> layer<SPAN class="punctuation token">.</SPAN>connectionProperties<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'dataset'</SPAN><SPAN class="punctuation token">]</SPAN>
        target_dataset <SPAN class="operator token">=</SPAN> str<SPAN class="punctuation token">(</SPAN>source_dataset<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>replace<SPAN class="punctuation token">(</SPAN>db_source<SPAN class="punctuation token">,</SPAN> db_target<SPAN class="punctuation token">)</SPAN>

        source_info <SPAN class="operator token">=</SPAN> layer<SPAN class="punctuation token">.</SPAN>connectionProperties<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'connection_info'</SPAN><SPAN class="punctuation token">]</SPAN>
        
        <SPAN class="comment token"># target_info is connection_info dictionary with new parameters</SPAN>
        target_info <SPAN class="operator token">=</SPAN> dict<SPAN class="punctuation token">(</SPAN>source_info<SPAN class="punctuation token">)</SPAN>
        target_info<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'database'</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> db_target
        target_info<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'user'</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="string token">'gis'</SPAN>
        target_info<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'password'</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="string token">'gis'</SPAN>

        <SPAN class="comment token"># setup source and target connection_properties</SPAN>
        source_properties <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="string token">'connection_info'</SPAN><SPAN class="punctuation token">:</SPAN> source_info<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'dataset'</SPAN><SPAN class="punctuation token">:</SPAN> source_dataset<SPAN class="punctuation token">}</SPAN>
        target_properties <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="string token">'connection_info'</SPAN><SPAN class="punctuation token">:</SPAN> target_info<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'dataset'</SPAN><SPAN class="punctuation token">:</SPAN> target_dataset<SPAN class="punctuation token">}</SPAN>

        layer<SPAN class="punctuation token">.</SPAN>updateConnectionProperties<SPAN class="punctuation token">(</SPAN>source_properties<SPAN class="punctuation token">,</SPAN> target_properties<SPAN class="punctuation token">)</SPAN>

aprx<SPAN class="punctuation token">.</SPAN>save<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">del</SPAN> aprx‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.

Enlaces Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.