Migrating Data Using sybmigrate

sybmigrate is the migration tool used to migrate data from one server to another.

By default, sybmigrate migrates encrypted columns in ciphertext format. This avoids the overhead of decrypting data at the source and encrypting at the target. In some cases, sybmigrate chooses the reencrypt method of migration, decrypting data at the source and encrypting at the target.

Note: When migrating from one Adaptive Server to another more recent version of Adaptive Server, you must specify the size and location of a work database on the target server.

The sybmigrate utility:

Aids users in changing the page sizes of their database applications.
Provides a manageable and smooth migration process.
Allows customers to take advantage of the variable page size feature for existing databases with user data, thus realizing the full benefit of Adaptive Server versions 12.5 and later.

What sybmigrate Does
During the set-up portion of the migration process, sybmigrate migrates following server data to the target Adaptive Server:
What sybmigrate Does Not Do
The sybmigrate utility does not perform all tasks. Migrate these items manually.
Before You Begin
sybmigrate requires JRE 1.4, jConnect™ for JDBC™ 6.0, ddlgen components, and Component Integration Services in the source Adaptive Server.
Migration process
The goal of sybmigrate is to provide a means to migrate all objects and user data that exist on the source Adaptive Server. However, when migration takes place, there is some server-wide data that needs to be migrated before any user data or user objects can be migrated to individual databases.
Using sybmigrate with Encrypted Columns
For databases with encrypted columns, sybmigrate migrates the following.
Post-migration Activities
These are additional activities you perform after migration.
Migrate Databases in the Replication Server Domain
The Replication Server domain includes one or more of these types of databases.
Limitations
When migrating server data, sybmigrate requires that the target Adaptive Server catalog contain only default data. Default data on Windows machines is different from UNIX machines. This causes problems when migrating from UNIX to Windows machines.
Troubleshooting and Error Messages
This section discusses common errors and how to address them, as well as different error messages and their meaning.