ERROR - Read timed out about jailer HOT 2 CLOSED

Do you also get the error if the file is executed with another tool (MS SQL Developer etc.)?
It might help to reduce the number of "rows per statements" when exporting.
Or you increase the timeout. This should be possible with a queryTimeout/lockTimeout parameter in the JDBC URL. See https://docs.microsoft.com/en-us/sql/connect/jdbc/setting-the-connection-properties?view=sql-server-ver15

from jailer.

Thanks for the quick reply.

The export "rows per statement" was 50.
Also, on the import, parallel threads = 50.

I just tried with export "rows per statement" = 10
Import with 50 threads, and it worked, Finished without error in about 10 minutes.

I've tried Sql Server Management Studio and sqlcmd, but their too slow. Those take hours, single thread I assume, so not practical.

I can use bcp which is super fast (only a couple minutes) but I prefer the upsert SQL Jailer generates. It's takes less thinking ... usually.

from jailer.