out.writeMode Argument
With the out.writeMode argument you can control how and what data DbTransfer will write to the destination.
If not specified the write mode Insert will be used.
Format
/out.writeMode:ModeToUse
Example
/out.writeMode:Insert
Required
This argument is optional.
Possible values
Insert, Update, UpdateAndInsert or Replace
Insert
Inserts the records from the source into the destination.
This is useful when you want to import data/records that are new to the destination.
This mode does not update existing records in the destination. Basically all records from the source are inserted into the destination now matter which records might already exist in the destination.
Update
Updates existing existing records in the destination with the data from the records in the source.
This is useful when you want to refresh existing data/records in the destination with newer values from the source.
This mode does never insert new records into the destination.
UpdateAndInsert
Updates existing records in the destination with the data from the records in the source and inserts new records from the source into the destination.
This is useful when the source contains both updated records and new records and you want to have both insert the new records and update the existing records in the destination.
Replace
Deletes the records in the destination and then inserts the records from the source.
This is useful when you want to replace all the records in the destination with the records from the source.