database design tool question

Question

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 design tool are you think is good.

Answer 1

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.

Answer 2

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.

Answer 3

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.

Answer 4

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