将 MySQL 脚本转换为 SQL Server

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/1770795/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me): StackOverFlow

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-08-31 14:34:08  来源:igfitidea点击:

Convert MySQL script to SQL Server

mysqlsqlsql-server-2008code-migration

提问by NumberFour

I have a large MySQL set of commands in a file (script) and I need to execute it on a Microsoft SQL Server 2008. I know there are few differences in both languages, despite the fact the base SQL is the same.

我在文件(脚本)中有大量 MySQL 命令集,我需要在 Microsoft SQL Server 2008 上执行它。我知道这两种语言几乎没有区别,尽管基本 SQL 是相同的。

Is there any way how to convert a MySQL script to one that is executable on SQL Server? Or is there any migration app that can easily take the whole MySQL server and replicate everything on SQL Server 2008?

有什么方法可以将 MySQL 脚本转换为可在 SQL Server 上执行的脚本?或者是否有任何迁移应用程序可以轻松获取整个 MySQL 服务器并复制 SQL Server 2008 上的所有内容?

Thanks for any advice.

感谢您的任何建议。

回答by ppolyzos

I tried Full Convert Enterprisewith quite big success. Fast, easy and it did my job. Give it a try it may help you

我尝试了Full Convert Enterprise,并取得了相当大的成功。快速、简单,它完成了我的工作。试一试它可能对你有帮助