Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

What is available in the realms of database modelling software that is free. I am developing an SQLExpress database.

CA ERWin - community version although is free, I can't see an option to allow me to create a database, either using a direct connect or via creating an SQL script file.

Embarcardo ER/Studio - 14 day trial Can I reinstall this every 14 days?

What others are there, that will allow me to model my database and create a "create" script or "update" sql script?

Thanks in advance.

share|improve this question

closed as off-topic by Paul White, Max Vernon, Aaron Bertrand Jan 26 at 14:52

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Shopping list question - questions about which tool, library, product or resource you should use are off-topic here because they quickly become obsolete and often are just about the preferences of the answerer. If you have an issue with or a question about a specific tool, please revise your question to conform to that scope." – Paul White, Max Vernon, Aaron Bertrand
If this question can be reworded to fit the rules in the help center, please edit the question.

5  
Do you have access to a non-express version of Visual Studio? –  gbn Aug 6 '12 at 8:36

2 Answers 2

There are several choices:

  • SQL Power Architect (download without registration from Google Code). This is open source, but it seems there is no further development.
  • Oracle's Data Modeler (but it only supports Oracle, SQL Server and DB2. PostgreSQL for example is not supported)
  • A free version of TOAD Data Modeler - although that has some serious limitations on the size of the model
  • Open ModelSphere a general purpose modeler (including UML) but can also be used for ER modelling
share|improve this answer

Though it is intended for IBM products, IBM Data Studio does support non-IBM Databases. From what I can see it allows some design/modelling of databases. It is free. Maybe take a peek at it. Here are the features and benefits.

share|improve this answer
    
Thanks, that is more than helpful. I might give DB2 express a go too. –  Craig Aug 7 '12 at 15:55

Not the answer you're looking for? Browse other questions tagged or ask your own question.