Microsoft SQL数据库到MySQL数据库 [英] Microsoft SQL DB to MySQL DB

问题描述

我已经看到了很多关于此的帖子，但是我对该过程不太熟悉，没有任何效果.

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

我的基本问题是我试图从 Microsoft SQL数据库(使用Microsoft Management Studio 2008)中获取数据，以转换并在 MySQL数据库中使用(使用MySQL)工作台)

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)

我尝试转储.sql文件，但是当我尝试导入MySQL Workbench时，出现有关不是UTF-8格式的错误.我尝试了几种方法来实现编码(例如，我在任何地方都看到了建议的notepadd ++转换)，但是似乎没有任何效果.

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.

更新: 现在的问题是，我从Management Studio导出的sql文件在Workbench中不被接受为有效查询.

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.

推荐答案

我敢打赌，MySQL WorkBench不支持您的编码.

I bet your encoding is not supported in MySQL WorkBench.

您可以在保存.sql文件时更改编码.

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

1. 选择File | Save.sql As来调用另存为对话框.
2. 请注意，右下角的保存"按钮带有一个下拉图标，用于指示选项.
3. 选择下拉图标，然后选择使用编码保存"上下文菜单项.
4. 选择一种适用于MySQL Workbench的编码.

这篇关于Microsoft SQL数据库到MySQL数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！