Database Standards HELP!

I would like to create a new database and follow some standard. I am hoping that there is some ANSI documentation or Microsoft documentation on a NAMING standard when creating objects in the database.
i.e Table name "tblEmployees"
Column name "txtLastName"

Is there any GOOD documentation on creating a database using a PROVEN, and ACCEPTED standard?

Hi HotChick -

I always rebel and do whatever I want.......but, here is a pretty decent link:http://vyaskn.tripod.com/object_naming.htm

|||The accepted standard is ISO 11179. http://metadata-standards.org/Document-library/Draft-standards/11179-Part5-Naming&Identification/

Database Schema Documentation Tool?

I am looking for a database documentation tool/script that I can run against
a particular database to generate a document of all the tables, columns, and
relationships in the database. I have seen a data dictionary that lists the
table names with links to the table details further down the document, and
clicking on the relationships jumps you to that table in the document. That
particular one was generated out of the programming revision control system
they were using into xml and xsl files. I am looking for something that can
generate the information out of the metadata in SQL Server.
Thanks
I think you may be thinking of Enterprise Architect
http://www.sparxsystems.com.au/
Or ER/Studio
http://www.embarcadero.com/products/erstudio/index.html
"Greg Hess" <keadrix@.hotmail.com> wrote in message
news:uiaR8UcFHHA.1252@.TK2MSFTNGP02.phx.gbl...
>I am looking for a database documentation tool/script that I can run
>against a particular database to generate a document of all the tables,
>columns, and relationships in the database. I have seen a data dictionary
>that lists the table names with links to the table details further down the
>document, and clicking on the relationships jumps you to that table in the
>document. That particular one was generated out of the programming
>revision control system they were using into xml and xsl files. I am
>looking for something that can generate the information out of the metadata
>in SQL Server.
> Thanks
>
|||Look at ApexSQL Doc from www.ApexSQL.com
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Greg Hess" <keadrix@.hotmail.com> wrote in message
news:uiaR8UcFHHA.1252@.TK2MSFTNGP02.phx.gbl...
>I am looking for a database documentation tool/script that I can run
>against a particular database to generate a document of all the tables,
>columns, and relationships in the database. I have seen a data dictionary
>that lists the table names with links to the table details further down the
>document, and clicking on the relationships jumps you to that table in the
>document. That particular one was generated out of the programming
>revision control system they were using into xml and xsl files. I am
>looking for something that can generate the information out of the metadata
>in SQL Server.
> Thanks
>
|||I love ApexSQL . See the details from below URL:-
http://www.sql-server-performance.com/apex_sql_doc_spotlight.asp
http://www.apexsql.com/sql_tools_doc.asp
You could try the trial version and use it for a month:-
http://www.apexsql.com/downloads.asp
Thanks
Hari
"Arnie Rowland" <arnie@.1568.com> wrote in message
news:OyNRBReFHHA.4712@.TK2MSFTNGP04.phx.gbl...
> Look at ApexSQL Doc from www.ApexSQL.com
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to
> the top yourself.
> - H. Norman Schwarzkopf
>
> "Greg Hess" <keadrix@.hotmail.com> wrote in message
> news:uiaR8UcFHHA.1252@.TK2MSFTNGP02.phx.gbl...
>
|||Another effective but much less costly option if you only want
documentation is
SqlSpec from ElsaSoft
Their website at www.elsasoft.org has a trial version and also samples
of the output
T
|||Greg Hess wrote:
> I am looking for a database documentation tool/script that I can run against
> a particular database to generate a document of all the tables, columns, and
> relationships in the database. I have seen a data dictionary that lists the
> table names with links to the table details further down the document, and
> clicking on the relationships jumps you to that table in the document. That
> particular one was generated out of the programming revision control system
> they were using into xml and xsl files. I am looking for something that can
> generate the information out of the metadata in SQL Server.
> Thanks
You might want to try SchemaToDoc for SQL Server
(http://www.schematodoc.com). It exports to a Word doc metadata info
such as primary keys, field info (types, size, nullable, defaults),
indexes, check constraints, foreign key constraints, triggers, views,
stored procedures, and extended properties. It also lets you annotate
your tables and fields and include those comments in the Word doc. An
Enterprise edition can create a series of linked HTML files in addition
to the Word output.
|||Thank you for all your suggestions. After evaluating them I have decided to
go with SqlSpec from Elsasoft (http://www.elsasoft.org/). It does exactly
what I need it to do for a good price.

Database Releases

I'm looking for documentation templates to specify releases or promotions of
items from Dev to QA to Prod. Has anyone got any recommendations or
references to some that already exist?
Thanks - Craig.Hi
If you have a bug tracking system and version control this can be done
process that combines labelling fixes and extracting the appropriate version
from the repository. Exactly how depends on what systems you are using. There
may be some white papers on the web sites for these sort of products such as
Serena (formally Merant PVCS).
John
"Craig" wrote:
> I'm looking for documentation templates to specify releases or promotions of
> items from Dev to QA to Prod. Has anyone got any recommendations or
> references to some that already exist?
> Thanks - Craig.|||Thanks for the reply. I was hoping to locate a MS Word template that might
aid in this effort.
- Craig
"John Bell" wrote:
> Hi
> If you have a bug tracking system and version control this can be done
> process that combines labelling fixes and extracting the appropriate version
> from the repository. Exactly how depends on what systems you are using. There
> may be some white papers on the web sites for these sort of products such as
> Serena (formally Merant PVCS).
> John
>
> "Craig" wrote:
> > I'm looking for documentation templates to specify releases or promotions of
> > items from Dev to QA to Prod. Has anyone got any recommendations or
> > references to some that already exist?
> >
> > Thanks - Craig.|||Hi
Sorry I didn't read "template"!
If you are looking for a process then it will depend on the systems and
configurations that you are using, therefore I would not really expect it to
fit a generic template.
I would assume that you already have some form of process that you can then
reverse engineer and then formalise/improve?
John
"Craig" wrote:
> Thanks for the reply. I was hoping to locate a MS Word template that might
> aid in this effort.
> - Craig
>
> "John Bell" wrote:
> > Hi
> >
> > If you have a bug tracking system and version control this can be done
> > process that combines labelling fixes and extracting the appropriate version
> > from the repository. Exactly how depends on what systems you are using. There
> > may be some white papers on the web sites for these sort of products such as
> > Serena (formally Merant PVCS).
> >
> > John
> >
> >
> > "Craig" wrote:
> >
> > > I'm looking for documentation templates to specify releases or promotions of
> > > items from Dev to QA to Prod. Has anyone got any recommendations or
> > > references to some that already exist?
> > >
> > > Thanks - Craig.

Database Releases

I'm looking for documentation templates to specify releases or promotions of
items from Dev to QA to Prod. Has anyone got any recommendations or
references to some that already exist?
Thanks - Craig.
Hi
If you have a bug tracking system and version control this can be done
process that combines labelling fixes and extracting the appropriate version
from the repository. Exactly how depends on what systems you are using. There
may be some white papers on the web sites for these sort of products such as
Serena (formally Merant PVCS).
John
"Craig" wrote:

> I'm looking for documentation templates to specify releases or promotions of
> items from Dev to QA to Prod. Has anyone got any recommendations or
> references to some that already exist?
> Thanks - Craig.
|||Thanks for the reply. I was hoping to locate a MS Word template that might
aid in this effort.
- Craig
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> If you have a bug tracking system and version control this can be done
> process that combines labelling fixes and extracting the appropriate version
> from the repository. Exactly how depends on what systems you are using. There
> may be some white papers on the web sites for these sort of products such as
> Serena (formally Merant PVCS).
> John
>
> "Craig" wrote:
|||Hi
Sorry I didn't read "template"!
If you are looking for a process then it will depend on the systems and
configurations that you are using, therefore I would not really expect it to
fit a generic template.
I would assume that you already have some form of process that you can then
reverse engineer and then formalise/improve?
John
"Craig" wrote:
[vbcol=seagreen]
> Thanks for the reply. I was hoping to locate a MS Word template that might
> aid in this effort.
> - Craig
>
> "John Bell" wrote:

Database Releases

I'm looking for documentation templates to specify releases or promotions of
items from Dev to QA to Prod. Has anyone got any recommendations or
references to some that already exist?
Thanks - Craig.Hi
If you have a bug tracking system and version control this can be done
process that combines labelling fixes and extracting the appropriate version
from the repository. Exactly how depends on what systems you are using. Ther
e
may be some white papers on the web sites for these sort of products such as
Serena (formally Merant PVCS).
John
"Craig" wrote:

> I'm looking for documentation templates to specify releases or promotions
of
> items from Dev to QA to Prod. Has anyone got any recommendations or
> references to some that already exist?
> Thanks - Craig.|||Thanks for the reply. I was hoping to locate a MS Word template that might
aid in this effort.
- Craig
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> If you have a bug tracking system and version control this can be done
> process that combines labelling fixes and extracting the appropriate versi
on
> from the repository. Exactly how depends on what systems you are using. Th
ere
> may be some white papers on the web sites for these sort of products such
as
> Serena (formally Merant PVCS).
> John
>
> "Craig" wrote:
>|||Hi
Sorry I didn't read "template"!
If you are looking for a process then it will depend on the systems and
configurations that you are using, therefore I would not really expect it to
fit a generic template.
I would assume that you already have some form of process that you can then
reverse engineer and then formalise/improve?
John
"Craig" wrote:
[vbcol=seagreen]
> Thanks for the reply. I was hoping to locate a MS Word template that migh
t
> aid in this effort.
> - Craig
>
> "John Bell" wrote:
>