UML to SQL tool [closed]

问题:

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

回答1:

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

回答2:

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

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

回答3:

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.

回答4:

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

回答5:

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.

回答6:

You may try Visual Paradigm. [https://www.visual-paradigm.com/tutorials/sdevsgendb.jsp]

回答7:

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

回答8:

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

回答9:

Yes there are some:

• Micorsoft Visio

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

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

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

回答10:

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').