0

Good afternoon,

Are there differences between Oracle 10g and MySQL with the CREATE, ALTER, DROP, REF, PRIMARY KEY, FOREGIN KEY and attribute variable type keywords?

The reason I ask, is I'm planning to use MySQL WorkBench to generate the SQL for Oracle 10g. If you'd recommend a different ERD modelling tool, please suggest one that can be generated from text.

Thanks for all suggestions,

Alec Taylor

asked Sep 17, 2011 at 6:56

1 Answer 1

2

There are big differences between the two. The datatypes are different (e.g. Oracle doesn't have the ENGINE part, int(5) is invalid for Oracle, LONGTEXT is invalid for Oracle and so on) and part of the syntax as well. Oracle does not have an "autoincrement" column. It has a different concept using sequences.

If you want to find all the differences you will have to read the manuals and compare for yourself

If MySQL Workbench emits only MySQL syntax you will need some manual search & replace to convert that to valid Oracle SQL but it is certainly doable.

answered Sep 17, 2011 at 9:04
2
  • Thanks, sounds like a lot of work, maybe I should look at a different ER Modelling tool... Commented Sep 17, 2011 at 9:58
  • I've decided to write the SQL by hand, and generate a diagram from that using SchemaSpy Commented Sep 19, 2011 at 11:32

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.