Crash trying to migrate MySQL DB to SQL Server w/SQL Server Import Export Wizard

I'm trying to migrate a MySQL DB to SQL Server using MS's SQL Server Import Export Wizard. It isn't going so well... The wizard either tells me that the MySQL s开发者_C百科yntax is invalid or crashes depending on its mood.

Here is the query that it executes against MySQL before failing: select * from "_account"

Anyway to change so either MySQL likes the quotes or the wizard doesn't use them?

you'll need to look at your MySql sql_mode settings. you can only use "" around table names if you have ANSI_QUOTES turned on, for instance.

You might might have more luck with a different migration tool: I've used SQL Workbench and DDLUtils with success.