Migrating the Decision Center database

If you plan to migrate from version 8.5 or earlier, you must migrate the rule projects because the database schema changed between this version and the current version. For version 8.6 and later, you do not need to migrate the database schema, unless you want to have the latest features, such as user management.

Before you begin

Install Decision Center and follow the instructions in the configuration guide to create the new database schema. Then, run the migration Ant tasks.

By default, all versions use the same data source: jdbc/ilogDataSource.

Note: Starting with JRules 7.1, the migration is direct to the latest version.

For version 8.6 and later, the database schema is fully compatible with version 8.9.0 and does not need to be migrated. If you use a database created in versions 8.6.x, 8.7.x, or, 8.8.x, some of the new features that require a schema upgrade cannot be available without a migration, such as the user management feature (available from V8.8.0). If you want to use these features, you must use the Ant task to migrate from Operational Decision Manager V8.6 and equivalent schemas (V8.7.x) to the current version. For more information, see Ant tasks for database migration.

  • Databases that require specific privileges to access another schema
    Databases other than Derby must have specific privileges to access data in another schema. You must have these privileges for the migration because the process reads the data from the old schema to copy it to the current schema.
  • Ant tasks for database migration
    Your installation provides Ant tasks to copy the contents of an old database into the new schema, and to grant the required privileges to the database user referenced in the data source.
  • Migrating the database progressively
    You can migrate part of your database to the current V8.9.0, work on these migrated projects, and then run an Ant task when you are ready to migrate the rest.
  • Adding the Domain metric for simulations
    You run an SQL command to add a row to an existing database table.
  • Migrating from V7
    Changes from one release to the next can impact business rule application development in a number of ways. These guidelines contain information on how to migrate your applications developed in V7.
Parent topic: Migrating and updating your applications