I use your last version 126.96.36.1998 trial and I test functionality to compare and sync data.
I have a problem.
I compare two DB’s. The DB’s are identical at level of structure/metadata.
Changes only datas.
I compare they without problems and generate the script to insert/update datas in the second DB.
As you can see by the screenshot in attach I set - Ignore BLOBS and TIMESTAMP columns.
When I try to execute the script SQL to sync data I obtain an error messages.
Category Timestamp Duration Message Line Position
Error 05/05/2012 13.44.13 0:00:00.358 - SQL Server Database Error: Sintassi non corretta in prossimità di ‘,’. 18 0.
In attach you find the script of comparison in 7z format.
The line with the problem is number 18. There is a double , instead a vlue.
I stay tune for your answer.
insert_update.7z (72.2 KB)