Skip to main content

Move datasets between database schema

Administrators can move feature classes, feature datasets, or tables (collectively referred to as datasets) from one database schema to another. Reasons for doing this include the following:

  • The schema owner has left the organization or division and will be removed from the geodatabase.

  • Data creation duties have shifted to a different user, and you want to have all datasets for a specific project or division in the same user's schema.

  • The datasets were created in the geodatabase administrator's schema, but you need to keep these user-defined datasets separate from the geodatabase system tables.

When you move a geodatabase dataset to a new schema, geodatabase system tables are updated to account for the new location.

Note:

Moving a dataset to a new schema can be a disruptive action; any apps that access the dataset will be unable to do so the next time they attempt to connect. For example, if a user added the dataset to an ArcGIS Pro map that is not currently open and, therefore, is not holding a lock on the dataset, the next time the map is opened, the map layer's data source will be broken and must be repaired to access the new location of the dataset.

Requirements

Keep the following in mind when moving a dataset to a new database schema:

  • The dataset to be moved must be registered with the geodatabase.

  • The destination schema must be owned by a user with the same name as the destination schema.

  • The source and destination schemas must be in the same database.

  • No locks can be held on the dataset.

  • To move a feature dataset, it cannot contain a parcel fabric, trace network, or utility network.

  • To move a relationship class, the relationship class object and the tables or feature classes participating in the relationship class must be in the same feature dataset.

  • Only the geodatabase administrator or database administrator can move a dataset to a different schema. In an sde-schema geodatabase, the sde user may require additional privileges.

  • After the dataset is moved to the destination schema, the new dataset owner must grant privileges to it. Privileges granted by the previous owner no longer apply.

Run the Change Dataset Schema geoprocessing tool

To move a dataset from one database schema to another, run the Change Dataset Schema geoprocessing tool as described below:

  1. Start ArcGIS Pro.

  2. Connect to the geodatabase as the geodatabase administrator or database administrator.

  3. Open the Change Dataset Schema geoprocessing tool.

    You can type the tool name in the Search field of the Geoprocessing tab to find the tool and open it, or browse to the tool in the Geodatabase Administration toolset of the Data Management toolbox.

  4. For the Input Dataset, browse to the dataset in the database connection you created in step 2.

    You can move only one dataset at a time.

  5. Choose the destination schema from the New Schema drop-down menu.

  6. Click Run.