Friday, May 8, 2009

New Things to Look: Oracle SQL Developer with MySQL

GUI Interfaces to use with MySQL

When meeting with MySQL customers I always get asked about GUI interfaces.
  1. I am always asked, what GUI to you recommend with MySQL? Two of the most popular are SQLYog and Navicat for MySQL customers.
Looking at Oracle SQL Developer

I think it is time to see how well SQL Developer works with MySQL. Oracle's SQL Developer has matured into a very nice tool and its free. I also want to see how well it migrates objects between MySQL and Oracle databases. SQL Developer has a lot of very cool functionality and all the interfaces are well designed. SQL Developer is also a Java application so you have the same look and feel on Linux, Mac OS and Windows.


3 comments:

Roland Bouman said...

Hi George!

"I think it is time to see how well SQL Developer works with MySQL."

I did a review a while ago:

http://rpbouman.blogspot.com/2007/01/oracle-sql-developer-11-supports-mysql.html

"Oracle's SQL Developer has matured into a very nice tool and its free."

It's free of charge, and for managing Oracle databases, it's pretty good. However, over the past few years there has been exactly zero improvement regarding the MySQL support.

I am currently using 1.5.0.54.4 (which is perhaps 4 months old). I know here is a newer version (1.5.4.59.40) so I may not be completely up to date, but the fact that in the past two years not one of the issues I describe in my blog article have changed does not inspire enough confidence to expect an upgrade maks any difference.

"I also want to see how well it migrates objects between MySQL and Oracle databases."

As far as I know, it is one way - Oracle to MySQL. More info in that in the comments on my blog post by Sue Harper (at the time she was PM for SQL Developer).

For now, I'm sticking with Squirrel and Eclipse. Both these are java based, and both are perfectly capable of delivering reasonable cross-database support (reasonable meaning: it is at a level that is suitable for developing SQL applications. For managing databases on a DBA level I don't believe cross-database tools will ever really cut it)

Anyway, I'd be interested to know if you find any features in SQL Developer that make it useable for MySQL. TIA,

Roland

Roland Bouman said...

Hi!

one update on my previous comment. I can see that at least stored procedure parameters now do appear in the ddl. So at least, I shouldn't have said that was zero improvement over the years.

Log Buffer said...

"George J. Trujillo Jr. wonders about Oracle SQL Developer with MySQL..."

Log Buffer #146