Document! X & HelpStudio Bundle 2022.1
Documentation Types / Getting Started with Database Documentation
In This Topic
    Getting Started with Database Documentation
    In This Topic

    Document! X is a combination of an automated database documentation tool and a full documentation authoring environment which can be used to create accurate, professional quality database documentation for SQL Server, Access, or other OLEDB databases.

    Document! X is not just an automated database documentation build tool - it also includes a fully-featured documentation authoring environment allowing you to author supplementary content (descriptions of database elements, hyperlinks to related pages or web sites etc.) where required.

    Leverage your Existing Content

    Document! X uses the content of Access and SQL Server description properties in the generated database documentation where available. This means that you can continue to use SQL Server Management Tools or the Access Table Designer to define descriptions for your tables, columns, triggers, indexes etc. and Document! X uses them automatically.

    In addition, you can include specifically-formatted comments in your T-SQL code and views. Document! X extracts the comments and uses them in the generated SQL documentation.

    Example Source Comments (single line comment style)

    -- ##SUMMARY This procedure is an example of using various Document! X comment types
    -- ##REMARKS Single line and multi-line comments can be used and comments can include <strong>HTML Markup</strong>
    -- ##RETURNS Documents the return type of a procedure
    CREATE PROCEDURE ExampleTaggedComments
      @Param1 int = NULL, --##PARAM @Param1 The first parameter
      @Param2 varchar, --##PARAM @Param2 The second parameter
      @Param3 tinyint, --##PARAM @Param3 The third parameter
    AS
    ...

    Example Source Comments (multi line comment style)

    /* ##SUMMARY This procedure is an example of using
                     various Document! X comment types
       ##REMARKS Single line and
                     multi-line comments can be used with
                     tagged comments in a single or separate
                     multi line comment blocks and comments
                     can include <strong>HTML Markup</strong>
       ##RETURNS Documents the return type of a procedure
    */
    /*
       ##PARAM @Param1 The first parameter
       ##PARAM @Param2 The second parameter
       ##PARAM @Param3 The third parameter
    */
    CREATE PROCEDURE ExampleTaggedComments
      @Param1 int = NULL,
      @Param2 varchar, 
      @Param3 tinyint,
    AS
    ...

    Database Documentation Fundamentals

    Create a New Database Reference Documentation Project

    Create an Empty Project

    Creating an empty project creates a project without any content. You can customize its settings according to your needs.

    To create an empty project:

    1. Click the Application Button at the upper-left of the Ribbon Menu.
    2. Click New and then select Empty Project.

       

    3. Enter a project name in the Project Name field. 
      The project is created at the default directory which is configurable in the Options Editor (Paths page). However, you can optionally choose a specific directory to save your project by browsing the Project Directory field.
             
    4. Click OK.

    The new empty documentation project is created and opened for edit. You can now add the Databases that you would like to document:

    1. Click the Add Database button on the Project tab.
    2. Use the displayed dialog to define the properties of the Database that you would like to document in this project.
    3. Click Ok.

    The selected Database is added to the Project Explorer under the Databases node. You can expand down through the database node to select / deselect individual database elements in order to include / exclude them from the generated output. Repeat the process above if you would like to include additional Databases in the project.

    A Content File is created and added to the project under the Content Files node for each Database you add to the project. You can use this Content File to author additional content in the pages that Document! X automatically generates.

    Existing content from your database is automatically used in the generated output where available. Content from the database is displayed in the Content File Editor so you can see at a glance what content is already available from source comments and what requires further authoring.
           

    Author Content in the Database

    In Access and SQL Server you can use the various database item properties editors in Access or SQL Management Studio to author descriptions directly. In SQL Server you can also use the extended properties stored procedures to do this programmatically (see http://msdn.microsoft.com/en-us/library/ms190243.aspx).

     See Author Content using the Content File Editor  for authoring content outside of the source code.

    Custom SQL Server Extended Properties

    For SQL Server, you can define new Content Item Types in Document! X in order to store custom content types in extended properties - e.g. Author or Creation Date. The XML Tag Name of your custom Content Item Type is used to find the right extended property in SQL Server.

    Tagged Source Comments

    For database elements with source code (Views, Stored Procedures, Functions) you can also embed specifically tagged source comments that Document! X then uses in the generated output.

    Example

    SQL" data-itemid="SQL" data-title= "SQL">
    -- ##SUMMARY This procedure is an example of using various Document! X comment types
    -- ##REMARKS Single line and multi-line comments can be used
    -- ##RETURNS Documents the return type of a procedure
    CREATE PROCEDURE ExampleTaggedComments
      @Param1 int = NULL, --##PARAM @Param1 The first parameter
      @Param2 varchar, --##PARAM @Param2 The second parameter
      @Param3 tinyint, --##PARAM @Param3 The third parameter
    AS
    ...

    XSL Transformation

    Document! X and HelpStudio Bundle supports transforming source comments and extended properties to HTML using XSLT. Using XSLT to transform your database content allows more complicated and structured source content, the output of which can be customized without making changes to the original content itself.

    See  Transforming Content Item Type Content for more information.

    Each time you open your documentation project, Document! X reads the current content, so your documentation is always up-to-date with content you have authored in the database.
           

    Author content outside of the source code

    If you would like to supplement the content of the pages automatically generated by Document! X and HelpStudio outside of the source code, you can do so using the Document! X and HelpStudio Content File Editor.

    The Content File Editor allows you to review and author content for any item for which a reference documentation page is generated.

    To open the Content File Editor:

    1. Expand the Content Files node on the Project Explorer.
    2. Locate the Content File for the item you wish to author content for.
    3. Right-click the Content File and select Edit.
    4. The Content File opened for edit. The tree on the left side of the editor shows you a hierarchical view of the item you are documenting.
    5. Drill down and select an item from the tree and the related documentation pages are shown in the right side of the editor.
    6. Select a specific content type from the toolbar/vertical menu to edit a specific type of content, for example, Summary, See Also, and Keywords.
    7. Type directly in the editable portions of the page on the right side of the editor.

    Add Conceptual Topics

    Conceptual information is a key part of reference documentation, providing a high level introduction, tutorials, or other conceptual information. You can easily create conceptual topics in Document! X and HelpStudio Bundle.

    1. Click the New Topic button on the Project tab or use the Ctrl+T shortcut key.
    2. The new Topic is created in the currently-selected Topic Category on the Project Explorer (or under the (Un-categorized) node if no category is selected) and opened for edit.

       

    3. Enter your conceptual content directly in the editable area of the Topic Editor.

    You can find more information on Topic Editing in the Topic Editor topic.

    Change Database Documentation Settings

    The settings that govern Database Documentation generation are defined in the Build Profile editor. In a new project there is a single Build Profile but you can define many build profiles if you want to create multiple outputs with different settings.

    To edit Database documentation settings:

    1. On the Project Explorer, expand the Build Profiles node.
    2. Double-click the required Build Profile to edit the properties.
      Alternatively, you can also right-click the required Build Profile and select Edit to open the Build Profile editor.

    In the Build Profile editor, you can find the Database Settings page under the Reference Documentation section.

    You can change the Template used for Database documentation (which defines the look and feel of generated pages) on the Templates page.

           

    Identify Undocumented Items

     An essential part of delivering a complete documentation set is ensuring that all the items have been documented. Document! X includes the Undocumented Items tool to quickly and easily identify undocumented items.

    1. On the Tools tab, select the Undocumented Items option.
    2. Select the profile in the Project Profile field for which you want to find the undocumented items.
      If your project contains only one Build Profile then it appears in the Project Profile field by default.
    3. Select Item Types, for example, Class, Method, Schema, and Column, that you want to check for undocumented items.
    4. Select Content Types to indicate the items that must be considered documented (just Summary by default).
    5. Select the Content Sources that should be used when checking for content.
    6. Select Execute. Any undocumented items will be listed in the results grid.

    Build and Deploy Database Reference Documentation

    Click the  Build button on the Project tab to build your Database reference documentation.

    In a new project, the default Build Profile is configured to generate output in compiled CHM Html Help 1.x format.

    Refer to the Deployment topic for more information on how to deploy your documentation to other machines.