将数据和架构从MySQL迁移到SQL Server [英] Migrate Data and Schema from MySQL to SQL Server

问题描述

有没有免费的解决方案，可以自动将数据库从MySQL迁移到可以正常使用"的SQL Server Server?

我整天都在尝试这个简单的(至少我是这么认为的)任务.我尝试过:

I've been attempting this simple (at least I thought so) task all day now. I've tried:

1. SQL Server Management Studio的导入数据功能
2. 创建一个空数据库
3. 任务->导入数据...
4. 用于Odbc的.NET Framework数据提供程序
5. 有效的DSN(已验证连接)
6. 从一个或多个表或视图复制数据
7. 检查1个非常简单的表
8. 点击预览
9. 获取错误:

1. SQL Server Management Studio's Import Data feature
2. Create an empty database
3. Tasks -> Import Data...
4. .NET Framework Data Provider for Odbc
5. Valid DSN (verified it connects)
6. Copy data from one or more tables or views
7. Check 1 VERY simple table
8. Click Preview
9. Get Error:

无法提供预览数据 检索到.附加信息: 错误[42000] [MySQL] [ODBC 5.1 驱动程序] [mysqld-5.1.45-community]您 您的SQL语法有错误； 检查对应的手册 您的MySQL服务器版本 在附近使用正确的语法 第1行的"table_name"(myodbc5.dll)

The preview data could not be retrieved. ADDITIONAL INFORMATION: ERROR [42000] [MySQL][ODBC 5.1 Driver][mysqld-5.1.45-community]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"table_name"' at line 1 (myodbc5.dll)

如果我通过向导的其余部分并执行操作，则会发生类似的错误.失败的步骤是设置源连接"，该错误是指检索列信息，然后列出了以上错误.当我修改列映射时，它可以很好地检索列信息，因此我真的不知道问题出在哪里.

A similar error occurs if I go through the rest of the wizard and perform the operation. The failed step is "Setting Source Connection" the error refers to retrieving column information and then lists the above error. It can retrieve column information just fine when I modify column mappings so I really don't know what the issue is.

我还尝试获取各种MySql工具来输出SQL Server可以理解但未成功的ddl语句.

I've also tried getting various MySql tools to output ddl statements that SQL Server understand but haven't succeeded.

我已经尝试将MySQL v5.1.11与SQL Server 2005以及MySQL v5.1.45与SQL Server 2008(分别使用ODBC驱动程序3.51.27.00和5.01.06.00)

I've tried with MySQL v5.1.11 to SQL Server 2005 and with MySQL v5.1.45 to SQL Server 2008 (with ODBC drivers 3.51.27.00 and 5.01.06.00 respectively)

推荐答案

Microsoft提供了两个免费工具包.

There are two free toolkits provided by Microsoft.

1. 用于MySQL v1.0的Microsoft SQL Server迁移助手 http://www.microsoft.com/download/en /details.aspx?displaylang=en&id=14280

1. Microsoft SQL Server Migration Assistant for MySQL v1.0 http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=14280

用于MySQL v5.1的Microsoft SQL Server迁移助手 http://www.microsoft.com/download/en/details.aspx ?id = 26712

Microsoft SQL Server Migration Assistant for MySQL v5.1 http://www.microsoft.com/download/en/details.aspx?id=26712

我只使用了第二个，它对我没有任何毛刺. 它需要向Microsoft注册才能下载许可证文件. 但是，每个人都可以免费使用.

I have used only the second one and it worked for me without any glitch. It required registration with Microsoft for downloading a license file. But it is free to use for everyone.

这篇关于将数据和架构从MySQL迁移到SQL Server的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！