August 19, 2009 at 8:51 am
dear all,
is the replication get rid of duplication
ex.
i have database offline
client1 and client2 work on database offline
say client1 and client2 save data in order table
client1 enter orderid=1001
also client2 enter orderid=1001
when i do replication is replication get rid of this duplication ?
waiting for your response ,
thanks
August 19, 2009 at 8:56 am
abr_mah (8/19/2009)
dear all,is the replication get rid of duplication
ex.
i have database offline
client1 and client2 work on database offline
say client1 and client2 save data in order table
client1 enter orderid=1001
also client2 enter orderid=1001
when i do replication is replication get rid of this duplication ?
waiting for your response ,
thanks
I think we need more detail in what you are trying to achieve here, replication does not get rid of duplication. however replication can distinguish between updates to the same data from different machines also known as subscribers.
If you reply with more detail and what you are trying to find out, people here can try and help you further.
~Silverfox~
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
August 19, 2009 at 9:01 am
There are a few possibilities, but please provide more information as SilverFox has noted.
One way is to set up a surrogate key as a GUID. They can be uniquely generated offline. Or assign a range to each client.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply