topbanner_forum
  *

avatar image

Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
  • Thursday March 28, 2024, 10:37 am
  • Proudly celebrating 15+ years online.
  • Donate now to become a lifetime supporting member of the site and get a non-expiring license key for all of our programs.
  • donate

Author Topic: NANY 2009 Release: MGTD  (Read 11461 times)

Blaster

  • Honorary Member
  • Joined in 2006
  • **
  • Posts: 85
    • View Profile
    • Donate to Member
NANY 2009 Release: MGTD
« on: December 26, 2008, 04:18 AM »
NANY 2009 Entry Information

Application Name MGTD
Version 1.0
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
Download
Link
http://www.kdarko.users.cg.yu/downloads/MGTD.zip
System Requirements
  • Java JRE >= 1.6 update 7
Author https://www.donation...x.php?action=profile


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.




Description:

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.



Usage
Installation
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".

Uninstallation
Just delete pasted files.

Planned Features
As for now, only supported extension when saving generated document is .html. I plan to add .pdf and .doc or .rtf as well...

Known Issues
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...   :(

p.s.
Excuse my english...
« Last Edit: January 01, 2009, 10:30 AM by Blaster »

Blaster

  • Honorary Member
  • Joined in 2006
  • **
  • Posts: 85
    • View Profile
    • Donate to Member
Re: NANY 2009 Release: MGTD
« Reply #1 on: December 31, 2008, 07:09 AM »
And... here it is...

You can now download and try MGTD.

Here is the Link.

As I said: not many people would find it usefull, but for those who need something like it, it's more than helpfull, and I hope they'll like it...


I'm so happy I partitipated this year's N.A.N.Y. !

Happy new year!