Extractor: Number of rows polled from the source database at a time
Show additional debugging information
Loader: Number of rows inserted per statement
Loader: Use REPLACE instead of INSERT for sequentially extracted data.
Migrator: Seconds to sleep when no data has been found
Sequential: Tracks status via a table’s primary key to see whether or not the table entries have been migrated. Useful for RO data which is written in sequence and not updated.
Timestamp: Tracks status via a table’s written timestamp column to determine whether table entries have been migrated from that point on.
Queue: Tracks status via a triggered table which contains indexed entries which need to be migrated. This requires modification of the source database to include Insert and Update triggers. Useful for all kinds of data, but needs modification to source database.