33 Database Documentation tools for SQL Server

This is the list of all database documentation generators for SQL Server.

Share

Dataedo

dataedo.com

Data dictionary with ERDs, Metadata repository/Data Catalog

Supports: SQL Server, Oracle, MySQL, MariaDB, PostgreSQL, DB2, Azure SQL Database, Amazon Aurora, PostgreSQL, Amazon Redshift, Snowflake

Notable features: ER diagrams, metadata repository, schema change tracking, organizing with modules, documenting missing FKs, custom fields, description suggestions, documentation progress tracking, rich text with images

more...

Export: HTML, PDF, MS Excel

Metadata stored in: Documentation repository/file

Allows editing: yes

Type: Commercial

Free edition: yes, Pricing from: $999

Last release: Dec 2018 (7.2)

Last updated: 07 Dec 2018

Redgate SQL Doc

www.red-gate.com/products/sql-development/sql-doc/

Supports: SQL Server

Notable features: Management Studio integration

more...

Export: HTML, PDF, MS Word, CHM

Metadata stored in: SQL Server extended properties

Allows editing: yes

Type: Commercial

Free edition: no, Pricing from: $369

Last updated: 18 Sep 2016

dbForge Documenter for SQL Server

www.devart.com/dbforge/sql/documenter/

Database documentation generator for SQL Server

Supports: SQL Server

Notable features: SSMS Integration

more...

Export: PDF, HTML

Allows editing: no

Type: Commercial

Free edition: no, Pricing from: $149

Last updated: 08 Oct 2016

Database Note Taker

databasenotetaker.com

Supports: SQL Server

Notable features: Notifies about empty descriptions, shows edit history

more...

Metadata stored in: SQL Server extended properties

Allows editing: yes

Type: Free

Free edition: yes

Last release: Nov 2017

Last updated: 07 Dec 2018

ApexSQL Doc

www.apexsql.com/sql_tools_doc.aspx

Tool enablng documenting SQL Server databases and SSIS packages.

Supports: SQL Server

Notable features: Integration with Management Studio (SSMS), Database UML diagrams, Graphical dependencies

Documents also: SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS)

Limitations: Non intuitive and confusing UI

more...

Export: CHM, HTML, PDF, MS Word

Metadata stored in: SQL Server extended properties

Allows editing: yes

Type: Commercial

Free edition: yes, Pricing from: $299

Last release: Dec 2015

Last updated: 08 Oct 2016

dbdesc

dbdesc.com

Built-in extended property editor and documentation exporter.

Supports: SQL Server, Oracle, MySQL, Access, Firebird

more...

Metadata stored in: SQL Server extended properties

Allows editing: yes

Type: Commercial

Pricing from: $99

Last release: Aug 2014 (4.1)

Last updated: 13 Dec 2016

Elasoft SqlSpec

elsasoft.com

Supports: SQL Server, Oracle, MySQL, PostgreSQL, Access, DB2, Teradata, SAP ASE, SAP SQL Anywhere, Informix, VistaDB, SQLite, ENEA Polyhedra, Raima RDM Server

Notable features: Documents also Analysis Services, Reporting Services, Integration Server

Documents also: SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS)

Limitations: Just exports metadata. No ability to edit descriptions.

more...

Export: HTML, CHM

Metadata stored in: Database metadata

Allows editing: yes

Type: Commercial

Free edition: no, Pricing from: $149

Last updated: 21 May 2017

Doc xPress

pragmaticworks.com/Products/Doc-xPress

Supports: SQL Server, Oracle

Notable features: Lineage Analysis and Impact Analysis, include images

Documents also: SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Apache Hive, Excel

more...

Export: MS Word, HTML, CHM, RTF

Allows editing: yes

Type: Commercial

Free edition: no, Pricing from: $395

Last updated: 18 Sep 2016

Spectral Core Documenter

www.spectralcore.com/documenter

Supports: SQL Server

more...

Export: HTML, CHM

Metadata stored in: No metadata editing

Allows editing: no

Type: Commercial

Free edition: no, Pricing from: $149

Last release: Mar 2011 (1.5)

Last updated: 18 Sep 2016

Leadum DBScribe

www.leadum.com/products.php?prod_type=DBScribe

Supports: SQL Server, Oracle, MySQL, PostgreSQL, DB2

more...

Export: CHM, HTML, MS Word

Metadata stored in: SQL Server extended properties

Allows editing: yes

Type: Commercial

Free edition: no, Pricing from: $39

