Elsasoft joins ComponentSource

SqlSpec lets you generate easy-to-read database documentation for a wide range of platforms.

Zoom [+]

Database documentation created with SqlSpec.

SqlSpec is a database documentation tool that will generate easy-to-read database documentation. SqlSpec generates documentation in two formats: HTML or CHM. HTML is useful for publishing your documents on the Web or an intranet site. CHM is useful if you want a single, compact file containing all your documentation about one or more databases. The CHM is indexed so it is easily searchable for any keyword. This way you can easily determine which objects reference the "EmployeeID" column, for example. SqlSpec supports every major DBMS including Microsoft SQL Server, Microsoft Analysis Server, Microsoft Report Server, Microsoft Integration Server, Microsoft Access, Oracle, MySQL, PostgreSQL, Teradata, SQLite, DB2, Sybase ASE, Sybase SQL Anywhere, Informix, VistaDB and ENEA Polyhedra.

Features

• Extended property/comment editor supporting SQL Server, Oracle, and more
• Show scripts for all objects documented.
• Ability to add your own branding logo (headers and footers) to each page in the documentation.
• Run as a console application, useful for automating SqlSpec to generate documentation for your databases on a schedule, or integrating SqlSpec into your development process.
• Supports XML comments added to your stored procedures, user defined functions, views, and triggers, similar to XML comments in C# code. These comments are parsed by SqlSpec and the content is placed in your documentation.
• Include external objects (such as web services, web pages, and other components) in the documentation. Specify dependencies of external objects on database objects and they will be included in the dependency graphs.
• Creates data model diagrams where any database object (or external object) can be represented.
• Specify an exclusion list so that certain objects (or just the SQL code for them) can be excluded from the documentation.
• Specify a custom navigation hierarchy to include arbitrary HTML files in the generated CHM.
• Generate dependency and primary/foreign key graphs. Such diagrams are much easier to understand at a glance than a flat list of dependent objects.
• Generate a call graph for sprocs and udfs that call other sprocs and udfs.
• Fine control over what object types are documented.
• Support for every major DBMS in a single tool

About Elsasoft

Elsasoft was founded in Seattle, in 2006, by Jesse Hersch, Ph.D. Its SqlSpec product helps you understand your data by generating easy-to-read and comprehensive documentation for any database, on any platform. Over the years, SqlSpec has grown into a powerful database documentation application with impressive features, currently supporting 17 different platforms. Elsasoft donates free licenses to charities, non-profits and open source projects. Its goal is simply to provide a useful product at an affordable price with exceptional customer service.