Take the 2-minute tour ×
Ask Ubuntu is a question and answer site for Ubuntu users and developers. It's 100% free.

I would like to know which tool do you use for modeling tables, relationships, etc, generic database modeling, in Ubuntu.

It would be good if that tool generate SQL scripts, and a plus with those scripts are SQLite compatible, but thats not necessary.

Currently, I am using Enterprise Architect for that under a virtual machine, which kind of sucks. I was able to run it under Wine, but not as good as I want to. It is a complete tool for modeling anything in this world, and right now I do not need so much.

share|improve this question
    
u need UML Modelling tools..? –  sum2000 Dec 21 '11 at 10:28

3 Answers 3

up vote 2 down vote accepted

You may try DIA. You can use UML to create/model Databases and use one of the officially supported Scripts to convert it to SQL.

For instance you can find a basic How-To using DIA and TeDia2SQL at http://left.subtree.org/2007/12/05/database-design-with-dia/

share|improve this answer

Another good option is mysql-workbench. It can easily be installed using apt-get (the third command will do, yet I prefer to update and search first):

sudo apt-get update
sudo apt-cache search mysql-workbench
sudo apt-get install mysql-workbench

Then you can just type mysql in the HUB and voila.

enter image description here

It works like a charm. There is also a download from their website, yet that gave me in 12.10 a dependency error (the download is for 12.04 so that might explain it).

Others have also referred to: druid and DBDesigner. There is also another post on DB design on superuser.com.

share|improve this answer

You can try ArguoUML with its SQL plugin.

share|improve this answer
    
this answer is showing up in the low quality review queue??? So here goes the newbie blather: Although your answer is 100% correct, it might also become 100% useless if that link is moved, changed, merged into another one or the main site just disappears... :-( Therefore, please edit your answer, and copy the relevant steps from the link into your answer, thereby guaranteeing your answer for 100% of the lifetime of this site! ;-) You can always leave the link in at the bottom of your answer as a source for your material... –  Fabby Aug 3 at 16:16

protected by Community Aug 3 at 17:13

Thank you for your interest in this question. Because it has attracted low-quality answers, posting an answer now requires 10 reputation on this site.

Would you like to answer one of these unanswered questions instead?

Not the answer you're looking for? Browse other questions tagged or ask your own question.