database design tool question [closed]

As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for guidance. Closed 10 years ago.

is there a good database design tool can generate sql script to create database (tables) in major database (Oracle, MySQL, SQL server, Sybase) without any changes?

Which de开发者_开发百科sign tool are you think is good.

---

I prefer Power Architect, for the same reasons I listed in this question:

• Accesses source databases via JDBC
• Connects to multiple source databases concurrently
• Compares data models & database structures and identifies discrepancies
• Drag-and-drop source tables & columns into the playpen
• Remembers the origin of each column
• Generates source-to-target visual Mapping Reports
• Forward/reverse engineers PostgreSQL, Oracle, MS SQL Server & more
• Saves source data structure snapshots in the project, so you can work remotely
• All project data is stored in an easy-to-parse XML format
• OLAP schema modeling: Cubes, Measures, Dimensions, Hierarchies & Levels
• GPL (version 3) licensed

...and a couple reasons of my own:

• runs on basically any platform
• has fairly nice keyboard support for fast model development
• relatively useful diagram auto-layout

---

I've used Datanamic's DeZign for Databases with success. It's a graphical interface that can generate the scripts for almost every major database.

---

I am using Enterprise Architect. I use it for all of my design UML based use cases, Architectural views, class/collaboration diagrams and database schema. Its great. One can generate script very easilly.

---

Maybe you could consider using the UML2DB SQL generation service:

http://modeling-languages.com/content/uml2db-full-code-generation-sql-scripts-databases

Choose your UML tool (e.g. ArgoUML), draw a class diagram, (optional) configure some code-generation options in the web interface and it's done. Forget about using stereotypes or profiles. Let the service use common-sense to do the generation for you. All major database vendors supported.