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

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

4 Answers 4

up vote 3 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

You can try ArguoUML with its SQL plugin.

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

See sql server recovery MDF file

The entry http://www.oemailrecovery.com/sql_recovery.html has a lot of features for working with sql databases

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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