search cancel

Does Identity Manager Support Transactional Replication?

book

Article ID: 215299

calendar_today

Updated On:

Products

CA Identity Manager

Issue/Introduction

Transactional replication requires a Primary key, there are a few tables within Identity Manager that do not have a Primary key. What does Broadcom recommend for database replication?

Environment

Release : 14.X

Component : IdentityMinder(Identity Manager)

Resolution

Identity Manager is not able to support transactional replication due to the requirement for a primary key constraint on each published table. 

Both Merge and Snapshot replication do not require a primary key, but if one is present, it must be replicated. It is recommended to confirm Merge or Snapshot replication based on your business use case.

https://docs.microsoft.com/en-us/sql/relational-databases/replication/administration/frequently-asked-questions-for-replication-administrators?view=sql-server-ver15#how-do-i-manage-constraints-on-published-tables

Information on Merge Replication:

https://docs.microsoft.com/en-us/sql/relational-databases/replication/merge/merge-replication?view=sql-server-ver15

Information on Snapshot Replication:

https://docs.microsoft.com/en-us/sql/relational-databases/replication/snapshot-replication?view=sql-server-ver15

All Types of Replication:

https://docs.microsoft.com/en-us/sql/relational-databases/replication/types-of-replication?view=sql-server-ver15