microsoft sql mysql,Microsoft SQL数据库到MySQL数据库

I have seen tons of post on this, but I am not very familiar with the process and nothing has worked.

My basic problem is I am trying to get data from a Microsoft SQL database (Using Microsoft Management Studio 2008) to convert and use in a MySQL database (using MySQL Workbench)

I have tried to dump the .sql file but when I try to import into MySQL Workbench I get errors about it not being in the UTF-8 format. I tried several ways to get it to be that encoding (such as notepadd++ converting I saw suggested everywhere), but nothing seemed to work.

If I run it, I get this error:

ERROR: ASCII '\0' appeared in the statement, but this is not

allowed unless option --binary-mode is enabled and mysql is

run in non-interactive mode.

Again I looked up fixed for this, but could not get it.

I have tried a few options, just no success, so looking for some ideas or guidance with this area I do not have much experience in.

UPDATE:

The problem now is that the sql file I export from Management Studio is not accepted as a valid query in Workbench.

For example the brackets are not accepted and such.

解决方案

I bet your encoding is not supported in MySQL WorkBench.

You can change the encoding when saving a .sql file.

Select File|Save.sql As to invoke the save as dialog.

Notice that the Save button on the lower right hand side has a drop down icon to indicate options.

Select the drop down icon and choose the "Save with Encoding" context memu item.

Select an encoding that works in MySQL Workbench.