Replication problem please help..........

[pejmonmokarram]

Hello,

I was wondering if anyone out there could help me, I have a problem with the replication between two sites using one database. Both site are using SQL 7.0 Windows NT4.0 servers, Marge replication with the constant connection of 512KB between both sites.

******************************512 KB
******************Site A ----------------- Site B
****ID:1001 Jo Will---datadb**************datadb---ID:1001 Jen smith


Site A and Site B both are using a database name datadb, an user on site A adds a new client into system and the system generates an ID:1001 for that Client and on Site B a different user adds a different client into datadb and the system generate an ID:1001 as well.

When the data replicates the ID:1001 Overwrites each other and one of the client details gets deleted.

I was wondering if any one has ran into this problem before and knows how I could resolve it. Please Help if you do.

Many Thanks
Pejmon

[Tarry]

First:I didn't see the word oracle here, go to some sql server forum
Second: If it had anything to do with oracle you'd be posting it in the admin forum.