Migration procedure

Note: The scripts to migrate from version 3.0.0 to version 3.0.0, Fix Pack 1 are slightly different than the migration scripts for FTM 3.0.0, Fix Pack 5 and later.

Db2

  1. Create a backup of the database to be migrated so that it can be rolled back if a problem occurs during or after the migration process.
  2. Start a command window that has Db2® administrative privileges.
  3. Go to the instdir/ftm/v300/admin/scripts/db2/migration/3.0.0.1_from_3.0.0.0 directory.
  4. Run one of the following scripts:
    • Migrate-Win.cmd [Database Name] [Database Schema] - Main Windows operating system script to update the database.
    • Migrate-Unix.sh [Database Name] [Database Schema] [Database User] [Password] - Main UNIX script to update the database.

Oracle

  1. Create a backup of the database to be migrated so that it can be rolled back if a problem occurs during or after the migration process.
  2. Start a command window that has Oracle administrative privileges.
  3. Go to the instdir/ftm/v300/admin/scripts/oracle/migration/3.0.0.1_from_3.0.0.0 directory.
  4. Run one of the following scripts and follow the prompts. You need the FTM username and password, and the Oracle database user and password:
    • Migrate-Win.cmd [Database Name] [Database Schema] - Main Windows operating system script to update the database.
    • Migrate-Unix.sh [Database Name] [Database Schema] - Main UNIX script to update the database.