distal-attribute
distal-attribute
distal-attribute
distal-attribute

exporting db as SQL

swedev posted 2 weeks ago in HeidiSQL portable

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

1 attachment(s):
  • sql
swedev posted 2 weeks ago

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.

gacuxz posted 2 weeks ago

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

swedev posted 2 weeks ago

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!

kalvaro posted 2 weeks ago

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.

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