ArcGIS Server Banner

Migrating to an ArcSDE geodatabase licensed through ArcGIS Server Workgroup

Migrating to an ArcSDE geodatabase licensed through ArcGIS Server Workgroup

Release 9.3 E-mail This TopicPrintable VersionGive Us feedback

About migrating to an ArcSDE geodatabase for SQL Server Express

If you need to have more people concurrently connected to an ArcSDE geodatabase for SQL Server Express or more than one person editing at a time, you could move to geodatabases licensed through ArcGIS Server Workgroup.

ArcSDE geodatabases licensed through ArcGIS Server Workgroup are not limited on the number of Web service connections to the database server.

The simplest method for migrating from a file or personal geodatabase to an ArcSDE geodatabase licensed through ArcGIS Server Workgroup is to copy and paste the data. To move from an ArcSDE geodatabase licensed through ArcGIS Desktop or ArcGIS Engine to an ArcSDE geodatabase licensed through ArcGIS Server Workgroup, you can detach a geodatabase from the ArcGIS Desktop licensed database server, move the database file to the machine with the database server licensed through ArcGIS Server Workgroup, and attach the geodatabase.

See Detaching and attaching a geodatabase on a database server for instructions on moving databases between ArcSDE database servers.

How to

Migrate from a personal or file geodatabase

  1. In the Catalog tree, click the personal or file geodatabase from which you want to move your data.
  2. On the Contents tab, click the first data item in the list. Holding down the Shift key, click the last item in the list. This will select all the contents of the personal or file geodatabase.
  3. Right-click one of the selected items and click Copy.
  4. To confirm that you are connected to the database server, double-click it. When you are connected, the icon will no longer have a red X on it.
  5. Open the Database Servers folder.
  6. Right-click the geodatabase to which you want to migrate and choose Paste from the context menu. If the geodatabase to which you want to migrate does not yet exist on the desired ArcSDE database server, you must create one.
  7. For instructions on how to do this, see Creating a new geodatabase in the "Creating a geodatabase" section of the help.

  8. On the Data Transfer dialog box, confirm that all the data items you want to migrate are listed.
  9. Click OK.

Moving from ArcSDE geodatabases licensed through ArcGIS Desktop to one licensed through ArcGIS Workgroup

NOTE: You must be a database server administrator and an administrator on the PC on which the the instance of SQL Server Express is installed to update the license key.

  1. Obtain an ArcGIS Server Workgroup authorization keycode from ESRI.
  2. Run the installation to set up an installation of SQL Server Express and enable it to store ArcSDE geodatabases.
  3. Detach the geodatabases from the database server licensed through ArcGIS Desktop, then attach them to the ArcSDE database server licensed through ArcGIS Server Workgroup. This is done in ArcCatalog. See Detaching and attaching a geodatabase on a database server for details on how to do this. Attaching the geodatabase to the database server licensed through ArcGIS Server Workgroup automatically updates the license file in the geodatabase.

If you want to change an existing instance licensed through ArcGIS Desktop or ArcGIS Engine to one licensed through ArcGIS Server Workgroup, you can do the following:

  1. Create backup files of all your existing geodatabases. See Back up and restore geodatabases on an ArcSDE database server for instructions.
  2. Run just the postinstallation portion of the ArcGIS Server Workgroup installation wizard.
  3. Choose your existing SQL Server Express instance.
  4. Complete the authorization for ArcGIS Server Workgroup.
  5. As a database server administrator, open ArcCatalog and connect to the existing database server.
  6. Detach then attach each of the geodatabases on the database server to update the license keys in the individual geodatabases. See Detaching and attaching a geodatabase on a database server for instructions.

See Also

  • An overview of scaling and moving a geodatabase