Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
shahjugnu
Starting Member
1 Post |
Posted - 2012-04-14 : 06:47:27
|
Hello!
I have a query regarding Merge Replication.
I have 5 Tables.
SetYarnMain Fields (MainId(PK), MainName, Comments) SetYarnSub (SubId(PK), SubName, MainId(FK), Comments) SetYarnDet (DetId(PK), DetName,SubId(FK),MainId(FK), Comments) SetYarnGrp (GrpId(PK), GrpName, DetId(FK),SubId(FK),MainId(FK), Comments) SetYarn (YarnId(PK),YarnName,GrpId(FK),DetId(FK),SubId(FK),MainId(FK),Comments) These Tables doesnt have Identity Column and PK are of char datatype
Lets take 2 tables SetYarnMain and SetYarnSub. I am generating a series in SetYarnSub Table with respect to SetYarnMain Table. Let say MainId is 01 at Location A and at Location B.
If a user at Location B Inserts a row the SubId let say becomes 01001, but If a user at Location A Inserts a row then same Id is generated because the replication hasn't done yet.
When merge replication is performed table SetYarnSub at both location has 01001 id creates conflict in PK.
I need to know how to solve this problem.
Please if someone has the solution I humbly request to post it immediately.
Thanks and Regards ShahJugnu |
|
|
|
|