ArcGIS Server Banner

Methods for copying geodatabases

Methods for copying geodatabases

Release 9.3 E-mail This TopicPrintable VersionGive Us feedback

Overview of copying geodatabases

There are a number of reasons and multiple workflows available for making copies of a geodatabase. Here are a few common cases:

The following tasks describe the process for making copies of geodatabases.

How to copy a geodatabase

Copying a geodatabase using the Copy tool

The primary mechanism used to copy a geodatabase using geoprocessing is by using the Copy tool in geoprocessing. This tool is found in the Data Management Tools toolbox in the General toolset.

Where to find the COPY tool in the ArcToolbox

The Copy tool can be used to make a copy of an existing geodatabase of the same type (for example, to make a copy of a file geodatabase). Both the schema and all the contents of the geodatabase will be copied.

You can also use Copy to copy an individual dataset between two geodatabases of any type. For example, you can copy a feature class from an ArcSDE geodatabase to a personal geodatabase.

Copying a geodatabase using geodatabase XML workspaces

You can use geodatabase XML workspace documents to copy a geodatabase. This option creates a readable XML document of the geodatabase contents.

NOTE: The resulting geodatabase XML document can be overwhelmingly large when you copy the data as well as the schema. Generally, this alternative is not recommended for copying geodatabase data. Alternatives for making a geodatabase copy include the use of the Copy tool and the Extract Data Wizard in ArcMap to copy subsets of the information.

XML workspace documents are very useful for copying geodatabase schemas (empty geodatabases) from one type to another. Learn more about copying a schema using XML workspaces.

For information on geodatabase XML, refer to this link for a white paper on Geodatabase XML.

Steps

    To copy a geodatabase schema using an XML workspace document

  1. In the Catalog tree, right-click the geodatabase that you want to copy and point to Export. Click XML Workspace Document.
  2. Using Export to create an XML copy of your geodatabase schema

  3. On the first panel of the wizard, click Data since you want to copy all the geodatabase contents.
  4. Click on data to copy all the contents of a geodatabase.

  5. Specify the path and name of the new export file you will create.
  6. If the data you're exporting has metadata and you want to export it, check the Export Metadata check box.

  7. Click Next to preview the geodatabase contents to be copied.
  8. This panel lists all the datasets to be copied.

    Uncheck the Include check boxes for the feature classes, tables, or relationship classes that you don't want to export.

    If you leave a box checked for a feature class in a network, topology, or terrain, all the feature classes participating in the network, topology, or terrain will be copied.

  9. By clicking Summary, you can review a summary of the extraction contents and other optional settings. When you are ready, click Finish to export the geodatabase.

Copying a geodatabase using the Extract Data Wizard in ArcMap

This ArcMap wizard enables you to extract the contents of one geodatabase and copy it into another geodatabase. This wizard also allows you to copy selected features and records from a subset of the datasets. You can create a new file or personal geodatabase to hold the information copied with this tool.

Do not select any features if you want to copy all the contents in the geodatabase. However, if you want to copy a subset of the data, you can use any ArcMap selection method to select features or records. For example, you can select features by dragging a box around them or specifying an attribute query.

Steps

Here are the steps to copy the contents of a geodatabase using the Extract Data wizard:

  1. Start ArcMap.
  2. Use the Add Data button to add a map layer using a dataset from the geodatabase whose schema you want to export.
  3. Open the Distributed Geodatabase toolbar as follows: Click View, click Toolbars, then click Distributed Geodatabase to display the toolbar.
  4. The Distributed Geodatabase Toolbar in ArcMap

  5. Click the Extract Data button on the Distributed Geodatabase toolbar to start the Extract Data wizard.
  6. The Extract Data Wizard in ArcMap

  7. Since you want to copy all the contents, click Data in response to What do you want to extract?
  8. Navigate to the new geodatabase into which you want to copy the data, or type its path.
  9. Check the Show advanced options for overriding data extraction defaults when I click Next option at the bottom of the page.
  10. Click Next to Specify the contents to be copied. On this panel, you can set the extent of the features to be copied and make a list of the data items whose information will be copied.
  11. The Advanced Extract Data Panel

  12. If you want to copy all the contents, check The full extent of the data. Note that you must not have any feature or table selections to copy all the data contents within the extent.
  13. Uncheck the Include check boxes for the feature classes, tables, or relationship classes whose contents you don't want to export.
  14. If you leave a box checked for a feature class in a network, topology, or terrain, the contents for all the feature classes participating in the network, topology, or terrain will be copied. Click Next.

  15. On this final panel, you can review a summary of the extraction contents and other optional settings. When you are ready, click Finish to copy the geodatabase contents.

Copying feature classes using Export

You can copy a series of geodatabase feature classes from one geodatabase to another using the Export tool. Right-click on the name of the geodatabase that contains the feature classes you want to copy, point to Export, and click To Geodatabase (Multiple).

Using geodatabase EXPORT to copy feature classes

This will invoke the geoprocessing tool Feature Class to Geodatabase (multiple).

This tool will create a list of all feature classes, and you can add or remove some of the feature classes. By default, all the feature classes in the existing geodatabase will be automatically copied unless you modify the list of feature classes.

The feature class to geodatabase export tool

You'll need to type the name of an existing geodatabase into which the feature classes will be copied.

NOTE: Be aware that only simple feature classes will be copied. For example, if you have feature classes contained within feature datasets to be exported, only the feature classes will be copied. The feature dataset, plus any of its advanced elements such as topologies, geometric networks, terrains, and so on, will not be copied to the output geodatabase.