Monday, March 19, 2012

MS Sql replication - Primary keys problem

Hi.
I am trying to replicate an MS SQL server but when I do that all my primary keys on the tables on subscriber server are gone and the datebase is unusefull.
Can anyone help me in that situation?

Thanks in advance.

Quote:

Originally Posted by Yordan Yordanov

Hi.
I am trying to replicate an MS SQL server but when I do that all my primary keys on the tables on subscriber server are gone and the datebase is unusefull.
Can anyone help me in that situation?

Thanks in advance.


Set "Copy unique key constraints" property of the articles on the publisher to True if you're on SQL Server 2005.

No comments:

Post a Comment