E-R diagram generation

[Anu Padki]

Hello,

Does any one know a open source tool that will reverse-engineer H2Database schema and generate a E-R. DBDesigner does not list H2 .
Thanks a lot.
- Anu

[Thomas Mueller]

Hi,

There is a number of database tools at
http://www.h2database.com/html/links.html - but I'm not sure if any of
those can do what you are looking for.

Regards,
Thomas

[Thomas Kellerer]

Try out Power*Architect.

http://www.sqlpower.ca/page/architect

You need to add the H2 driver manually as it is not bundled with the
application, but it's quite easy.
The "Generic-SQL 92" generates SQL Scripts that should work with H2