Migration procedure

DB2

  1. Create a backup of the database to be migrated so that it can be rolled back should there be a problem during or after the migration process.
  2. Start a command window that has DB2® administrative privileges.
  3. Navigate to the following directory: <instdir>/ftm/v300/admin/scripts/db2/migration/3.0.0.9_from_3.0.0.8
  4. The files in this directory contain all the database changes since FTM V3.0.0, Fix Pack 8.
  5. Run one of the following scripts:
    • Migrate-Win.cmd [Database Name] [Database Schema] [Database User] [Password] - 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 should there be a problem during or after the migration process.
  2. Start a command window that has Oracle administrative privileges.
  3. Navigate to the following directory: <instdir>/ftm/v300/admin/scripts/oracle/migration/3.0.0.9_from_3.0.0.8
  4. The files in this directory contain all the database changes since FTM V3.0.0, Fix Pack 8.
  5. Run one of the following scripts and follow the prompts. You need the FTM user name and password, and the Oracle database user and password:
    • Migrate-Win.cmd [db name] [db schema] - Main Windows operating system script to update the database.
    • Migrate-Unix.sh [db name] [db schema] - Main UNIX script to update the database.
Parent topic: From Version 3.0.0, Fix Pack 8 to Version 3.0.0, Fix Pack 9