|
Update a Table |
  
|
|
Update a Table |
|
For all Tables you can transfer your data also with an UPDATE possibility which 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 panel)
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.
If you have a Multi Columned Primary Key then DMC will search in Destination table for the "combination" of all those columns to match the source record.
This is possible on any Primary KEY containing a maximum of NINE COLUMNS
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)
Use this type of Transfer Option for example when you need to UPDATE a Table with data from another one (backup after a crash in system .... New price List received from a supplier .... etc ....)