Last release: Oct 2010

Last updated: 18 Sep 2016

SQLDocKit

www.sqldockit.com

SQL Server settings documentation generator.

Supports: SQL Server

Documents also: SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS)

more...

Export: MS Word, MS Excel

Metadata stored in: No metadata editing

Allows editing: no

Type: Commercial

Free edition: no, Pricing from: $299

Last updated: 30 Jun 2017

DTM Schema Reporter

www.sqledit.com/sr/index.html

Supports: SQL Server, Oracle, DB2, MySQL, PostgreSQL, SQLite, SAP ASE, Interbase, Firebird

Notable features: Entity Relationship Diagrams

more...

Export: RTF/MS Word, HTML, CHM, PDF, XML, MS Excel, Plain text

Metadata stored in: Database metadata

Allows editing: yes

Type: Commercial

Free edition: no, Pricing from: $159

Last updated: 16 Jan 2018

SchemaToDoc

www.schematodoc.com

Supports: SQL Server, Oracle

more...

Export: MS Word, HTML

Metadata stored in: SQL Server extended properties, Oracle comments

Allows editing: yes

Type: Commercial

Free edition: no, Pricing from: $40

Last updated: 18 Sep 2016

xSQL Documenter

www.xsql.com/products/database_documenter/

Supports: SQL Server, Oracle, DB2, MySQL, SQLite, SAP ASE, SAP SQL Anywhere, Informix, PostgreSQL, Teradata, Access, VistaDB, ENEA Polyhedra, Raima RDM Server

Notable features: Dependency diagrams, Data model diagrams, Custom extended properties

Documents also: SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS)

more...

Export: HTML, CHM

Metadata stored in: Database metadata

Allows editing: yes

Type: Commercial

Free edition: no, Pricing from: $199

Last release: Jan 2014 (4.8)

Last updated: 18 Sep 2016

TechWriter for Databases

techwriter.me/techwriter-for-databases.aspx

Documentation tool for databases that automatically produces database reference documentation.

Supports: SQL Server, MySQL, Oracle, PostgreSQL, Access, SAS, DB2

Notable features: Ability to organize topics into a hierarchical table of contents

more...

Export: PDF, CHM, MS Word/RTF, HTML, XPS, XML

Allows editing: yes

Type: Commercial

Last updated: 04 Nov 2016

DBMaster

www.dbmaster.io

DBA tool with Data Dictionary functionality.

Supports: SQL Server, MySQL

more...

Export: No

Metadata stored in: Program repository

Allows editing: yes

Type: Commercial

Free edition: yes, Pricing from: $95

Last updated: 18 Sep 2016

SQL Help Builder

www.sqlhelpbuilder.com

Supports: SQL Server

more...

Export: CHM, Help

Metadata stored in: Help file

Allows editing: yes

Type: Commercial

Free edition: no, Pricing from: $295

Last release: Jan 2006 (2.0)

Last updated: 18 Sep 2016

SchemaSpy

schemaspy.sourceforge.net

Free and open source tool that generates interactive entity relationship diagrams to HTML from database schema. Requires Java 5 or higher.

Supports: SQL Server, Oracle, MySQL, PostgreSQL, DB2, SAP ASE, SQLite, Teradata, Derby, JavaDB, Firebird, HyperSQL, Informix, MaxDB

Notable features: Entity Relationship Diagrams

Limitations: No UI (command line)

more...

Export: HTML

Metadata stored in: No metadata editing

Allows editing: no

Type: Free

Free edition: yes

Last release: Aug 2010 (5.0.0)

Last updated: 16 Jan 2018

SQL Documentation Tool

www.winnershtriangle.com/sql-documentation-tool/

Supports: SQL Server

more...

Export: HTML, Help, RTF/MS Word, plain text

Metadata stored in: No metadata editing

Allows editing: no

Type: Commercial

Free edition: no, Pricing from: $50

Last updated: 18 Sep 2016

Data Dictionary Creator

datadictionary.codeplex.com

Simple free and open source tool that enables documentomg SQL Server databases - it enables editing Extended Properties. Crashed on startup.

Supports: SQL Server

more...

Export: Excel, MS Word, HTML

Metadata stored in: SQL Server extended properties

Allows editing: yes

Type: Free

Free edition: yes

Last release: Jul 2010 (1.3.4)

Last updated: 18 Sep 2016

DBDocumenter

dbdocumenter.codeplex.com

Free and open source tool designed to generate SQL Server (2000, 2005, 2008) documentation.

