Trans. Replication and Primary Keys | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Trans. Replication and Primary Keys

I have a couple of tables a developer created that need to be added to replication. When attempting it returns an error saying that the table can not be replicated because it doesn’t have a Primary Key. Is it true that PKs are required for transactional replication or is there another way around it?
Generally speaking, in an RDBMS all tables should have a PK. There is no strict requirement, but PKs are the best kind of foundation to have.
But, are PKs required for the table to be part of transactional replication?
quote:Originally posted by Adriaan Generally speaking, in an RDBMS all tables should have a PK. There is no strict requirement, but PKs are the best kind of foundation to have.

yes Cheers
Twan
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/tranrepl.mspx fyi. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
But can you tell me the reason that what are the requirement of primary key in transactional replication in sql server.
Thanks.
gaurav

Transactional Replication mechanism uses PK to identify the rows modified (inserted/updated/deleted).
After seting up replication, you can check at the subscriber database. snapshot agent would have created 3 stored prcoedures (one for each operation) to insert the row to the table. Especially the update/delete procedures use PK.

]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |