database documentation tool

Hi All,
Does anyone know a good database Documentation tool, or a plug in for eclipse that may automatically document my database schema, solutions, methods etc.
Thanks,

Hi Vaj,

Did you find anything in the mean time? I was looking for this too…

Depends on exactly what you are looking for. Below are some tips.

Database Schema:

  1. Servoy stores everything in the repository, including description, title, etc in the column properties area. So you could issue some sql queries to the repository to get that metadata (assuming you’ve been documenting it there)
  2. If you just want an ERD, I suggest Power Architect: http://www.sqlpower.ca/page/architect

Methods Documentation:
This is done VIA JSDoc. See http://code.google.com/p/jsdoc-toolkit/ … gReference for tag info, and http://www.servoy-stuff.net/jsdoc.php for plugin

In case of Database documentation I am using ER-Master, it is a Ecipse plugin. I have write some code to collect info from a database and put in to an ER-diagram. I will open an project on ServoyForge so everyone will benefit and can contribute his own code.

Danny Richardson
Danson B.V.

danny.richadson:
In case of Database documentation I am using ER-Master, it is a Ecipse plugin. I have write some code to collect info from a database and put in to an ER-diagram. I will open an project on ServoyForge so everyone will benefit and can contribute his own code.

Danny Richardson
Danson B.V.

Great stuff Danny!
Thanks for the idea of putting it on ServoyForge, just ping us when you are ready to open the project.

I’d also highly recommend Aqua Data Studio. Not only does is it offer ER modeling but has many, many other superb features as well such as the ability to compare tables, schemas, queries and results, DB admin tools for Oracle, SQL Server, Sybase, DB2 and MySQL, plus the best support I’ve ever run across. Their next version, ADS 9 and ADS Server, will also have an open API and that should be released very shortly. Outstanding versatile tool that like Servoy works with any JDBC compliant SQL database.