UML to SQL tool

Question

Hi, is there some UML tool where I can draw my database design and generate SQL scripts for creating my database?

thanks

Answer 1

I can recommend Enterprise Architect from http://www.sparxsystems.com.au/

Answer 2

Yes, several CASE (computer-aided software engineering) tools exist that will do this. Microsoft Visio is one such.

Answer 3

Sparx Enterprise Architect can do that. It can also reverse-engineer existing databases.

Of course, it does a lot more than this as well.

Answer 4

You better use Visio, it directly creates the tables on you server n also support reverse engineering... n supports many DB systems

Answer 5

Yes there are some:

• Micorsoft Visio

• http://www.casestudio.com/enu/

• http://www.dds-lite.com/

• http://www.ca.com/us/database-design.aspx

Answer 6

Erwin from CA is one such tool.

We started playing with the idea of using it at a previous employeer of mine. But found the complexity of the tool and cost offset the need for it.

Answer 7

argouml can do it - open source and cross-platform! but it's not yet a seamless experience, although they're working on it.

Answer 8

You can also try the online code-generation service MOLA::UMLtoDB that automatically generates a SQL DDL script to create the database corresponding to an input UML class diagram.

Answer 9

I don't know what sort of SQL flavour you're using but you could try MySQL Workbench. It's cross platform and free (as in 'free speech' not as in 'free beer').