unable to connect to local or remote database using arcpy tools ( ImportXMLWorkspaceDocument, EnableAttachments_management, Append_management)

Question

I am trying to automate the migration of data using geoprocessing tools.  So I am starting with an XML Workspace Document that I exported using ArcCatalog.  When I try to import this into a new geodatabase, I tried dragging the db connection in ArcCatalog into the geoprocessing tool (ImportXMLWorkspaceDocument) and it fails saying 'Cannot access local or remote database'.

This happens with multple tools, i.e., EnableAttachments_management, Append_management and ImportXMLWorkspaceDocument)

Any help would be appreciated!

RhondaGregory · Answer

So the bottom line, the export XML workspace document had reference to the old schema and would not work.  I replaced the reference to the schema with a token and my python scripts now replace that token with the correct target schema