database documentor tool? - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

Database Design and Application Architecture

database documentor tool?

Author

Topic

PaTRiCKDRD
Yak Posting Veteran

55 Posts

Posted - 2007-09-21 : 06:44:49

Hi everyone!

Does anyone have any database documentor tool to upload?

I need to create a report of tables (with columns) for my database (sql server).

Thanks in advance!

Kristen
Test

22859 Posts

Posted - 2007-09-21 : 07:08:07

http://www.elsasoft.org/

Created by jezemine, see: http://www.sqlteam.com/forums/pop_profile.asp?mode=display&id=24731

Kristen

PaTRiCKDRD
Yak Posting Veteran

55 Posts

Posted - 2007-09-21 : 08:13:15

not what I was looking for...

1) I'm looking for a tool to document all the tables (along with their columns - datatypes etc) to a word file (word tables)
2) I'm looking for a free tool, I don't think that I need to pay for this,
I have one such tool myself, writen by a colleaque, but can't make it work at the moment

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-09-21 : 08:17:21

quote:
Originally posted by PaTRiCKDRD

not what I was looking for...

1) I'm looking for a tool to document all the tables (along with their columns - datatypes etc) to a word file (word tables)
2) I'm looking for a free tool, I don't think that I need to pay for this,
I have one such tool myself, writen by a colleaque, but can't make it work at the moment

I have just written one also.

select * from INFORMATION_SCHEMA.COLUMNS

[EDIT] : Upgrade tool to version 2. Resolve bug due to insufficient testing

KH
[spoiler]Time is always against us[/spoiler]

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-09-21 : 08:26:12

<<
select * from INFORMATON_SCHEMA.COLUMNS
>>
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'INFORMATON_SCHEMA.COLUMNS'.

That should be

select * from INFORMATION_SCHEMA.COLUMNS

Madhivanan

Failing to plan is Planning to fail

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-09-21 : 08:36:04

Thank you Madhi, updated my tool accordingly.

KH
[spoiler]Time is always against us[/spoiler]

blindman
Master Smack Fu Yak Hacker

2365 Posts

Posted - 2007-09-21 : 10:26:06

quote:
Originally posted by PaTRiCKDRD

2) I'm looking for a free tool, I don't think that I need to pay for this

I tried a similar argument with a lady in Vegas, but with no luck.

e4 d5 xd5 Nf6

PaTRiCKDRD
Yak Posting Veteran

55 Posts

Posted - 2007-09-21 : 18:27:09

so, please can somebody suggest a (free) tool to document my db tables to word tables?

Kristen
Test

22859 Posts

Posted - 2007-09-22 : 02:18:48

I don't know of one.

All the information you need is in INFORMATION_SCHEMA.COLUMNS, and other INFORMATION_SCHEMA views, as others have said, so you can just query that for the data you need

Kristen

blindman
Master Smack Fu Yak Hacker

2365 Posts

Posted - 2007-09-24 : 11:13:52

PaTRiCKDRD,

Why not write a nice GUI interface for the Information Schema tables? Maybe add some reporting functionality, etc. A web interface would be cool too. Then be sure to post on the internet it for everybody to download, because nobody should need to pay you for it.

e4 d5 xd5 Nf6

Zoroaster
Aged Yak Warrior

702 Posts

Posted - 2007-09-24 : 13:20:45

How about this tool:

http://www.codeproject.com/cs/database/sqldoc.asp

Future guru in the making.

PaTRiCKDRD
Yak Posting Veteran

55 Posts

Posted - 2007-10-01 : 20:13:49

thanks very much for your link my friend,
that link led me use mygeneration's PDFDatabaseReport,
which I edited and customized according to my needs
and looks great!

Zoroaster
Aged Yak Warrior

702 Posts

Posted - 2007-10-01 : 21:23:05

Not a problem, glad you got what you needed!

Future guru in the making.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources