Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Site Related Forums
 Article Discussion
 Regarding Merge Replication on Pocket Pc device

Author  Topic 

Starting Member

2 Posts

Posted - 2005-06-21 : 06:27:21

Respected Sir/Mam,

I'm developing a application on Pocket Pc emulator by using Merge replication to synchronize the database.

Database synchronization works totally fine in both the directions i.e frm Pocket PC -> Local Database & vice versa.

But when i try to insert a new record, i get the error as follows...

"A duplicate value cannot be inserted into Unique index..."

when i execute the SAME query in Ms SQL it works fine....But the same query gives error in Compact Environment.

When i searched on Net, I got one solution But it also did not work w.r.t my application.

it suggested...Delete the index column and then get the snapshot of the database...

But my index are generated with respect to PRIMARY Key column and thats why Ms SQL denies to delete indexes.

Thus, I hereby request You to suggest me something which i can implement.


Mandar C Jambotkar,

Agrofoyer Solutions Pvt. Ltd.,

- Advertisement -