SQL Server Database Anaysis

Posted on 2007-08-12
Last Modified: 2010-03-19
Given a sql server database (7/2000/2005) with no documentation what so ever, how could we analyse it and identify its general logic and functionality? For example, we would need to know (1) the purpose of each table and each stored proc; (2) the amount of times each one of them is called and who is calling who? Any handy tool/script (preferably free) currently exists for that purpose? Please advise. Thanks.
Question by:ksfok
    LVL 142

    Accepted Solution

    unfortunately, there only few things that can help:
    1) the data itself. looking at the data most often explains by itself what it is for, at least for most tables
    2) the table an column names
    3) triggers, procedures, functions, foreign key
    4) using the query profiler, while running the application on purpose, reveils which sql are run, and hence show how it works.

    LVL 18

    Assisted Solution

    ... and of course 'who is calling who' can be queried from the system tables/views.

    Author Comment

    Year go, when XBase was popular, there were tools help you generate a list of proc and function flow and the tables for system analysis purposes. Nothing like that exists today for SQLServer databases?
    LVL 18

    Assisted Solution


    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Suggested Solutions

    INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
    In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now