Generates CHM, HTML, HXS, and Doc(x) documentation for the entire database or for only a single piece of information. Requires Visual Studio SDK, Microsoft Help Compiler, and ActiveX Data Access Objects Library. Connects to the database engine to pull various information (table, structure, data, objects, and more).
ApexSQL Doc creates database documentation in a variety of formats. Document SQL Servers, databases, objects and SSIS packages in a single document. Render even the most complicated database into user friendly documentation with inline object descriptions, custom properties and graphical relationships. Generate database and SSIS documentation in CHM, HTML, PDF, Word Automate and schedule the documenting process Include relationship diagrams in your database documentation Leverage extended properties and edit them directly
Features :
- Support for Windows SQL Azure Databases
- Improved performance
- Support for SQL Server Integration Services packages
- Accurate dependencies
- Multiple documentation formats Save your documentation in CHM, HTML, PDF, DOC or DOCX format. Create mutable or immutable documentation, including PDFs (from Word) - Granular control
- Customizable processing
- Transparent decryption
- Self-documenting SQL objects
- Custom styles
- Repeatable sessions
- Support for all SQL Server versions
v2014.0 [Jul 29, 2014]
Enhancements:
- The application now integrates as an add-in in SQL Server Management Studio 2014/2012.
- An option to add images in header/footer of the output document is added for CHM and HTML output formats.
- An option to choose a page orientation (portrait or landscape) of the output document is added for DOC, DOCX, and PDF output formats.
- An option to select the page format (A3 or A4) of the output document is added for DOC, DOCX, and PDF output formats.
- Options to edit header/footer text, font, formatting, and color are added.
- An option to select the dependency level for object dependencies is added.
- An option to include/exclude extended properties on the object type level is added.
- Graphical dependencies documenting is now up to 24% faster, depending on the output format.
Fixes:
- The "/f" switch does not work.
- The project file is processed incorrectly, when opened with a double click.
- The application fails to create graphical dependencies for the first database, when two or more databases are included in the processing.
- The application cannot document Windows Azure SQL Databases in CLI.
- The application hangs when the switches are duplicated.
- The "/?" switch does not work in the CLI.
- The "The given key was not present in the dictionary." error is encountered when canceling the documenting process.
- The application fails to document graphical dependencies for objects with 100 and more parent/children objects.
- The documentation fails if the ".gif" icon is renamed in the application install directory.
- Intermediary files are not deleted, and the dependency viewer process remains active, when canceling the documenting process.
- The "Scale" option in the "Dependencies" tab does not work.
- The documenting process hangs for hours on a specific database function.
- The "Collapsible image" is displayed instead of "+" sign in some parts of the documentation.
- The "System.Argument exception Parameter is not valid" error is encountered when starting another instance of the application, while one instance is still
running.
- Inconsistent list of the available tags in the Custom text tab, and in the application "Default" settings.
- The "/srd:n" switch will not exclude the "Server info" node from the documentation.
- SQL Server login status is not documented when using doc, docx, or pdf as an output format.
- The dropdown menu of grid filtering in the "Extended property editor" window does not offer reselection.
- The "System.IndexOutOfRange exception" is encountered when documenting database information on specific databases.
- Documenting process hangs when documenting specific database.
- Generating documentation failed if the already existing folder is specified using the /od switch in the CLI, when using the HTML output format.
- Documentation dictionary is not sorted in alphabetical order in specific situations.
- The "Destination patch check" message pops up when documentation is created from CLI.
Known issues:
- Extended property editor cannot be used on databases with more than 20,000 objects.
- The application does not integrate as an add-in in SQL Server Management Studio 2008/2005.
Feature-rich relational database known for its high performance and excellent concurrency
Mall Creeps
