Devart Forums

Hi

I have used this datasync to sync two tables to the server. It has worked ok until now:

Violation of PRIMARY KEY constraint 'PK__ReportDa__3214EC271D4CF30A'. Cannot insert duplicate key in object 'dbo.ReportData'. The duplicate key value is (20150811131154).

If I clear the table data from server side I can sync it once (all data) but not after that.
What could it be because it has worked before with filter timestamp > GETDATE()-30

It seems that timestamp > GETDATE()-30 is not working.

Two tables are connected with FK so when table1 is inserted one row,table 2 gets 5 rows with same ID.
Perhaps there has been writing in 0:00 or something which get the error.

Data in tables are not changing there is only new lines. How can I filter that so that I wouldn't need to compare the whole data??

Could you please let us know what version of dbForge you are using?

3.8.265
I had a update windows but I think I dont have username or password.

Is there possibilty to let program just increase rows but not change anyting?

I will try this: Timestamp>CONVERT(VARCHAR(10),GETDATE()-30,112)

We will review this post and will answer you as soon as possible.

Could you please send us the CREATE definitions for table1 and table2 on Source and Target and a couple of records (INSERT statements) for the tables?

You can send a reply straight to our support system at supportATdevartDOTcom