I have set up synchronization to move data from a website (mysql) to sql server and vice versa. When data is updated on the website, instead of syncing that data to the same row in sql server, the sync process creates a new row where the only difference between that row and the row already in the table that it should be updating is that updated column. What I end up with on both mysql and sql server are tables with nearly dupicate data. Is there an option to overwrite data in the sync process that I'm missing here? I assumed that Skyvia would automatically map data from one table to another, updating any data changes rather than creating new rows.
The screenshot provided shows (sql server) rows 2 and 8 as nearly identical. What I should see is one row with the most recent data present.