Difference between MYSQL and MYSQL eNTERPRISE EDITION

[omerbutt]

Hi
my question is that what is the difference between mysql and mysql enterprise edition
our client has demanded the if we will use mysql enterprise edition because in future he wanted to shift the db to oracle and the stored procedures in the mysql enterprise would be working as is for oracle too
now what should i recommend to them , does mysql also has the ability to export the stored procedures to oracle as is without changing or not , and what are the main edge finally.
Regards,
omer aslam

[Atli]

Hey.

I've never used the enterprise edition myself, but as I understand it the only difference between the community edition and the enterprise edition is added support and tools. The server itself is the same, but the enterprise edition gets updated more frequently.

For a comparison, see Which Should I Use: MySQL Enterprise or MySQL Community Server?.

As for moving procedures to Oracle as-is, check out Oracle SQL Developer. It apparently supports migrating MySQL database to Oracle.

[omerbutt]

Hi Atli,
Means it wont make any big difference if i recommend them to continue using the normal MYSQL enterprise edition , it would be safe and will not make any problem if the decide to move on to ORACLE in future
regards,
Omer Aslam

[rkoziol7]

I guess you will have to translate your procedures to Oracle PL/SQL either if you are using MySQL enterprise or MySQL standard edition.

Enterprise means only that you will have support for your DB in case if there were problems with your MySQL DB's which were not your fault. I guess that there is some licence limit with MySQL's standard edition (you must make you code Open Source or something like that).

I am not 100% certain of the above so maybe someone will make this sure?

[mwasif]

it would be safe and will not make any problem if the decide to move on to ORACLE in future

Yes, there will be no problem in the future migrating to Oracle.

[omerbutt]

Thanks ,
everyone for the replies
regards,
Omer Aslam