I create 2 tables for my test.
table1 (int id, nvarchar(10) Name)
id is PK and IDENTITY set to YES
table2 (uniqueidentifier id, nvarchar(10) Name)
On columns id : IS row ID = YES and Default value = (newid())
I add row in both table and Synch for the first time.
Now on each side I add a row
Server side:
insert table1 (name) values('test2')
insert table1 (name) values('test2')
PDA side
insert table2 (name) values('PDAtest2')
insert table2 (name) values('PDAtest2')
and Synch again.
All row was there in the table2
But it missing pda inserted row in the table1.
How can get all row without changing the type of my PK id in table1?