topic Re: Using replaceDataSource with an SDE Feature Dataset\FeatureClass in Python Questions

Using replaceDataSource with an SDE Feature Dataset\FeatureClass

JonBarlett — Sat, 11 Dec 2021 09:37:34 GMT

I am trying to change the data source from an FGDB to an SDE feature class. I can get this to work for an SDE feature class that is not within a feature dataset. For the life of me, I cannot get this to work for a feature class within a feature dataset. The script fails on line 15.

The error message:

ValueError: Layer: Unexpected error

I believe I am not correctly specifying the workspath_path or dataset_name correctly. The destination dataSource =

Database Connections\sdetest.sde\PIPELINE.BAKKEN\PIPELINE.Pipe

SDE Connection: Database Connections\sdetest.sde

Dataset: PIPELINE.BAKKEN

Feature Class: PIPELINE.Pipe

Any help would be appreciated!

import arcpy
import os
mxd = arcpy.mapping.MapDocument('CURRENT')
ListLayers = arcpy.mapping.ListLayers(mxd)
workspace_path = "Database Connections\sdetest.sde"
dataset_name = "PIPELINE.BAKKEN\PIPELINE.Pipe"
# dataset_name = "BAKKEN\PIPELINE.Pipe"
# dataset_name = "PIPELINE.BAKKEN.PIPELINE.Pipe"
# Source: Database Connections\sdetest.sde\PIPELINE.BAKKEN\PIPELINE.Pipe
for Layer in ListLayers:
    if Layer.supports("DATASOURCE"):
        desc = arcpy.Describe(Layer)

        if desc.catalogPath == "\\\\ftwnas01a\\ProjectsNew\\NatGasOps\\NGOData\\Assets\\Bakken.gdb\\Bakken\\Pipe":
           Layer.replaceDataSource(workspace_path, "SDE_WORKSPACE", dataset_name)

Re: Using replaceDataSource with an SDE Feature Dataset\FeatureClass

BlakeTerhune — Tue, 28 Apr 2015 22:44:20 GMT

Have you tried using the find and replace data Source feature in ArcCatalog?

ArcGIS Help 10.1 - Setting data sources

Re: Using replaceDataSource with an SDE Feature Dataset\FeatureClass

RebeccaStrauch__GISP — Sat, 11 Dec 2021 09:37:37 GMT

If in 10.3 Updating and fixing data sources—ArcPy | ArcGIS for Professionals

I'm working on updating data sources with arcpy myself right, not just FGDB/SDE, so I'm looking at all of it too. Looks like they recommend updating/replacing the database connection file. #4 on that help page

import arcpy
aprx = arcpy.mp.ArcGISProject(r'C:\Projects\YosemiteNP\Yosemite.aprx')
aprx.updateConnectionProperties(r'C:\Projects\YosemiteNP\Vector_Data\Yosemite.gdb',
                                r'C:\Projects\YosemiteNP\DBConnections\Server.sde')
aprx.save()
del aprx

I'm not sure if that will work for you or not, but might be worth checking.

Re: Using replaceDataSource with an SDE Feature Dataset\FeatureClass

JonBarlett — Wed, 29 Apr 2015 12:48:21 GMT

Thanks Blake. I am really trying to automate this through scripting. We are converting over 100 FGDB feature classes to SDE, which will affect well over 100 ArcMap projects. If I can't figure this out, then yes, that will probably be how we update our mxds.