cannot insert rows into Pulled table (RDA)

hello,

I've setup a RDA (Remote Data Access) connection between a PocketPC(Windows CE 5.0) and a SQL Server 2008 Express. Everything works fine (the Pull and the Push), but I can't insert rows into the tables in the SQL Mobile 3.5 database. Pulled tables have Identity rows and Primary keys on the Identity row. I can update and delete rows, but when I try to insert, it give the following error: "A duplicate value cannot be inserted into a unique index. [Table name, Constraint name]"

Insert statement is: "INSERT INTO TB_prdModel(modDesc, catID) values ('test', 1)"

Table TB_prdModel have 3 rows: modID (PK, Identity), modDesc (nvarchar(100)), catID (int).

Anyone have an idea how to fix this please? thanks for your time and help

Dominic34Asked:
Who is Participating?
 
Dominic34Author Commented:
Ok, I converted all INT Identity to GUID, now it works fine. thanks to myself for the answer.
0
 
Dominic34Author Commented:
seems the Identity value of the column is reset to 1 after the Pull. So, either I reset the Identity to the MAX value of all the tables or I change all my tables from INT Identity to GUID. What should I do?

GUID take a LOT more memory than INT and is a pain to work with (not really user-friendly). But INT Identity could cause problem when synchronizing with multiple clients.

What is the best way to sync tables using RDA ??
thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.