将.bak转换为.sql文件 [英] Convert .bak to .sql file

问题描述

我有Sql Server backUp文件。现在我想将sql server转换为mySql格式（.sql）

i have Sql Server backUp file . now i want to convert sql server into mySql format(.sql)

推荐答案

恢复备份，然后使用SQL发布向导将其编写为SQL语句。

这是我能看到的唯一选项。

Restore the backup and then script it out to SQL statement with something like SQL publishing wizard.
that is the only option i could see.

为了澄清，如果有问题的SQL与MySQL中的SQL不兼容，那么你必须修复它手。但是，您可以使用management studio中的任务菜单来编写整个数据库的脚本，然后在MySQL中运行该脚本时，它应该告诉您由于SQL实现的不同而导致的任何错误。

To clarify, if the SQL in question is not compatible with SQL in MySQL, then you have to fix it by hand. However, you can use the tasks menu in management studio to script the entire database, and then when you run that script in MySQL, it should tell you of any errors due to difference in the SQL implimentation.

看看这里：

http://stackoverflow.com/questions/156279/how-to-import-a-sql-server-bak-file- into-mysql [ ^ ]

这篇关于将.bak转换为.sql文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！