2

I currently have a SQL Server 2008 database on Windows Server 2008 and I want to move the data to a MySQL 5.1.54 database on a Ubuntu server. I downloaded the MySQL ODBC 5.1 driver, created a DSN with correct connection information, and I tried to use the SQL Server Import and Export Wizard to export the data. However, in the queries the wizard generated, table and column names were surrounded with " characters instead of the correct ` characters, so I get syntax errors when I try to execute the export. I cannot edit all of the generated SQL by hand, so is there some configuration I can change to make it use the correct quote characters?

Improve this question

1 Answer 1

Reset to default
2

You need to activate ANSI quotes in mysql.

Try to add

SET sql_mode='ANSI_QUOTES'

to your scripts.

Improve this answer

You must log in to answer this question.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.