Methods for moving a geodatabase in Informix

There are several options for moving a geodatabase: you can create a new geodatabase and move the data, or you can move the whole database.

Creating a new geodatabase then moving the data

You can create a new IBM Informix database, create a geodatabase in it, then move your existing data to the new geodatabase. This can be done using copy and paste, the export tool, the Extract Data wizard, or XML workspace documents in ArcGIS.

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.

Moving an Informix database

You can move the entire Informix database using either backup and restore or the Informix dbexport and dbimport utilities.

See the IBM Informix documentation for instructions on using backup and restore or the dbexport and dbimport utilities.

Restore a backup of the database

The easiest way to move a geodatabase stored in an Informix DBMS and ensure you get all the necessary database objects transferred is to make a full backup of the database you want to transfer and restore it to your destination server.

The dbexport and dbimport utilities

If you need to copy an entire database, Informix provides the dbexport and dbimport utilities. These unload an entire database, including its schema, and re-create the database.

These utilities move the entire database. If you want to move selected tables or selected columns of a table, you must use different utilities.