RDA Push fail

  • Thread starter Thread starter Simone
  • Start date Start date
S

Simone

I have a table which has only one primary key in SQL Server.
I am inserting records in this table, and can see the records inserted in
SQL CE Query Analyzer.
I am getting errors when I try to push this table (duplicate primary keys).

rda.Pull("Actions", sqlCmd, Me.strRemoteConnString,
RdaTrackOption.TrackingOn, "ActionsErrors")

The first push works (no inserts, just updates), but the second one doesn't:
rda.Push("Batches", Me.strRemoteConnString)
rda.Push("Actions", Me.strRemoteConnString)

What I am doing wrong?
Thanks for your help.
 
Hi Simone,

Your Push is violating your PK at the server. Check the table, and see if
that PK already exists at the server.

I see this happen when there is an auto increment column in the table and I
have not set the seed and increment to be higher then the last value.

Alter table table_name alter column column_name identity (500,1)
 
Back
Top