how to copy sde database and schema to File GDB. I did export the sde ..but when i view my attribute table, the details are missing
Solved! Go to Solution.
Hi YeshiWangchuk,
To copy sde database and schema to file gdb, you can base on this doc
There are a number of reasons and multiple workflows available for making copies of a geodatabase. Here are a few common cases.
Hope this help you,
Best regards,
Fred
Hello YeshiWangchuk,
I would like to kindly offer my workflow for this as we use it to decommission our SDE's, but keep backups in file .GDB's.
Export XML Workspace Document—Help | ArcGIS for Desktop
You export it as an XML Workspace document. This workflow will maintain the schema of the SDE, and can be imported into a file .GDB.
Please have a lovely day, and I hope this helps!
Sincerely,
DS_GIS
Hi YeshiWangChuk,
what you are seeing is a field that has an associated Domain, but some of the actual data values in your table are not valid codes for the Domain. ArcGIS cannot find a Description, so just shows the code value.
It is a bit odd, if you have used any of the techniques described above to copy data from Enterprise Geodatabase to File Geodatabase, the associated domains would have come with it.
Is it possible some other edits have happened after transfer? - or do you see the same behaviour when you look at the class still in the Enterprise Geodatabase (using ArcGIS tools)?
Hi YeshiWangchuk,
To copy sde database and schema to file gdb, you can base on this doc
There are a number of reasons and multiple workflows available for making copies of a geodatabase. Here are a few common cases.
Hope this help you,
Best regards,
Fred
Hello YeshiWangchuk,
I would like to kindly offer my workflow for this as we use it to decommission our SDE's, but keep backups in file .GDB's.
Export XML Workspace Document—Help | ArcGIS for Desktop
You export it as an XML Workspace document. This workflow will maintain the schema of the SDE, and can be imported into a file .GDB.
Please have a lovely day, and I hope this helps!
Sincerely,
DS_GIS
Hi YeshiWangChuk,
what you are seeing is a field that has an associated Domain, but some of the actual data values in your table are not valid codes for the Domain. ArcGIS cannot find a Description, so just shows the code value.
It is a bit odd, if you have used any of the techniques described above to copy data from Enterprise Geodatabase to File Geodatabase, the associated domains would have come with it.
Is it possible some other edits have happened after transfer? - or do you see the same behaviour when you look at the class still in the Enterprise Geodatabase (using ArcGIS tools)?