The 2nd most useful Java-Oracle Tool for 2006
by Paul Browne
How often have you taken over a project without any documenation? Even worse , there is a database involved, and everybody just 'knows' (or pretends to know) where things are. What if all the orginal developers are gone and nobody is left to explain things? I can find my way around most legacy Java code , but databases leave me cold.
Still not convinced - take a look on the Schema Spy website. The level of information that this tool gives you takes you from knowing nothing about the database to knowing almost everything.
Interested in trying it out? Follow these simple steps
- Download it from http://schemaspy.sourceforge.net/
- Change the configuration to point to your database
- Install the Graphviz component (available here)
- Run the tool and await your fully documented database.
Just to shame the commercial competition , as well as Oracle , Schema Spy supports DB2, hsqldb , Microsoft SQL Server, MySQL, PostgreSQL and Sybase. It's written by John Currier and is well worth a donation.
In case you're wondering, the most useful Java-Oracle tool for 2006 is Oracle's project raptor. Schema spy runs it a very close second. Considering that it's a Billion dollar company Vs one man , I'd chalk that up as a victory for the little guy!
More Technical Blogs in Technology in Plain English
|this tool totally rocks. I just downloaded it and it has found database anomalies. The graph is awesome. I had problems with "-t ora" and had to use "-t orathin" as I was using the ojdbc14.jar. thanks for an awesome post.|
I've shown the results to clients as well , as they've been completely blown away by how good it is.
|and the 2nd most horrible java source code I've seen this year|
My opinion is that it's really a good piece of code, and it's OS so I can do anything I want with it. Bye
|I want make application by oracl and conncet with internetwebsit help me if you have explane or some programe or websit(iam beginner in oracl) thankyou>|