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
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

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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