Migrating from an enterprise geodata base to other

[RandallClark_CSUF]

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

[LadyMahecha · Accepted solution]

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]

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.