sg05121983
asked on
Regarding P2P transactional replication - MS SQL server 2008
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.
"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.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER