Any recommendations?
Dia and Vym come to mind, but they don't really fulfill the main requirement; i.e. to generate the SQL to create the ERD that I'm describing.
A:
There's plenty of diagramming tools for Linux (Dia is my favorite but its support for ERD diagrams is less than perfect, let alone SQL generation).
I've used Rational Software Architect - it's diagramming and SQL generation capabilities are pretty good and it's schema reverse-engineering are excellent. Based on Eclipse, it runs on Linux but it's not cheap (well, it is for me since I work for the publisher).
A search of Google didn't really turn up anything suitable (but you probably knew that already since that was your first point of call, right?).
One other option to consider is a Windows-based product running under Wine or VMWare Player. Not a pure Linux solution, I know, but you may have to resort to that to get what you want.
paxdiablo
2009-02-06 06:00:03
I love Dia, but like you mentioned, not really good for ERDs/schema generation.I've always felt that Rational products cost too much. RSA sounds really good, I'll probably browse around.I won't need Wine/VMWare as I have a spare (Windows) laptop to use.
Wayne Khan
2009-02-07 19:31:54
Dia is definitely unsuitable for this task, I just wish we could have something like Enterprise Architect for linux
rshimoda
2009-12-09 03:31:06
+6
A:
A long while ago I use to use fabFORCE DbDesigner which wasn't bad (although I seem to remember it being a pain to find all the dependencies, I've heard it will run alright with WINE though). It stored your data in an XML file and I remember I wrote some code to produce my own SQL scripts and database documentation HTML pages based on it.
It has been superseded by MySQL Workbench, which is download from here. Haven't had need to use it as yet, but it looks pretty good. I don't know how database agnostic it will be, but if it uses a similar XML format to DbDesigner you can always do what I did and write your own SQL generator for it.
Oracle's JDeveloper is another one to try. I have no experience with it (yet).
And another one I just came across that looks like it could be alright is SQL Developer.
EDIT: The Workbench download page only has alpha versions for Linux. I have seen it in my distros (openSUSE) repositories though, so have a hunt around. It may be packaged along with MySQL's GUI tools.
Evan
2009-02-06 06:34:00
MySQL Workbench looks interesting! I'd try out the Ubuntu .deb... except I currently develop for Oracle. :(
Wayne Khan
2009-02-07 19:28:01
I'm using Oracle SQL Developer on my other machine. I wasn't aware that it could generate ERDs? Maybe I gotta explore more. And honestly speaking, it is so slow I hesitate to use any of the official products. Maybe I'll try out JDeveloper. Thanks! :)
Wayne Khan
2009-02-07 19:30:59
A:
I've been looking for such a tool myself, and googling wasn't much help.
Thankfully I've found the answer - Oracle's SQL Developer Data Modeling tool. I've used it, and it's very good. It successfully reverse-engineered my new schema, as well as looking really slick.
It's not amazingly intuitive but you do pick it up quite quickly. There are releases for Windows, Mac and Linux.
At the time of writing it's in "Early adopter" stage, meaning you have to fill out a short survey to get a download.
atc
2009-05-13 09:40:02
+3
A:
Take a look at SchemaBank. They are browser-based SaaS. You can use any web browsers on Linux, with nothing to install at all.
Leigh Pyle
2009-10-07 08:58:02