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.

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.