25 Data Dictionary Tools

This is the list of all data dictionary Data dictionary is data about data - list of tables, columns and their relationships with a description of each element. This is a basic way to document a relational database. tools for popular relational databases (Oracle, SQL Server, MySQL or PostgreSQL). This list only includes tools that enable creating and managing Data Dictionaries for physical models. Simple documentation generators can be found on more complete Database Documentation Tools list.

Share

Dataedo

dataedo.com

Data dictionary and ER Diagram creator

Supports: SQL Server, Oracle, MySQL, MariaDB, Azure SQL Database, Amazon Aurora

Notable features: Entity Relationship Diagrams, Splitting objects into modules, Documenting missing foreign and unique keys, Documentation progress tracking, Rich text and images, Search, Global repository for documentation of all databases, Teamwork ready

more...

Export: HTML, PDF, MS Excel

Metadata stored in: Documentation repository/file

Type: Commercial

Free edition: yes, Pricing from: $179

Last release: Apr 2017 (5.2)

Last updated: 10 May 2017

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

Type: Commercial

Free edition: no, Pricing from: $369

Last updated: 18 Sep 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

Type: Commercial

Free edition: no, Pricing from: $29

Last updated: 22 Apr 2017

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

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

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)

more...

Export: HTML, CHM

Metadata stored in: Database metadata

Type: Commercial

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

Type: Commercial

Free edition: no, Pricing from: $395

Last updated: 18 Sep 2016

LiveDoco

www.livedoco.com

Supports: SQL Server

Notable features: "Live" data dictionary, custom fields

more...

Export: HTML, XML

Metadata stored in: SQL Server extended properties

Type: Commercial

Free edition: no, Pricing from: $49

Last updated: 18 Sep 2016

Document! X

www.innovasys.net/product/dx/overview

Authoring environment which can be used to create documentation for .NET, Web Services, Databases, XSD Schemas, COM Components and Type Libraries, Java and Javascript.

Supports: SQL Server, Access, Oracle

Notable features: Documents more than just databases, Visual Studio integration, Ability to integrate with social platforms (Facebook, Disqus) to enable commenting

Documents also: .NET, Web Services, XSD Schemas, COM Components and Type Libraries, Java and Javascript

more...

Export: HTML, CHM, Help, Visual Studio Help

Type: Commercial

Free edition: no, Pricing from: $585

Last updated: 18 Sep 2016

Leadum DBScribe

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

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

more...

Export: CHM, HTML, MS Word

Metadata stored in: SQL Server extended properties

Type: Commercial

Free edition: no, Pricing from: $39

Last release: Oct 2010

Last updated: 18 Sep 2016

Yohz DB Doc

www.yohz.com/dbdoc_details.htm

Supports: PostgreSQL

Notable features: Customizable layout

more...

Export: PDF, HTML, CHM

Metadata stored in: PostgreSQL comments

Type: Commercial

Free edition: no, Pricing from: $35

Last updated: 18 Sep 2016

DTM Schema Reporter

www.sqledit.com/sr/index.html

Supports: SQL Server, Oracle, DB2, MySQL, PostgreSQL, SQLite, Sybase, 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

Type: Commercial

Free edition: no, Pricing from: $159

Last updated: 18 Sep 2016

SchemaToDoc

www.schematodoc.com

Supports: SQL Server, Oracle

more...

Export: MS Word, HTML

Metadata stored in: SQL Server extended properties, Oracle comments

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

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

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

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

Type: Commercial

Free edition: no, Pricing from: $295

Last release: Jan 2006 (2.0)

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

Type: Free

Free edition: yes

Last release: Jul 2010 (1.3.4)

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

Type: Commercial

Free edition: no, Pricing from: $200

Last release: Nov 2015 (1.5.2)

Last updated: 18 Sep 2016

Oracle SQL Developer

www.oracle.com/technetwork/developer-tools/sql-developer/overview/index-097090.html

Free database IDE from Oracle.

Supports: Oracle

Notable features: Entity Relationship Diagrams

more...

Type: Free

Free edition: yes

Last updated: 22 Apr 2017

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

DBDocumentor

www.pikauba.com/DBDoc/Details.htm

Supports: SQL Server, Firebird, Sybase, 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

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

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

Type: Commercial

Last updated: 03 Feb 2017

Last research made on 16 September 2016

Share