ArcGIS Desktop

  • ArcGIS Pro
  • ArcMap

  • My Profile
  • Help
  • Sign Out
ArcGIS Desktop

ArcGIS Online

The mapping platform for your organization

ArcGIS Desktop

A complete professional GIS

ArcGIS Enterprise

GIS in your enterprise

ArcGIS Developers

Tools to build location-aware apps

ArcGIS Solutions

Free template maps and apps for your industry

ArcGIS Marketplace

Get apps and data for your organization

  • Documentation
  • Support
Esri
  • Sign In
user
  • My Profile
  • Sign Out

ArcMap

  • Home
  • Get Started
  • Map
  • Analyze
  • Manage Data
  • Tools
  • Extensions

Methods to move a geodatabase in Db2

  • Move data to a new geodatabase on the same instance
  • Move a geodatabase to a new instance

If you want to move the contents of one geodatabase to another database on the same Db2 instance, you can create a second database, enable a geodatabase in it, and move your data. If you want to move the geodatabase to a new Db2 instance, you can make a backup of the database and move the database to the new instance.

Move data to a new geodatabase on the same instance

Database and geodatabase names must be unique on the same Db2 instance; therefore, if you want to move your data to a different geodatabase on the same instance, create a second database, enable a geodatabase in it, and move your existing data to the new geodatabase. Data can be moved in ArcGIS by copying and pasting, using the Export tool, using the Extract Data wizard, or using XML workspace documents.

Be aware that the user who logged in when loading the data to the new geodatabase will own the data. If you want the data to have the same owner in the new geodatabase, have each user move their own data.

Move a geodatabase to a new instance

If you want to move a geodatabase to a new Db2 instance, ensure you include all the necessary database objects, back up the database that you want to transfer, and restore it to your new instance. Doing this achieves the following:

  • Moves all objects in the database
  • Allows you to specify alternate paths for your table space containers
  • Allows you to use scripts if you need to move the database on a regular basis
Note:

You need to create your database on the destination machine with the correct code page before you perform the restore operation if the source and destination aren't using the default code page. If you do not do this and your target code page is different from that of the source, the restore utility assumes the default code page. This results in an SQL2548N error.

See the IBM Db2 Information Center documentation for instructions on creating backups of and restoring Db2 databases.

ArcGIS Desktop

  • Home
  • Documentation
  • Support

ArcGIS

  • ArcGIS Online
  • ArcGIS Desktop
  • ArcGIS Enterprise
  • ArcGIS
  • ArcGIS Developer
  • ArcGIS Solutions
  • ArcGIS Marketplace

About Esri

  • About Us
  • Careers
  • Esri Blog
  • User Conference
  • Developer Summit
Esri
Tell us what you think.
Copyright © 2021 Esri. | Privacy | Legal