Moving a geodatabase using ArcSDE export files

License:

Applies to geodatabases created with an ArcGIS Server Enterprise license only

You can use the administration command sdeexport to create an ArcSDE export file of an ArcSDE geodatabase licensed through ArcGIS Server Enterprise and the sdeimport command to move the ArcSDE export file to another server.

Tip:

For details on the use of sdeimport and sdeexport commands, see the Administration Command Reference that is provided with the ArcSDE component of ArcGIS Server Enterprise.

ArcSDE export files transfer data in compressed format, thus saving space on the transfer media, but they are not geodatabase aware. Therefore, extra work is required to make them usable from ArcGIS Desktop.

Steps:

1. At the command prompt, export the datasets to transfer media using the sdeexport command.
2. To import, copy the export files from the transfer media to a local disk drive on the target server.
3. Import the files from the local disk drive to the target geodatabase using the sdeimport command.
   Note:

   The sdeimport command is not geodatabase aware and therefore is not capable of updating the geodatabase metadata to indicate that the spatial column is part of the dataset.

4. When importing a raster dataset, drop the footprint spatial column from the raster dataset's business table.
5. If a raster catalog is imported, the spatial column is retained. Following the import, the raster catalog must be registered with the geodatabase within ArcGIS Desktop. To do so, right-click the raster catalog in the Catalog tree and click Register with the geodatabase.
6. After data is imported to the database, update your database statistics. See Updating statistics on a geodatabase using Analyze for instructions on how to do this.