Support for SQL Server Replication
The SQL Server database has a requirement to create a primary key on tables for replication. Some of the out-of-the-box tables that are provided with TIBCO MDM do not have a primary key. To support SQL Server replication,
CreateAdditionalPk.sql
script is provided in the
$MQ_HOME/db/sqlserver/utility folder. Run the
CreateAdditionalPk.sql
script to create a primary key on the out-of-the-box tables using existing columns.
Limitations
- The script does not handle dynamically created tables.
- The script does not handle tables, which do not have sufficient columns to create a primary key. For such tables, add an identity column, and use that column as primary key.