Troubleshooting

Single inserts

Bulk copy, bypassing SQL engine, is extremely performant. However, when there is a problem with the data and the target database reports an error, a whole batch of rows is discarded instead of a single records with problematic data. In such cases it makes sense to select just a problematic table, turn on this option, and examine the Error SQL log.

Shuffle tables

This option is useful if you are testing the load on a generated data, to have a bit more realistic look and feel of the migration.