Migrating the database progressively

You can migrate part of your database to the current V8.8.0, 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"

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-migration-script ant task to select which projects from the old database to import.
  4. Archive the previous Decision Center database if you do not need history data to be preserved and want to configure the new installation by only deploying projects.
  5. Redeploy the provided archive files for the application server that you use for Decision Center.
  6. Handle the history of your previous repository.
    • If you want to preserve the history of your previous repository, run an Ant script to migrate the database to a new repository before you connect to it.
    • If you do not want to preserve the history, publish the migrated projects in Rule Designer and Event Designer to a new repository.