How to Document my Database?

Hi,
I want to document a huge database, but I don't know where to start, what to
document.
Are there any samples or tools for this job? What should be documented?
Thanks in advance,
Leila
How do I document / compare my SQL Server database(s)?
http://databases.aspfaq.com/general/how-do-i-document/compare-my-sql-server-database-s.html
AMB
"Leila" wrote:

> Hi,
> I want to document a huge database, but I don't know where to start, what to
> document.
> Are there any samples or tools for this job? What should be documented?
> Thanks in advance,
> Leila
>
>
|||Hi,
You can use AlfaAlfa's SQL Server Comparison Tool (SCT)
http://www.sql-server-tool.com
to document your database.
SCT can very quickly generate simple report with the list of all
tables (listing their names and number of records contanined in each
table), list of all views, stored procedures, functions, triggers and
relationships.
HTH
Darek
|||SQLDoc from Red Gate.
"Leila" <Leilas@.hotpop.com> wrote in message
news:uoxUFyeVHHA.5108@.TK2MSFTNGP06.phx.gbl...
> Hi,
> I want to document a huge database, but I don't know where to start, what
> to document.
> Are there any samples or tools for this job? What should be documented?
> Thanks in advance,
> Leila
>

How to Document my Database?

Hi,
I want to document a huge database, but I don't know where to start, what to
document.
Are there any samples or tools for this job? What should be documented?
Thanks in advance,
LeilaHow do I document / compare my SQL Server database(s)?
http://databases.aspfaq.com/general...r />
se-s.html
AMB
"Leila" wrote:

> Hi,
> I want to document a huge database, but I don't know where to start, what
to
> document.
> Are there any samples or tools for this job? What should be documented?
> Thanks in advance,
> Leila
>
>|||Hi,
You can use AlfaAlfa's SQL Server Comparison Tool (SCT)
http://www.sql-server-tool.com
to document your database.
SCT can very quickly generate simple report with the list of all
tables (listing their names and number of records contanined in each
table), list of all views, stored procedures, functions, triggers and
relationships.
HTH
Darek|||SQLDoc from Red Gate.
"Leila" <Leilas@.hotpop.com> wrote in message
news:uoxUFyeVHHA.5108@.TK2MSFTNGP06.phx.gbl...
> Hi,
> I want to document a huge database, but I don't know where to start, what
> to document.
> Are there any samples or tools for this job? What should be documented?
> Thanks in advance,
> Leila
>

How to Document my Database?

Hi,
I want to document a huge database, but I don't know where to start, what to
document.
Are there any samples or tools for this job? What should be documented?
Thanks in advance,
LeilaHow do I document / compare my SQL Server database(s)?
http://databases.aspfaq.com/general/how-do-i-document/compare-my-sql-server-database-s.html
AMB
"Leila" wrote:
> Hi,
> I want to document a huge database, but I don't know where to start, what to
> document.
> Are there any samples or tools for this job? What should be documented?
> Thanks in advance,
> Leila
>
>|||Hi,
You can use AlfaAlfa's SQL Server Comparison Tool (SCT)
http://www.sql-server-tool.com
to document your database.
SCT can very quickly generate simple report with the list of all
tables (listing their names and number of records contanined in each
table), list of all views, stored procedures, functions, triggers and
relationships.
HTH
Darek|||SQLDoc from Red Gate.
"Leila" <Leilas@.hotpop.com> wrote in message
news:uoxUFyeVHHA.5108@.TK2MSFTNGP06.phx.gbl...
> Hi,
> I want to document a huge database, but I don't know where to start, what
> to document.
> Are there any samples or tools for this job? What should be documented?
> Thanks in advance,
> Leila
>