Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

prepare details about the database Expand / Collapse
Author
Message
Posted Tuesday, August 18, 2009 2:57 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, February 25, 2014 7:47 AM
Points: 311, Visits: 898
Hi all,

i have to prepare a document about the details of our database. we may call it as data dictionary.
Suggestions, ideas are welcome about what and all can be included to enrich the document.

My idea is to give details about constraints, indexes, relationships between tables etc.

thanks,
regards
viji
Post #772497
Posted Tuesday, August 18, 2009 3:25 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, March 19, 2014 1:27 AM
Points: 2,366, Visits: 1,837
Viji

Typically a data dictionary contains info regarding tables, fkeys, indexes and also information regarding hard coded values in columns if any. Other than this it contains info regarding stored procedures, functions, and also user permissions and any other database features you have used. For ex: if you have used service broker you need to put that in also.


"Keep Trying"
Post #772515
Posted Tuesday, August 18, 2009 3:35 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, February 25, 2014 7:47 AM
Points: 311, Visits: 898
thanks for the quick reply.
i find some tools to do this and get the same into html format.
right now i'm trying the same

thanks,
regards
viji
Post #772523
Posted Tuesday, August 18, 2009 3:37 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 9:43 AM
Points: 1,098, Visits: 6,419
BI Documenter is also a pretty good tool. Creates a compiled HTML file.

We use this to distribute schema documentation to clients.
Post #772524
Posted Tuesday, August 18, 2009 4:11 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, February 25, 2014 7:47 AM
Points: 311, Visits: 898
thanks
i'll look into Bi documentor also..

--viji
Post #772539
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse