How many tables are involved in the sync ? Tables without a PK should not sync at all. I read the log-messge so that two tables do not qualify for sync (due to missing PK's) and are skipped and the rest of the tables are sync'ed
“Sync started at Thu May 12 14:00:00 2005” is the only message you'll get except for error messages.
Is the “abort on error” option set in the XML-file (I guess not!) ?
I believe the best thing you could do is to have a PK in all tables. If some tables are sync'ed and others not, I would not exclude that some transactions performed later could create empty or dublikate rows. Depends on the datastructure and what actions are performed on the data.
It's also a possibility that there isn't really empty or dublicate rows but only that the application used for reading the data “think”s there is, due to pointers pointing to the wrong row from one table to another. That could also easily be a result of an incomplete sync.
Of course there is not use to use two-way sync if you only want to write data from one server to another. But that in itself should not result in empty or dublicate rows.
I think it is not possible to say more as long as we don't know the table structure. For instance if FK's are used.
