Exporting table in MS SQL

Hello,

There is some syntax error in Export for SQL Server(From MSSQL to MSSQL). I'm using the SQL Server 2008.

For example, when exporting data from a table to another, it tries to use some MySQL syntax for SQL Server. (Eg: INSERT IGNORE INTO, REPLACE, ...)

Is it possible fix this syntax? In my job, recently, they only use MS SQL, then I don't have any alternative as good as Heidi to work, but I got this errors because of syntax.

Best Regards, Thiago

The SQL Server Import and Export wizard, do that for all the database. I needed it only for one table.

In the end, I had to split my data in order to bulk insert in the other remote database table.

I thought the point was to suggest improvement to HeidiSQL. I think it should be compatible with all DMBS with no need to use other tool.

I still hope they make the export option full compatible with syntax queries for MSSQL and stop using on MSSQL some queries export which only works in MySQL.

Regards, Thiago