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 has changed. For 8.6 and later, you can retain your current database schema, but you must update it to use the latest features.

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. You must have the roles rtsAdministrator and rtsInstaller to run Ant tasks or REST API to migrate a database. By default, all versions use the same data source: jdbc/ilogDataSource. The migration goes directly to the latest version.

For versions 8.6 and later, the database schema is compatible with version 9.6.0. However, if you use a database created in a previous version, some new features might require you to upgrade the schema as part of the migration. Use ODM Transformation Advisor External link opens a new window or tab to determine whether you must upgrade your schema.

Some performance improvements require database schema updates. As a quick step to benefit from these improvements before going through the migration process, you can check the diagnostic in Data source/Database schema additions. Then, you get access to an SQL script that can be used to enable the performance improvements.

Note: Even if the schema additions are applied, the data source diagnostic remains red until the database is fully migrated.

To check the schema of your database in the Decision Center Business console:

  • Open Administration > Diagnostics > Data source.

To use the new features, you must use the Ant task to migrate to the current version. For more information, see Ant tasks for database migration.