Suggestion for MS SQL export as sql

mbtoldya's profile image mbtoldya posted 6 months ago in General Permalink

Hi there!

I was wondering if you could add to the potential 'to do' list for next version of Heidi to ask user if the export should include a checkbox to replace " with ` so that an MSSQL export works when importing into MariaDB or MySql.

ansgar's profile image ansgar posted 6 months ago Permalink

Exporting table definitions between MS SQL and MySQL is full of incompatibilities, so it would not be sufficient to use a different quote character.

But indeed it could work if you just export the data with INSERTs. You could try to export directly from an MSSQL to a MySQL server. HeidiSQL should then use the quoting character required by the target server.

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