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 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.
Copyright © Cloud Software Group, Inc. All rights reserved.