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.
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.
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.