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)
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
