WhereScape RED Migration Tooling 3.1 is deployed as an enablement pack and can be found under Enablement Packs -> Design & Utilities section on the customer portal and documentation space.
Go to https://www1.wherescape.com/support/software-downloads-documentation/enablement-packs/ to see available product versions.
Log into the WhereScape Support Portal to access downloads.
User Guide
Changes in MT 3.1
The following changes have been implemented since MT 3.0
Improvements
- Updated psql batch calls to fail if password is required but missing, to avoid hanging at the password prompt during job runs.
- Updated the default for extended property SERVERSIDE_COPY to FALSE so that 'psql copy' works for remote PostgreSQL instances.
- Changed scripts c1 and c4 to use psql in order to support remote PostgreSQL instances.
- Improved tooling upgrade process.
- Added object subtype mapping for legacy Retro Copy tables.
- Improved the storage mapping for SQL Blocks and Retro objects.
Changes in MT 3.0
The following changes have been implemented since MT 2.0
Improvements
- Refactored the installation and migration tooling approach such that the Migration Tooling repository is completely separate to both the source repository and destination repository.
- Transfers the metadata as-is retaining existing keys
- Retains all existing table processing scripts and procedures as-is reducing validation overheads and migration duration
Important Messages When Upgrading
Migration Tooling 3.0 cannot be upgraded from any earlier version of Migration Tooling as this release has completely refactored the approach.
Upgrading to 3.1
Migration Tooling 3.1 can be upgraded from 3.0 by following this process:
Before performing the Migration Tooling upgrade make sure to abort any failed jobs and ensure that no jobs are still running, otherwise the upgrade process will not be able to update those jobs. |
- Download and unzip the migration tooling to a new location.
- Update the RED parameter ‘MT_TOOL_DIR’ to point to the new build location.
- Deploy the Migration Tooling application in ‘<tooling_directory>\Deployment Applications’ using Application Deployment, this will update the migration tooling scripts. Select the below application after navigating to ‘<tooling_directory>\Deployment Applications’ and deploy with default settings:
- Run the Host Script ‘1_prepare_migration’, this will update all the load tables and jobs from the location specified in the RED parameter ‘MT_TOOL_DIR’ which you updated in step 2.
- If you are starting the migration again on an empty destination database, then also run Host Script ‘2_target_repo_creation’, otherwise start from your last failed step.