exporting db as SQL

HeidiSQL Portable: 9.4.0.5125

Trying to export a db, but its showing me that the selected object size is 0B. Even though I have complete access to the data and is able manipulate in any way I want.

Screenshot attached.

Has anyone else stumbled upon this issue?

Thank you

Also, I forget to mention, when I go ahead and export it, there is no data in the SQL file. Only queries to build the tables if they don't exist.

May it be because your database is empty - I see 0B also in right panel where the database list is...

May it be because your database is empty - I see 0B also in right panel where the database list is...

Yes I saw that as well! No it's absolutely not empty I have almost 2 million entries there. And I can see them through Heidi in the data tab!

SQL Server support is in general rather incomplete. I'd only rely on HeidiSQL for simple stuff such as inspecting table data and running SQL code. In any case, you can enable all log events in Tools/ Preferences/ Logging and try to figure out what HeidiSQL is trying to do. Perhaps there's a very specific column type that it can handle correctly.