|
Database Document Generator in .CHM format
|
Email
|
| Submitted on: |
9/21/2004 2:55:57 AM |
| By: |
Pradeep Mishra Induslogic
|
| Level: |
Advanced |
| User Rating: |
By 37 Users |
| Compatibility: |
VB 6.0 |
| Views: |
23479 |
|
|
|
|
|
Hi friends, once I had to document a SQL Server 2000 database, the database had more than 1000 objects; I tried to document the database manually but it was a tedious job so I explored a tool which can document SQL 2000 databases, I found one known as SQL-Scribe, It was 400$ product which I could not afford so I made my own. It took me 3 days to build the tool; I have used SQL DMO to retrieve information about the database. There is a CSS file which users can change to change look and feel of the compiled
html file.
Should Have Following Installed
SQL Server 2000 SP1 Client Or Server, Compiled HTML help executable usually C:\Program Files\HTML Help Workshop\hhc.exe
Key-Words: Database, Document, Documenter, CHM, Compiled HTML, HTML Help
|
 |
| |
|
 Download code
Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. Afterdownloading it, you will need a program like Winzip to decompress it.Virus note:All files are scanned once-a-day by Planet Source Code for viruses, but new viruses come
out every day, so no prevention program can catch 100% of them. For your own safety, please:
- Re-scan downloaded files using your personal virus checker before using it.
- NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.
- Scan the source code with Minnow's Project Scanner
If you don't have a virus scanner, you can get one at many places on the net
including:McAfee.com
|
Terms of Agreement:
By using this code, you agree to the following terms...
- You may use
this code in your own programs (and may compile it into a program and distribute it in compiled format for languages that allow it) freely and with no charge.
- You MAY NOT redistribute this code (for example to a web site) without written permission from the original author. Failure to do so is a violation of copyright laws.
- You may link to this code from another website, but ONLY if it is not wrapped in a frame.
- You will abide by any additional copyright restrictions which the author may have placed in the code or code's description.
|
Report Bad Submission
|
Your Vote
|
| |
Other User Comments
|
 9/21/2004 5:17:24 AM:
