To migrate optimization rules to the new version of Optimize
Before you begin, confirm that the required migration scripts are installed in the /tools/migration/ddl directory in your Optimize installation.
*
The migration script works only on 7.2.1 versions of the Optimize system tables. You must upgrade to Affinium Campaign Optimize 7.2.1 before running the migration script.
1.
Locate the migration script files in the /tools/migration/ddl directory of your Optimize installation.
2.
According to the database you are using with Campaign, run the following script to delete all deprecated rules:
aco_migrate7.2.1-7.3.0.sql
This script deletes all deprecated rules.
If you are upgrading an installation with multiple partitions, repeat this step for each partition.
3.
According to the database you are using with Campaign, run the following script to upgrade the rules to the new version:
aco_migrate7.3-8.6_dbtype.sql
This script adds the tables required for new features. Use the unicode version of the scripts if your database is configured for unicode.
If you are upgrading an installation with multiple partitions, repeat this step for each partition.
Copyright IBM Corporation 2012. All Rights Reserved.