如何自动将 MySQL DDL 转换为 Oracle DDL?

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/14829227/
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 16:31:49  来源:igfitidea点击:

How can I automatically convert MySQL DDL to Oracle DDL?

mysqlsqloracleconverterddl

提问by Josep

I know my question sounds a little bit like a shopping request, but I honestly believe that many people could find it useful.

我知道我的问题听起来有点像购物请求,但老实说,我相信很多人会发现它很有用。

I've been looking for an automatic tool that converts Data Definition Language from MySQL dialect to Oracle dialect - the other way round would also be fine. I found “SQL Fairy” but I was unable to run it; probably because I'm not familiar with PERL.

我一直在寻找一种自动工具,可以将数据定义语言从 MySQL 方言转换为 Oracle 方言——反过来也可以。我找到了“SQL Fairy”,但我无法运行它;可能是因为我不熟悉 PERL。

Is there any free tool for Windows that converts MySQL DDL to Oracle DDL?

是否有任何免费的 Windows 工具可以将 MySQL DDL 转换为 Oracle DDL?

回答by JeanPaulDepraz

This site really worked for me and it can convert a bunch of different DDL commands from Oracle, MySql, M$ Sql Server, Sybase and others. http://www.sqlines.com/online.

这个站点真的对我有用,它可以转换来自 Oracle、MySql、M$ Sql Server、Sybase 等的一堆不同的 DDL 命令。http://www.sqlines.com/online

Please note the disclaimer below the tool:

请注意工具下方的免责声明:

Note. SQLines Online is a unrestricted version for EVALUATION USE ONLY. For use in projects, please obtain a license.

笔记。SQLines Online 是一个无限制版本,仅供评估使用。如需在项目中使用,请获取许可证。

回答by Brian

Oracle has web pages filled with information on this: Database Migration Technologywhich gives detailed instrctions and help for several different databases including MySql.

Oracle 的网页上充满了这方面的信息:Database Migration Technology,它提供了包括 MySql 在内的几种不同数据库的详细说明和帮助。

The main tool referenced: Oracle SQL Developeris free.

引用的主要工具:Oracle SQL Developer是免费的。