Supports: SQL Server

more...

Export: HTML

Metadata stored in: No metadata editing

Allows editing: no

Type: Free

Free edition: yes

Last release: Sep 2009 (1.0)

Last updated: 18 Sep 2016

SQL Documentor

www.sqldocumentor.com

Supports: SQL Server, Oracle, MySQL, PostgreSQL

more...

Export: PDF, HTML, MS Excel

Metadata stored in: No metadata editing

Allows editing: no

Type: Commercial

Last updated: 18 Sep 2016

XIA Configuration Server

www.centrel-solutions.com/XIAConfiguration/

Network documentation tool. Supports servers and workstations, AD, Exchange, Clusters, IIS, SQL, DNS and more.

Supports: SQL Server

more...

Export: PDF, XML

Metadata stored in: No metadata editing

Allows editing: no

Type: Commercial

Free edition: no, Pricing from: $500

Last updated: 18 Sep 2016

SQL Data Dictionary

www.sqldatadictionary.com

Supports: SQL Server

more...

Export: PDF, HTML

Metadata stored in: SQL Server extended properties

Allows editing: yes

Type: Commercial

Free edition: no, Pricing from: $200

Last release: Nov 2015 (1.5.2)

Last updated: 18 Sep 2016

DB>doc for Microsoft SQL Server

sqldbdoc.codeplex.com

Simple free and open source tool for generating documentation for SQL Server (2008, 2008 R2).

Supports: SQL Server

more...

Export: HTML, WikiPlex, XML

Metadata stored in: No metadata editing

Allows editing: no

Type: Commercial

Free edition: yes

Last release: Jan 2011

Last updated: 18 Sep 2016

turtle SQL

turtle.codeplex.com

Free and open source tool designed to generate the SQL Server (2005, 2008, 2012) documentation.

Supports: SQL Server

more...

Export: Excel, PDF, XML

Type: Free

Free edition: yes

Last release: Aug 2009

Last updated: 27 Sep 2016

SQLDoc

sqldoc.codeplex.com

Free and open source tool designed to generate the SQL Server (2005, 2008) documentation.

Supports: SQL Server

more...

Export: CHM

Metadata stored in: SQL Server extended properties

Allows editing: no

Type: Free

Free edition: yes

Last release: Aug 2011

Last updated: 18 Sep 2016

DBDocumentor

www.pikauba.com/DBDoc/Details.htm

Supports: SQL Server, Firebird, SAP SQL Anywhere

Notable features: Documentation of SQL Server Reporting Services RDL files

more...

Export: CHM, Help, XML

Metadata stored in: SQL Server extended properties

Allows editing: yes

Type: Commercial

Free edition: no, Pricing from: $160

Last updated: 18 Sep 2016

Document my database

documentmydatabase.com

Data dictionary creator in the cloud accessible by the browser.

Supports: SQL Server, MySQL, Access

Notable features: Cloud based. Online sharing

more...

Export: Online HTML, PDF

Metadata stored in: Cloud repository

Allows editing: yes

Type: Commercial

Free edition: no

Last updated: 18 Sep 2016

Semanta Encyclopaedia

www.semantacorp.com/data-dictionary/

Data governance platform with Data Dictionary feature

Supports: SQL Server, Oracle, Teradata

Notable features: Integration with modeling tools and ERP applications. Ability to comment data quality. ER and dependency diagrams. Online portal with collaboration features.

more...

Export: Online HTML

Type: Commercial

Free edition: no

Last updated: 18 Sep 2016

EZ Data Dictionary

iccinc.com/ezdd/

Supports: SQL Server, Oracle, Access

Notable features: Compare two schemas

more...

Metadata stored in: Documentation repository

Allows editing: yes

Type: Commercial

Last updated: 03 Feb 2017

SQLDoc Sharp

www.codeproject.com/Articles/35790/SQLDoc-Sharp

Free and open source tool designed to generate the SQL Server (2005, 2008) documentation.

Supports: SQL Server

more...

Export: CHM

Allows editing: no

Type: Free

Free edition: yes

Last updated: 18 Sep 2016

CSVReader SQL Server Data Dictionary

www.csvreader.com/posts/data_dictionary.php

Simple SQL script that will generate a data dictionary table.

Supports: SQL Server

Limitations: No UI or export

more...

Metadata stored in: No metadata editing

Allows editing: no

Type: Free

Free edition: yes

Last updated: 18 Sep 2016

Share