Post reply

prepare details about the database

  • August 18, 2009 at 2:57 am

    #135574

    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

  • August 18, 2009 at 3:25 am

    #1040695

    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"

  • August 18, 2009 at 3:35 am

    #1040702

    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

  • August 18, 2009 at 3:37 am

    #1040703

    BI Documenter is also a pretty good tool. Creates a compiled HTML file.

    We use this to distribute schema documentation to clients.

  • August 18, 2009 at 4:11 am

    #1040716

    thanks

    i'll look into Bi documentor also..

    --viji

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply