Skip To Content

Migrate to ArcGIS Data Store relational data store

Beginning with ArcGIS Enterprise 10.6, your portal's hosting server should use the relational data store provided through ArcGIS Data Store. If you want to upgrade your ArcGIS Enterprise deployment to 10.6 from a 10.5.1 or earlier release, and the hosting server currently uses an enterprise geodatabase registered as the managed database, switch to using the relational data store before you upgrade.

To migrate existing hosted feature layer data, follow these steps:

  1. Export the data from existing hosted feature layers.
  2. Delete existing feature layers.
  3. Replace the managed database with a relational data store.
  4. Republish hosted feature layers.
  5. Reset sharing and other properties on the new hosted feature layers, resymbolize layers in maps, re-create presentations, and republish apps.

Each step is described in more detail in the following sections.

Be aware that this workflow copies the data and creates new services and layers, which requires you to reset sharing and other properties on the new hosted feature layers, reapply styles to layers in maps, re-create presentations, and republish apps.

Note:

Hosted feature layers published from ArcMap or an ArcGIS Pro map to your portal can be republished from ArcMap or ArcGIS Pro, but only if the hosted feature layer was never used for editing. If any edits were made through the hosted feature layers, those edits are lost when you republish.

If you are positive no edits were made through the hosted feature layers published from ArcMap or ArcGIS Pro, you can republish from the maps in these clients to preserve layer symbology and sharing properties.

Export data

Export the data from existing hosted feature layers before you remove the managed database from the GIS Server site you have registered as your portal's hosting server. This ensures you have the most current version of the data.

The portal administrator can perform these steps to export all hosted feature layer data before you configure ArcGIS Data Store. Alternatively, each portal member who owns hosted feature layers can export the data for each of their hosted feature layers.

You must export the data from the hosted feature layers, because if any edits were made to the hosted feature layers, those edits would be lost if you republished from the original data source, such as a shapefile, CSV file, or file geodatabase.

  1. Sign in to your portal.
    • If you sign in as the portal administrator, click Actions Actions next to the first portal member's name and click Manage Items. This opens a list of all content owned by this member.
    • If you sign in as the hosted feature layer owner, open My Content.
  2. Open the item details for the first hosted feature layer you want to migrate.
  3. Click Export > Export to FGDB to export to a file geodatabase.

    This creates a file geodatabase containing a feature class for each layer in the hosted feature layer. The item details for the new file geodatabase open.

  4. Repeat these steps for every hosted feature layer you want to preserve and move to an ArcGIS Data Store relational data store.

Next, delete the existing hosted feature layers, remove the managed database, configure ArcGIS Data Store, and republish from the exported files.

Delete existing layers

Hosted feature layer names must be unique, so owners must delete the existing hosted feature layers before republishing.

Caution:

When you delete hosted feature layers, the data is also deleted from the managed database. Before you have the owners delete their hosted feature layers, create a backup of the managed database. This provides you with another copy of the data in case you find there are any problems with the data exported in the previous section.

Once the existing hosted feature layers are deleted, maps and apps that used these layers will no longer function. You must re-create them after configuring ArcGIS Data Store and republishing.

The portal administrator or hosted feature layer owners must delete the same hosted feature layers they exported in the previous section.

  1. Sign in to your portal.
    • If you sign in as the portal administrator, click Actions next to the first portal member's name and click Manage Items. This opens a list of all content owned by this member.
    • If you sign in as the hosted feature layer owner, open My Content.
  2. Check the check box next to every hosted feature layer you are migrating and click Delete.

Next, remove the existing managed database and configure ArcGIS Data Store.

Replace the managed database

Remove and replace the existing managed database with ArcGIS Data Store.

First, remove the existing managed database.

  1. Sign in to ArcGIS Server Manager as an administrator.
  2. Click Site at the top of ArcGIS Server Manager.
  3. Click Data Store.
  4. Click the Unregister button (x) next to the existing managed database to remove it from the GIS Server site.
  5. Click Yes to confirm that you want to unregister this database.

Next, install ArcGIS Data Store and configure a relational data store with the GIS Server site.

Once you have configured ArcGIS Data Store, all newly published hosted feature layer data is stored in the relational data store.

Republish hosted feature layers

Publishers need to republish hosted feature layers from the file geodatabases they exported earlier. Be sure the new hosted feature layers have the same names as the old hosted feature layers.

Note:

Whoever publishes the data owns the hosted feature layer item in the portal. If you exported the data as the portal administrator but you want individual portal members (publishers) to continue to own the hosted feature layer, share the file geodatabases to a group to which publishers belong.

  1. Open the item details for an exported file geodatabase.
  2. Click Publish.
  3. Reset properties, such as sharing, editing, and delete protection, on the new hosted feature layer. See Manage hosted feature layers in the Portal for ArcGIS help for instructions.
  4. Repeat these steps for every exported file geodatabase.

Update maps and republish apps

The new hosted feature layers have different IDs than the ones they replaced. You need to replace the hosted feature layers in existing maps, reset styling in the map, re-create presentations in the maps, and republish apps that used these maps.