How can I reduce the size of my .CHM file

Applies to

ApexSQL Doc , ApexSQL Doc for MySQL

Summary

This article explains how to reduce the size of a CHM document.

ApexSQL Doc

Description

When the database developer needs to document a lot of the databases (e.g., one hundred or one thousand), for this process, it will be needed a lot of time and storage space for documentation.

For demonstrative purposes, the AdventureWorks2016CTP3 database will be used. When this database is documented with all database options, the required space for the CHM document is 46MB.

To reduce the size of documentation in .CHM format, uncheck the following options in the Database options tab under Data sources and objects panel:

In the Database options tab, the database developer can select which Database options want to document

The database options that are checked by default and can increase the size of the CHM documentation are:

  1. Data definition language (DDL) script
  2. Transact-SQL syntax highlighting
  3. Dependency (parents/children) lists/tables
  4. Include data model diagrams

In order to reduce the size of the CHM document, besides unchecking the above-listed check by default options, be sure that the following database options are unchecked as well:

  1. System objects
  2. Documentation of procedure/function result sets
  3. Explicitly parse database for improved dependency accuracy
  4. Graphical dependencies

The database options available for the documentation in ApexSQL Doc

The result of this change is that the generated documentation required space is 1.04MB.

  • Note: Uncheck only database options that are not required to be included in the database documentation.

ApexSQL Doc for MySQL

Description

As for ApexSQL Doc for MySQL in demonstrative purposes, the custom created database will be used. When this database is documented with all database options, the required space for the CHM document is 25MB.

To reduce the size of the documentation for ApexSQL Dco for MySQL, the steps are similar to ApexSQL Doc, click the Database options button from the Database engine tab:

Data sources and objects tab in ApexSQL Doc

The following database options for ApexSQL Doc for MySQL that can be unchecked to reduce the size of the documentation, and they are checked by default, are:

  1. Data definition language (DDL) script
  2. Transact-SQL syntax highlighting
  3. Dependency (parents and children) lists/tables

Available Database options for the documentation in ApexSQL Doc for MySQL

The result of this change is that the generated documentation required space is 0.75MB.

  • Note: Uncheck only database options that are not required to be included in the database documentation.