SQL Export not working with HeidiSQL Version 9.1.0.4940

Hi,

i use HeidiSQL to export a DB regularily and noticed that after updating to the current version the export does not work properly anymore. The attachment shows the options for the export. After export has finished i get a file that contains incomplete CREATE TABLE statements like

-- Dumping structure for table %TABLENAME%

CREATE TABLE IF NOT EXISTS "%TABLENAME%" 
);

A fix would be appreciated.

So lonG

My gosh, i forgot to mention the DB kind. Here is a quote the export file:

-- Server version:               Microsoft SQL Server 2008 R2 (SP2) - 10.50.4321.0

-- Server OS:                    Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

Ok, here is how to reproduce it:

- right click a DB in the main window of HeidiSQL
- choose "Export database as SQL"
- uncheck the preselected DB in the "Table tools" dialog and tick another DB
- set the options according to the attachment above
- click export
- open the exported SQL file and see incomplete CREATE TABLE statements

Sigh, MSSQL again :)
Will check that.

The exported SQL file and see incomplete.....!!



______________________________
*Signature*

Sigh, MSSQL again :)
Will check that.

Hello DEV,

Is this problem solved? I just started to use you app and have the same "error". The appp is exporting into MySQL format.

I using the 9.3 version

Hi, i have the same problem right now. (9.3.0.5044) The definition of the int values (INT(10,0) is also wrong... some key operations throws error too.

No Chance to import an export ms sql file :(