I have a set of file geodatabases with the same schema as my SQL Server Express geodatabase. Using this script, I am trying to append the feature classes of each FGDB into the corresponding feature class in the SQL Server Express GDB.
import arcpy, os
inputGDB = arcpy.GetParameterAsText(0)
sqlDB = arcpy.GetParameterAsText(1)
arcpy.env.workspace = sqlDB
sqlFCs = arcpy.ListFeatureClasses()
for fc in sqlFCs:
sourceFC = str(fc)[14:]
if arcpy.Exists(os.path.join(inputGDB, sourceFC)):
arcpy.AddMessage("Appending " + sourceFC + " to " + fc)
fcPath = sqlDB + "\\" + fc
arcpy.Append_management(os.path.join(inputGDB,sourceFC), fcPath)
When I attempt this with my python script, I get the following error:
ERROR 000732
Target Dataset: Dataset Database Servers\WOS2UA52417ZT_SQLEXPRESS.gds\SCAT_Data (VERSION:dbo.DEFAULT)\SCAT_Data.DBO.trackjsonpnts does not exist or is not supported
It is the same if I try to simply use the Append tool from ArcToolbox. Is there a way to append feature classes in an SQL database?