I have created a Database in DB2 and tables with relationships. I would like to create a ER diagram based on my database design in DB2. MS SQL has a facility to create ER diagrams from DB schema, but DB2 doesn't seem to have one, at least to my knowledge.
Any one know of any open source tools/facility within DB2 itself for this?
Using Application Id Generator vs. Database Id Generator
How can I include my database in the continuous integration process?
How I can make Recycle Bin for Database ِApplication?
Also IBM Data Studio looks promising..
Storing Data in MS Access and Querying it in Excel
Should I generate a complex object in the database or data access layer?
Log to a database using log4j
Best authentication solution for RESTful Database Server
Is it possible to serialize and deserialize a void pointer to & from a blob in a database?
DbVisualizer isn't open source, but there is a free edition of it (which isn't limited regarding visualization)..
I have done it and found it to be quite neat.. Reverse engineer an existing database into a database model.
It is available only in the commercial version.
ER Studio is another (expensive) option.
Try Visio 2000 Enterprise edition if you can get one.
It is available on ebay for about $35.
Microsoft has moved the reverse engineering option in subsequent version of Visio to the expensive enterprise architect bundles.
You can create, explore, detail, and modify database schemas to create fully editable and scriptable diagrams of database relationships and objects.
The link to download is www.aquafold.com.