ApexSQL Doc

SQL and BI documentation

Document SQL databases, SSAS cubes, SSIS packages and SSRS reports

?Document SQL Server databases and SSIS packages

?Generate documentation in CHM, HTML, Word, and PDF

?Automate and schedule the documenting process

?Display graphical relationship diagrams

?Document SSAS Multidimensional and Tabular models

?Document SSIS Control flow and Data flow diagrams

?Fully customize the documentation output

?Include Data model diagrams

?Document SSRS reports from File System

?Document SSRS reports in Native & SharePoint mode

Features

Multiple documentation formats

Generate documentation in CHM, HTML, DOC, DOCX, or PDF format

Graphical dependencies

Include visualizations of object interdependencies in the generated document.  

Data model diagrams

Graphically display database tables and their relationships using standard Entity-relationship notation.

SSAS database documentation

Document detailed SSAS Multidimensional and Tabular databases.

SSIS package documentation

Detail both attached and detached SQL Server Integration Services packages.

SSIS package diagrams

Document SQL Server Integration Services package Control flow and Data flow diagrams

SSRS report documentation

Document SQL Server Reporting Services items from file system, Native web and SharePoint service.

Unattended execution

Easily schedule generate documentation through the CLI unattended.

Self-documenting SQL objects

Include custom descriptions derived from extended properties that you can edit from within the tool itself.

Customizable processing

Document or ignore specific SQL database or object attributes.

Custom styles

Layout documentation using the popular styles e.g. Metro or quickly create your own.

Personalized documentation

Fully customize the documentation with different styles, custom text, and graphics.

SQL syntax highlighting

Display fully colorized SQL

Powerful filter

Selectively limit which objects will be documented

Transparent decryption

Seamlessly document encrypted SQL objects

SQL Server Management Studio add-in integration

Create documentation directly from SQL Server Management Studio

Save project as batch file

Create executable batch files with existing project options.

System requirements

Hardware requirements Dual Core 2.0 GHz CPU

 4 GB memory

 85 MB disk space 

SQL Server Microsoft SQL Server 2016, 2014, 2012, 2008, and 2005

 Azure SQL Database, SQL Server on Amazon RDS 

Add-in integration SQL Server Management Studio 2016, 2014, or 2012

OS Windows Vista/Server 2008 and above

Required  Microsoft .NET Framework 4.5

 Microsoft Help Compiler

Active Scripting enabled for current zone 

Note Native support for the x64 architecture

 To document SQL Server Integration Services packages, corresponding version of Integration Services must be installed. Integration Services is a component that can be installed using the Microsoft SQL Server 2016, 2014, 2012, 2008, and 2005 installer

 To document SQL Server Analysis Services databases, corresponding version of Analysis Services must be installed. Analysis Services is a component that can be installed using the Microsoft SQL Server 2016, 2014, 2012, 2008, and 2005 installer

Testimonials

You'll be happy to know that I purchased a copy of ApexSQL Doc, and I'm very pleased with it. There is a company called [name deleted] that makes a similar product but I'm afraid that their product is inferior to yours

Jeff Hagen

Director of Internet Development

TreeHouse Interactive

 

 

Compare

SQL Server editions

      Express ? ? ? 

      Standard  ? ? ?

      Enterprise  ? ? ?

Cloud

      Azure SQL Database ? ? ? ?

      SQL Server on Amazon RDS ? ? ? ?

Inputs

      Live database ? ? ? ?

      SSAS cube   ? 

      SSIS package   ?  

      SSRS report   ? 

Outputs

      CHM ? ? ? ?

      HTML  ? ? ?

      PDF  ? ? ?

      Word  ? ? ?

Integration

      SQL Server Management Studio (SSMS) ? ? ? ?

Features

      Extended property editor  ? ? ?

      XML comments (custom tags) ? ? ? ?

      Analysis services documentation   ? 

      Custom descriptions via extended properties    ? 

      Data model diagrams   ? 

      Documentation styles   ? 

      Graphical dependencies   ? 

      Integration services documentation   ? 

      Reporting services documentation   ? 

Other

      Command line interface   ? ?

      Projects