如何将SQL Server数据库转换为MySQL数据库 [英] How to convert SQL Server database to MySQL database

问题描述

我使用ASP.Net创建了一个网站，使用SQL Server创建了一个表，并将其发布到了提供程序中.

I have created an website using ASP.Net, a table using SQL Server, and I have published it to a provider.

我想要的是将MSSQL.sql文件转换为Mysql.sql文件.是否有任何免费软件，或将其转换为SQL Server到MySQL的一些代码?

What I want is to convert the MSSQL.sql file to Mysql.sql file. Is there any free software, or some code to convert it to SQL Server to MySQL ?

如果有人可以帮助我，将不胜感激.

It would be much appreciated if someone could help me.

推荐答案

如果使用 phpMyAdmin 管理您的MySQL(几乎所有Web主机都使用它)，您只需在兼容模式中为MSSQL导入文件即可.

If you use phpMyAdmin to manage your MySQL (which almost all web hosts use) you can simply import the file in compatibility mode for MSSQL.

为此，请转到导入"->选择文件"->，然后从" SQL兼容模式:"下的格式化特定选项"下选择"MSSQL".

To do this, go to Import -> Choose your file -> Then select "MSSQL" from SQL compatibility mode: under Format specific options.

如果尚未安装phpMyAdmin，则可以从我上面链接的网站免费下载.其网站上的说明非常易于安装.

If you don't have phpMyAdmin already installed, you can download it from the site I linked above for free. The instructions on their website are very clear for installation.

导入后，如果要使用MySQL的语法保存SQL文件的副本，只需使用导出功能.

After import, if you want to save a copy of the SQL file in MySQL's syntax simply use the Export feature.

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