Why is SymmetricDS replication creating multiple rows with the same unique column despite using sync_key_name?

Question

I am trying to configure SymmetricDS to replicate data from a table that does not have a defined primary key. I have defined the unique column in sync_key_name but the replication is still inserting new rows for existing data, resulting in multiple lines containing the same value for the 'unique' column.

Is there any other configuration required to use sync_key_name than just entering the field into it?

We initially entered the sync_key_name value as lowercase, but corrected it to upper case but we still are getting duplicates. I can't see any other settings that appear relevant to this.

Answer 1

SymmetricDS will not add constraints to your target table. The sync_key_names setting determines the columns that SymmetricDS will use in the where clause when it replicates a delete or an update statement. When you send a load, the data comes through via insert statements. If you run a load multiple times, then it will send the same rows again and the target table will contain duplicate rows.