Sequence Correction After Migration With SQL SERVER database
Article ID: KB0081028
Updated On:
| Products | Versions |
|---|---|
| TIBCO MDM | ALL |
Description
After migrating MDM from 8.3.2 to higher versions with SQL SERVER database of version 12 or higher you may get sequence discrepancy issues post migration.
Issue/Introduction
Correcting the sequence discrepancies in MDM for SQL SERVER database with SQL 12 or higher versions.
Environment
ALL
Resolution
To clear the discrepancies do not run the script sequence_tab_cleanup.sql present under db\sqlserver\utility directory.
It won't clear the sequence discrepancies.
That script has been provided for the DB migration from SQL SERVER 2008 to 2012,As in 2008 there was no sequences.
It won't clear the sequence discrepancies.
That script has been provided for the DB migration from SQL SERVER 2008 to 2012,As in 2008 there was no sequences.
Feedback
Yes
No
Powered by
