Update a Table

For all Tables you can transfer your data also with an UPDATE possibility which from version 1.4.0.2 is set like this :

When you are in the Mapping tab (after doing all mappings normally) select any COLUMN (part of a KEY and UNIQUE preferably and double-click on the record (right pane)

You will find a Tab named 'Update'

Check this box to 'tell' DMC that this column will be used as 'identifier' when doing the transfer

You can have only ONE Identifier column and to change it you need to uncheck first the old one.

Then use the Transfer button and at each record, DMC will search in the Destination table if a record matches the current Source column's value and if a match is found an UPDATE will be done (otherwise an INSERT will take place)