Migrating from an enterprise geodata base to other

168
2
Jump to solution
12-21-2021 01:52 PM
RandallClark_CSUF
New Contributor II

We are in the process of taking down and sde enterprise geodatabase (the gis program is being scrapped). is there any way to move the data from our enterprise database to something else, ie a file geodatabase so that If they decide to bring back the program, the data is not all lost?

Thanks

0 Kudos
1 Solution

Accepted Solutions
LadyMahecha
New Contributor

Hi,

To copy an entire geodatabase, use the Export > XML Workspace Document command to export the entire database to an XML file. You can then create a new, empty file geodatabase and use Import > XML Workspace Document to import the data from the XML file into the file geodatabase.

View solution in original post

2 Replies
LadyMahecha
New Contributor

Hi,

To copy an entire geodatabase, use the Export > XML Workspace Document command to export the entire database to an XML file. You can then create a new, empty file geodatabase and use Import > XML Workspace Document to import the data from the XML file into the file geodatabase.

George_Thompson
Esri Frequent Contributor

You may also want to make sure that you have reconcile / posted / compressed the Enterprise Geodatabase, if you had versioning implemented before the copy / paste. This would prevent any data that was not in the version that you are connecting as (typically DEFAULT).

Also depending on the RDBMS being used, you could take a full, verified backup of the DB (as a whole) and archive that.

--- George T.