Troubleshooting
Last updated
Last updated
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.
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.
