Before You Begin

sybmigrate requires JRE 1.4, jConnect™ for JDBC™ 6.0, ddlgen components, and Component Integration Services in the source Adaptive Server.

sybmigrate is installed as part of the Adaptive Server software. For information about how to install Adaptive Server, see the installation guide for your platform.

Because sybmigrate requires a server-to-server connection, two Adaptive Servers must be running. Make sure that you have the appropriate licenses.

Before you begin the migration process, create databases, devices, and segments on the target Adaptive Server. Server and cache configurations must also be already installed on the target Adaptive Server.

Use ddlgen to extract the corresponding scripts from the source Adaptive Server, and modify them as needed before applying them to the target Adaptive Server.

• Permissions
  The System Administrator login is needed for the setup portion of the migration process. For the remainder of the process, the login must have “sa_role” and “sso_role” privileges to run sybmigrate.
• Platforms
  sybmigrate works on both UNIX and Windows platforms.
• Environment Settings
  These environment variables must be set correctly. With the exception of SYBMIGRATE_MEMORY, these environment variables are defined in the SYBASE.csh or SYBASE.sh files that are created during the installation process.
• Migrating Proxy Tables
  sybmigrate supports the migration of proxy tables. If you are planning to migrate proxy tables, you should do the following before you begin migration.