Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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?

share|improve this question

1 Answer 1

up vote 2 down vote accepted

You need to activate ANSI quotes in mysql.

Try to add

SET sql_mode='ANSI_QUOTES'

to your scripts.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.