is there some UML tool where I can draw my database design and generate SQL scripts for creating my database?
相关问题
- SQL join to get the cartesian product of 2 columns
- sql execution latency when assign to a variable
- Difference between Types.INTEGER and Types.NULL in
- php PDO::FETCH_ASSOC doesnt detect select after ba
- Bulk update SQL Server C#
argouml can do it - open source and cross-platform! but it's not yet a seamless experience, although they're working on it.
You better use Visio, it directly creates the tables on you server n also support reverse engineering... n supports many DB systems
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.
Yes there are some:
Micorsoft Visio
http://www.casestudio.com/enu/
http://www.dds-lite.com/
http://www.ca.com/us/database-design.aspx
You may try Visual Paradigm. [https://www.visual-paradigm.com/tutorials/sdevsgendb.jsp]
Sparx Enterprise Architect can do that. It can also reverse-engineer existing databases.
Of course, it does a lot more than this as well.