Migrating the database progressively

If you have a 7.0, 7.5, or 8.0 Decision Center database, you can migrate part of your database to the current V8.5.1, work on these migrated projects, and then run an ant task when you are ready to migrate the rest.

About this task

The progressive migration Ant task is defined in <InstallDir>/teamserver/bin/build.xml and is of the form:

ant gen-prog-migrationXX-script -DoldDatabaseSchemaName -Dprojects

Where XX is the version of the original database and the Ant task takes the following parameters:

-DoldDatabaseSchemaName=<database schema name used in previous data source>

-Dprojects="project1 project2 project3 ..."

More information on the parameters used in the Ant task is available in Setting up the Ant tasks environment.

The progressive migration tool does not handle elements that are not project-specific, such as RuleApps, server definitions, and user permissions and settings.

The progressive migration tool automatically handles dependent projects. You need to specify only the main project when running the tool. If one of the dependent projects is already available in the new database, the migration tool simply ignores this project.

Note: Derby and Sybase do not support automatic inclusion of dependent projects. For these databases, add all the dependent projects in the -Dprojects parameter.

Procedure

  1. Migrate the entire database.
  2. In the migrated database, manually delete the projects that you want to keep working on in the old database.
  3. When you are ready to migrate the remainder of the old projects, use the gen-prog-migration75-script ant task to select which projects from the old database to import.