MS SQL 10.0 - Export grid rows

[expired user #8618]'s profile image [expired user #8618] posted 9 years ago in Import/Export Permalink
Hello,

First of all, thanks for a great piece of software! My favorite sql client.

I am using HeidiSQL Version 9.1.0.4894 (64 Bit) on a Windows 7 Pro 64 Bit Machine.

The problem is that heidsql.exe process freezes when I try to do "Export grid rows" on rather large results ( > 300.000).
The window "Export grid rows" does not even open. I have to kill the process.



On smaller results the "Export grid rows" works as normal. I get the new window and I can type in the filename I wish to export to.


[expired user #8618]'s profile image [expired user #8618] posted 9 years ago Permalink
Failure screendump:
https://drive.google.com/file/d/0B9QIv3eQiGqKb2xTSHF4ek9FOUU/view?usp=sharing

Success screendump:
https://drive.google.com/file/d/0B9QIv3eQiGqKUU5ERHpmODdVMW8/view?usp=sharing
[expired user #9601]'s profile image [expired user #9601] posted 8 years ago Permalink

Seeing the same thing on MS SQL 12, with anything above ~30,000 rows.

Has anyone had success with large-scale export of grid rows, or any tips or tricks to share?

Please login to leave a reply, or register at first.