Skip to Main Content

SQL Developer Data Modeler

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Producing ANSI DDL for MySQL

jflackJun 24 2019 — edited Jun 25 2019

I know that MySQL is not supported, but it does work to add the MySQL JDBC driver and reverse engineer from the database dictionary.

So I reverse engineered to Logical Model and have made many changes to produce the Logical Model for the next major redesigned version of this database.  My thought is that even if I can't generate DDL for MySQL, I can generate fairly generic ANSI SQL DDL and manually edit it for MySQL.

Question - which database of the supported ones - Oracle, SQL Server, and a few flavors of DB2 would be the best to target?  Which will require the least amount of manual changes?

BTW, when I imported from MySQL, SDDM decided to do it as Oracle Database 11g - maybe because I had previously imported an Oracle Database.

This post has been answered by Philip Stoyanov-Oracle on Jun 25 2019
Jump to Answer
Comments
Post Details
Added on Jun 24 2019
4 comments
1,233 views