its excellent good job
(If this comment was disrespectful, please report it.)
|
9/21/2004 10:49:56 AM:
Great tool!
Found some bugs:
1) If the owner of the object is something like --> PC0001\Username then the program crashes. The program is trying to create a file with this string and it doesn't like it. I suggest replacing the \ with -. Also, don't forget to correct the TOC if doing so.
2) In the views, the HTML is not correctly generated. In CView.Source you should replace the
(If this comment was disrespectful, please report it.)
|
9/21/2004 10:53:20 AM:
Grrr...
2) In the views, the HTML is not correctly generated. In CView.Source you should replace the %SOURCE% tag with the source of the view instead of concat.
(If this comment was disrespectful, please report it.)
|
9/21/2004 10:54:20 AM:
3) Could you implement a TOC for the views and sprocs like for the tables?
(If this comment was disrespectful, please report it.)
|
9/21/2004 10:55:29 AM:
4) The option of keeping the files does not work.
5) The option of keeping the DOS window is inverted.
(If this comment was disrespectful, please report it.)
|
9/21/2004 12:22:43 PM: Pradeep Mishra Induslogic
Thank you all for such a good response.
I have fixed the bug where '\' in owner name caused program to malfunction.
(If this comment was disrespectful, please report it.)
|
9/21/2004 3:17:08 PM: Anders Nissen
I don't have "SWLDMO Object Library" ("sqldmo.dll"). It's probably because I haven't got "Microsoft SQL Server 2000" installed. It's too bad, because your project looks great.
(If this comment was disrespectful, please report it.)
|
9/21/2004 3:55:04 PM: Knoton
I think it is enough if you install the client tools to get sqldmo.
(If this comment was disrespectful, please report it.)
|
9/21/2004 9:08:59 PM:
excellent job
(If this comment was disrespectful, please report it.)
|
9/22/2004 1:47:52 AM: Pradeep Mishra Induslogic
Fixed
1. The option of keeping the files does not work.
2) The option of keeping the DOS window is inverted.
(If this comment was disrespectful, please report it.)
|
9/22/2004 1:55:51 AM: Pradeep Mishra Induslogic
Please Vote if you like the tool.
I would make it a complete project Adding support for Rules, User Defined Data Types,Users, Roles, Formatted Script Generation for all objects, Graphs And Support for other databases such as Oracle, Access, MySQL, More professional look like MSDN.
(If this comment was disrespectful, please report it.)
|
9/22/2004 7:15:07 AM: tibisan
man, u rock
(If this comment was disrespectful, please report it.)
|
9/22/2004 10:18:30 AM: Ademir Mazer Jr
Man, I haven't tried it yet, but voted 5 globes already, hope you win the code code of the month.
And yes, you should provide it as a multi-database product, then it will be an amazing tool for us developers.
(If this comment was disrespectful, please report it.)
|
9/22/2004 11:21:46 AM:
Incredible!
Worth much more than 5 globes!!!!
You should win code of the month!
(If this comment was disrespectful, please report it.)
|
9/22/2004 11:42:18 AM:
At lines 55, 127, 178, 224, 277 in CDocumentGenerator.cls you should correct the filename.
(If this comment was disrespectful, please report it.)
|
9/22/2004 11:43:23 AM:
In CView.cls, change
strHTML = strHTML & strSource
Source = strHTML
To
Source = Replace(strHTML, "<%SOURCE%>", strSource) & "
"
(If this comment was disrespectful, please report it.)
|
9/22/2004 12:26:59 PM: Pradeep Mishra Induslogic
Fixed the bug with Views, thx for catching the bug.
(If this comment was disrespectful, please report it.)
|
9/22/2004 3:08:19 PM:
great job 5 globes
(If this comment was disrespectful, please report it.)
|
9/23/2004 1:20:21 AM: Mr.Sekhar
Hey Pradeep, Great work from you. I suggest the following to avoid possible-usage hurdles.
1) Either take the end-user to the options screen as soon as the Next button at frmMain is clicked
or
handle the error at line
pbOverAll.Max = chkDatabase + chkTables + chkViews + chkFunctions + chkStoredProcedures + chkTriggers + 1
in frmStartProcessing.
2) You could as well add an option of HTML-Export(in a single file as of now and can add frame based options, javascript-enabled-navigation in further versions etc.) for buddies with no chm or for simple exports.
3) Linking the tables with the help of relations and descriptional mouse-over tips for those links respectively.
Thanks,
Sekhar
(If this comment was disrespectful, please report it.)
|
9/23/2004 8:52:17 AM: James Kerr
Very, very nicely done - thanks for sharing it. 5 globes from me too!
(If this comment was disrespectful, please report it.)
|
9/23/2004 10:46:54 PM:
Excellent stuff! It was very useful to me. I would love to see other databases supported such as MySQL.
I would also like to see if output into a frames html structure as an option for those who do not have help compiler on their machine.
(If this comment was disrespectful, please report it.)
|
9/24/2004 1:29:58 AM:
Great Work done Pradeep.I would love to see if other database supported such as Oracle.
(If this comment was disrespectful, please report it.)
|
9/24/2004 7:26:15 AM: skansoft
Great!! 5 Globes from me.
(If this comment was disrespectful, please report it.)
|
9/24/2004 12:41:44 PM: MrBobo
Good job - well layed out - easy to follow code - 5 little green balls from me
(If this comment was disrespectful, please report it.)
|
9/26/2004 4:04:59 AM: Henry K
nice job, five great balls from me.
(If this comment was disrespectful, please report it.)
|
Add Your Feedback
Your feedback will be posted below and an email sent to
the author. Please remember that the author was kind enough to
share this with you, so any criticisms must be stated politely, or they
will be deleted. (For feedback not related to this particular code, please
click here instead.)
To post feedback, first please login.
|
