Regarding P2P transactional replication - MS SQL server 2008

Posted on 2013-09-17
Medium Priority
Last Modified: 2013-09-24
We are facing below error while configuring PUBLICATION on PROD (SQL 2008) server (P2P TRANSACTIONAL REPLICATION).

"This table cannot be published because it does not have a primary key column. Primary key columns are required for all tables in transactional publications."

In PROD server, some tables doesn't have primary key values and because of this we are facing above error.

Just I want to know from MS SQL experts, is there any other alternative solution for publishing tables that doesn't have primary key columns in P2P TRANSACTIONAL REPLICATION.

I believe using merge replication we can achieve above goal but is it possible using P2P transactional replication?

Please share your comments on the same.
Question by:sg05121983
LVL 14

Assisted Solution

by:nishant joshi
nishant joshi earned 300 total points
ID: 39503697
every replication works with primary key and it's required first while adding article to replication.you need to create primary key of you want to use replication.

LVL 16

Accepted Solution

DcpKing earned 300 total points
ID: 39503821
So far as I know you need to declare a primary key, so that the DBMS can identify records to replicate etc. I don't believe that there's any other way of doing it!
LVL 43

Assisted Solution

by:Eugene Z
Eugene Z earned 150 total points
ID: 39507605
snapshot replication for the pk-less tables
the rest , with pk can be used in trans replication

Author Closing Comment

ID: 39517159

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Ready to get certified? Check out some courses that help you prepare for third-party exams.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

619 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question