Table creation

Recreate

If you want tables to be created from scratch each time you run the conversion, leave this at the default value of Recreate. If table already exists in target, it will first be dropped, then created.

Expect existing

When you want to preserve existing tables in the target without dropping them, select Expect existing. Full Convert will truncate the table content but won't drop the affected tables.

Data copying

Everything

This default value will copy the original table data into the target table. If you chose Expect existing creation mode, target will be truncated before copying.

Added records

In this mode, Full Convert will check what's the highest value of the primary key in source vs target table, then copy only the records with higher PK value from the source. If you chose Expect existing creation mode, target will not be truncated before copying and you will not have duplicated records.

Append records

In this mode, all records will be copied regardless if Expect existing mode is used. It's your responsibility for source table to contain fresh data on each run, otherwise you will end up with duplicated records.