Migrating to a New Server
Go Up to Migrating Servers and Databases
This section describes the recommended steps for installing InterBase 6 or newer as a new server and then migrating databases from a previous InterBase 5 or older installation. The process differs only slightly from an in-line install.
In the following steps, older refers to databases that are on a version 5 or older InterBase server. Newer and new refer to an InterBase version 6 or newer server.
- Shut down the older databases before backup to ensure that no transactions are in progress.
- Back up all databases that are on the older server. Include
isc4.ib
if you want to preserve your configured user IDs. - Install the new server.
- Start the new server.
- On UNIX/Linux platforms, issue the following command to start the InterBase Superserver as user “InterBase”:
# echo "/usr/{{Product}}/bin/ibmgr -start -forever" | su {{Product}}
Note that InterBase can run only as user “root” or user “InterBase” on UNIX.
- On UNIX/Linux platforms, issue the following command to start the InterBase Superserver as user “InterBase”:
- Copy the database backup files to the new server and restore each database from its backup file. This process creates databases that have the current version, ODS, and dialect. (Note: In later versions of InterBase, it creates the appropriate current ODS, but always dialect 1.)
Save your backup files until your migration to dialect 3 is complete. - To restore the list of valid users, follow these steps:
- Restore
isc4.gbk
toisc4_old.ib
- Shut down the server.
- Copy
isc4_old.ib
overisc4.gdb
. - Copy
isc4_old.gbk
overisc4.gbk
. - Restart the server.
- Restore
- Perform a full validation of each database on the new server.
After performing these steps, you have an InterBase 6 and later server and InterBase 6 and later, dialect 1 databases. See About InterBase 6 and Later, Dialect 1 Databases to understand more about these databases. See Migrating Databases to Dialect 3 for a description of how to migrate databases to dialect 3. See Migrating Clients for an introduction to client migration.