I am attempting to import an XML Workspace document (database schema) from a file geodatabase into an SDE geodatabase sitting on top of Postgres. The steps I am taking are:
- In ArcCatalog - right-click on the file geodatabase --> Export --> XML Workspace document (schema only). Save the XML file.
- Inspect the XML file to make sure it makes sense. Below on the left the ZOrigin, ZScale, MOrigin, and MScale values all make sense (either 10000 or -100000).
- Right-click on my SDE geodatabase connection as the schema owner --> Import --> XML Workspace document.
- I then repeat step 1 on the SDE geodatabase (new geodatabase with no data or schema loaded) so that I can compare the XML schemas.
The XML snippet on the right shows my SDE schema. You will notice that the ZOrigin, ZScale, MOrigin, and MScale values are all now either 0 or 1. For some reason the import process is not preserving these values.
I have tried to simply copy and paste the schemas in ArcCatalog and ArcMap, an using the Distributed Geodatabase import tool, but with no success. When I copy or import the XML schema into a new file geodatabase it works just fine. I have also tried creating a new geodatabase user, but this doesn't produce any different results.
This should be a straight-forward export/import process. Am I missing a step or setting somewhere?