NANY 2009 Entry Information
|Short Description||With MGTD you can easily generate a document (.html) containing information about all ( selected ) tables and constraints for a selected user, in Oracle.|
|Supported OSes||All that support Java|
I started writing this application few days ago because I will soon need to create a document (at work ), just like the one that this application generates. I am currently working on a project , and need to provide a complet list of all tables and constraints for several users in DB that we created... I, maybe, could use some existing application to do this, but I wanted to make it myself ;-)
Not many people could use , or might need this kind of application, but for those who DO, here it is...
This app is not for release yet, so there is no download link provided at this moment, and no screenshot.
With MGTD ( do not ask what it means ) you can easily generate a document (.html) containing information about all ( selected ) tables and constraints for a selected user, in Oracle.
Every table is described ( what columns it contains , what data type ( ans size of it) , nullable? information and a comment ) and there is also a list of all constraints for that table ( Primary keys, Checks, Foreign keys and Unique keys ).
You can select what you want this app to generate, and you can also filter or exclude tables, change colors for rows containig these data, etc.
No installation is required. Just copy/paste files that I'll provide here soon.
This app is written in java, so you need to have JRE 1.6 installed on your system.
Using the Application
User must first log on to DB, optionally filter tables or exclude some , select a path where to save generated document, optionally select prefered colors and click "Generate".
Just delete pasted files.
As for now, only supported extension when saving generated document is .html. I plan to add .pdf and .doc or .rtf as well...
I'm developing this application when I have that short free time, and developing it with a great hurry. I hope that all the queries that I wrote in it are completelly OK. If not, I'll improve it... As for now, it all seems ok...
I need those testing days that I don't have...
Excuse my english...