sql-servertimeoutexportdbeaver

DBeaver connection is closed MS SQL

I am using DBeaver to connect to my MS SQL database hosted in local. I try to export my tables as CSV files. In the case where the query is rather big (40k rows which takes a couple of minutes) the export gets stopped with the message

"SQL Error: The connection is closed".

I kept the default parameters for dbeaver database connection, and my SQL server timeout is the default one (10 minutes, which is more than it takes to trigger the error)

Any idea where it might come from?

Solution

  • You know, the value of binary is extremely large and weight. So that takes much time to transfer via the network. That's the reason why you're getting error. In my opinion,

    1. You should split your query into multiple time to fetch data (How about 1k records in each time).

    2. Just get the exactly items that you need (where condition or the columns that you need instead of all)