且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何将SQL Server数据库转换为MySQL数据库

更新时间:2022-03-18 03:24:50

如果使用 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.