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.