By default ("Append Data" mode), the program will add new records to the selected table.
There are three other modes:
In the "Replace mode", the program removes all data rows before adding new records. An alternative
to this mode for a database with a complex set of relationships is using the Clear Rule.
The third case called the "Update Mode" is the most complicated one. A table must have a Primary Key (PK) in order
to use this mode. If the table has no PK, you must manually select a field for searching records to be
updated (use the "Unique key" button near the mode drop-down menu to select a column). The program goes through
records one by one taking into account the where clause specified for this mode and updates those fields
whose fill mode is not Ignore.
The "Scramble" mode (does not supported by Standard and Professional editions), also known as data making,
uses two tables of the same or different databases. The program takes the contents of the first table (considering the
value of the WHERE clause) and gets data rows from it sequentially. The values of columns for which Ignore fill method was used are placed in the
target table as is. All other values are replaced with values generated according to the used
fill methods. In this case, the requirements for the presence of Primary Key or its manual specification
in the source table coincide with Update Mode. If the target table already exists, it will be deleted
without warning; after that, the program will create a target table identical to the source table.
See also: Data Masking Tool.