import arcpy arcpy.env.workspace = "Database Connections/COL_LCT_Base.sde" fc = "ownedByMe.MyFeatureClass" if arcpy.Exists(fc): print "Check succeeded - all guests are here, so proceed with the party!"
import arcpy import os arcpy.env.overwriteOutput = True outFGDB = r"YOUR_FGDB.gdb" sdeWorks = r"Database Connections\YOUR_DB_CONNECTION.sde" arcpy.env.workspace = sdeWorks try: for fd in arcpy.ListDatasets("*"): print "Processing", fd, "..." arcpy.env.workspace = sdeWorks + os.sep + fd outData = outFGDB + os.sep + fd.split('.')[1] arcpy.Copy_management(arcpy.env.workspace, outData, "FeatureDataset") except: arcpy.GetMessages()
import arcpy from arcpy import env env.workspace = r"F:Replicated Data\Auto_Extract_Connection.sde" datasetList = arcpy.ListDatasets() print datasetList env.workspace = r"F:\Replicated Data\Gatekeeper_Extract.gdb" datasetList = arcpy.ListDatasets() print datasetList
I'm having a similar problem, but I cannot see what I am doing wrong.import arcpy from arcpy import env env.workspace = r"F:Replicated Data\Auto_Extract_Connection.sde" datasetList = arcpy.ListDatasets() print datasetList env.workspace = r"F:\Replicated Data\Gatekeeper_Extract.gdb" datasetList = arcpy.ListDatasets() print datasetList
This returns
[]
[u'ElectricDataset', u'CPUDataset', u'TransmissionDataset']
It's clearly connecting to the file GDB but won't connect to the SDE one. I know the connection file is working, I can connect with it through Catalog.
import arcpy, os from arcpy import env root = r"F:\Replicated Data" for workspace in ["Auto_Extract_Connection.sde", "Gatekeeper_Extract.gdb"]: env.workspace = os.path.join(root, workspace) datasetList = arcpy.ListDatasets() print workspace, datasetList
import arcpy, os from arcpy import env root = env.workspace = r"F:\Replicated Data" workspaces = arcpy.ListWorkspaces() for workspace in workspaces: env.workspace = workspace datasetList = arcpy.ListDatasets() print workspace, datasetList