Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

replication Expand / Collapse
Author
Message
Posted Wednesday, August 19, 2009 8:51 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, July 15, 2013 8:05 AM
Points: 17, Visits: 63
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
Post #773592
Posted Wednesday, August 19, 2009 8:56 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, September 15, 2014 5:22 AM
Points: 2,728, Visits: 1,119
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~


--------------------------------------------------------------------------------------
Recommended Articles on How to help us help you and
solve commonly asked questions

Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden
Managing Transaction Logs by Gail Shaw
How to post Performance problems by Gail Shaw
Help, my database is corrupt. Now what? by Gail Shaw
Post #773600
Posted Wednesday, August 19, 2009 9:01 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 11:23 PM
Points: 33,278, Visits: 15,449
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.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #773616
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse