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.