Preserving GlobalID from enterprise database to fileGDB

Question

We are trying to export data from Microsoft SQL SEREVER 2019 to FileGDB. we implement this by utilizing a python script to put the data into a FileGDB template. The issue we encountering is that the GlobalID from the SQL database is not preserved in the fileGDB. Any ideas for solving this problem?

mody_buchbinder · Answer

Hi All

The Append command respect this env but the doc's say it will work only for Enterprise geodatabase (why?)

I checked and the Copy Features also respect this env and it let you copy the layer from Enterprise to FGDB and keep the global ids

DavidSolari · Answer

If Preserve Global ID won't fit your workflow: create the destination feature class with the "Guid" field type for every Global ID field. When you append the Global ID will be stored as-is in that Guid field. This also works with Object ID fields, just use "Long" (or the new 64-bit field type if needed) instead of "Guid".

ryanuthoff · Answer

What do you mean by you want to run the python externally? Does that mean you do not want to use ArcPy since that requires ArcGIS Pro (even if you run it completely outside of ArcGIS Pro)?

If you're fine using ArcPy, @DanPatterson's solution should work since you can set that parameter in the Python script.