从Microsoft SQL Server到MySQL的转换 [英] Conversion from Microsoft SQL Server to MySQL

问题描述

如何转换Microsoft SQL Server数据库备份文件以便导入MySQL数据库?有什么方法或免费工具可用吗?

How do I convert a Microsoft SQL Server database backup file such that to import in MySQL database? Is there any way or free tool available for this?

推荐答案

不确定数据库的复杂程度，但是如果它只是一些表和数据，则有一个

Not sure about how complex a database you have, but if its just some tables and data, there is a free script here that will automagically convert Microsoft SQL Server tables and data over to MySQL.

如果您需要更复杂的工具，则MySQL具有迁移工具包，该工具包可让您从Microsoft SQL Server迁移到MySQL.此外，这里是一个教程关于如何使用它.请注意，现在已停止使用它，而推荐使用 MySQL Workbench .内置的="=" https://www.mysql.com/products/workbench/migrate/"rel =" nofollow noreferrer>数据迁移.

If you need something more sophisticated, then MySQL has a migration toolkit which allows you to migrate from Microsoft SQL Server to MySQL. In addition here is a tutorial on how to use it. Note that this has now been discontinued, in favor of MySQL Workbench, which has data migration built in.

此外，此转换器会将除存储过程以外的所有内容从MSSQL转换为MySQL ，价格仅为50美元，还不错.

In addition, this converter will convert everything except stored procedures from MSSQL to MySQL, for a price of only $50 which isn't bad.

此外，您可能想查看此白皮书，有关如何计划从SQL Server到MySQL的迁移以及一些资源.

Also you may want to check out this whitepaper from MySql's website on how to plan a migration from SQL Server to MySQL, as well as some resources.

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