Troubleshooting

Load Data Using Single SQL 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

Randomize the order in which tables are loaded to the target database. This is particularly useful for testing and scenarios where the load order could affect the outcome, such as when using generated demo databases where dependencies between tables are not a concern.