Migration and Compatibility
This section explains how migration from an earlier version to version 9.1.0 impacts various parts of the application.
Upgrade to 9.1.0 from 8.3.2, 9.0.0, and 9.0.1
You can upgrade TIBCO MDM to version 9.1.0 from versions 8.3.2, 9.0.0, and 9.0.1. Consider the following points when upgrading to version 9.1.0:
Upgrade to Microsoft SQL Server 2014 or 2016
Starting from version 9.1.0, the support for Microsoft SQL Server 2012 is removed. If you are using Microsoft SQL Server 2012, upgrade to Microsoft SQL Server 2014 or 2016, and then follow the database migration process. For more information, refer to the section "Upgrade to TIBCO MDM" in TIBCO MDM Installation and Configuration Guide.
Work Item Migration
If you choose to manually migrate each component, you must run the createAndMigrateWIAttributes.sql script to migrate the values of work item attributes. For more information about migrating individual components, refer to the section "Manually Migrating Individual Components" in the TIBCO MDM Installation and Configuration Guide.
Workflow Migration
Run the alterForProcessSelection.sql migration script located at $MQ_HOME/db/database_type/migration/Migrate901_91 to upgrade the default version of import workflow to wfin26catsourcev7.xml workflow file. A new activity AddressCleansing is added to the workflow file with other changes. For information on the AddressCleansing activity, refer to TIBCO MDM Workflow Reference.
ProductKey Table Migration
To improve performance and remove extra functional index, the ProductKey table now stores the NAME and EXTENSION columns in uppercase. The alterForProductkey.sql migration script is provided $MQ_HOME/db/database_type/migration/Migrate901_91. The functional index has been removed. Queries are simplified by removing the usage of UPPER function.