By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
457,714 Members | 1,318 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 457,714 IT Pros & Developers. It's quick & easy.

Auto Documenter

P: n/a
I was wondering if sql server 2000 has an auto documenter utility that
can dump information about a database into a word, excel, or text
file. I would not need anything to complicated just table, fields,
types, sizes, and maybe indexes.

Currently I am just exporting my tables into access, and then using
the auto documenter in access to get at this information. This works
but the field types do not match exactly, and when the tables get
large this is no longer a valid solution.

Thanks,

Charlie

Jul 20 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
hi Charlie,
"charlie" <ch*************@hotmail.com> ha scritto nel messaggio
news:o2********************************@4ax.com...
I was wondering if sql server 2000 has an auto documenter utility that
can dump information about a database into a word, excel, or text
file. I would not need anything to complicated just table, fields,
types, sizes, and maybe indexes.

Currently I am just exporting my tables into access, and then using
the auto documenter in access to get at this information. This works
but the field types do not match exactly, and when the tables get
large this is no longer a valid solution.


if you like, you can have a look at a free prj of mine at my home page, wich
provides an HTML export documentation feature..
hth
Andrea Montanari
an********@virgilio.it
http://www.asql.biz/DbaMgr.shtm
DbaMgr2k ver 0.4.0 - DbaMgr ver 0.50.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply an HTML export documentation feature..
Jul 20 '05 #2

P: n/a
Hi

There are some tools available, and previous posts have advertised them.

I personally would reverse engineer into the Enterprise Architect Version of
Visio and run the reports to an rtf file.

John

"charlie" <ch*************@hotmail.com> wrote in message
news:o2********************************@4ax.com...
I was wondering if sql server 2000 has an auto documenter utility that
can dump information about a database into a word, excel, or text
file. I would not need anything to complicated just table, fields,
types, sizes, and maybe indexes.

Currently I am just exporting my tables into access, and then using
the auto documenter in access to get at this information. This works
but the field types do not match exactly, and when the tables get
large this is no longer a valid solution.

Thanks,

Charlie

Jul 20 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.