unable to export database & max row limit bug

[expired user #10194]'s profile image [expired user #10194] posted 7 years ago in General Permalink

Hello, I'm new to HeidiSQL. I'm trying to export to database a remote MSSQL database I am connected to, but Heidi only creates the structure and no data. The remote server provides me with some Views, which I do have access to see (I can view the data), but on export it fails to save any data. Some of the views have more than 200.000 rows. Am I doing something wrong? I do check all the Views and INSERT on data, create database, tables etc. on the Export

P.S. The message saying "go to tools -> preferences -> Data to change the max limit of rows" (currently 100.000) is wrong, there is no such option at the preferences window. How can I change the limit ?

Thank you in advance.

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