SQL modeling and design tools?

software-recommendation database diagram sql

19,141

Solution 1

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/

Solution 2

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.

Solution 3

You can try ArguoUML with its SQL plugin.

19,141

Pedro Dusso

I’m a seventh semester student at UFRGS, which I intend to graduate at the end of 2011. I interned at UFRGS, Mobiltec (working with Microsoft technologies for mobile devices) and currently at DELL (working with Microsoft technologies developing intranet web sites). In the last three years, the most interesting subjects to me were Software Engineering, Artificial Intelligence, Data Bases and Memory Evolutive Systems (from a Categorial approach).

Updated on September 18, 2022

Comments

Pedro Dusso over 1 year

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.
Fabby almost 9 years

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...
nwaweru over 4 years

+1 for mysql workbench. You can also synch changes to a mysql database.