SqlSpec: an affordable database documentation tool for all platforms
Do you wish you had comprehensive and uniform database documentation for all your applications, regardless of platform?
Are you a developer or DBA that just inherited a huge, complex application with no supporting database documentation, and don't know where to start learning how it is put together?
Are you an independent contractor working with databases? Your clients will love you when you provide comprehensive database documentation for the applications you build.
SqlSpec is a database documentation tool that will generate easy-to-read database documentation for any of the following platforms:
- Microsoft SQL Server 2000 and above
- Microsoft Analysis Server 2005 and above
- Microsoft Report Server 2005 and above
- Microsoft Integration Server 2005 and above
- Microsoft Access 97 and above
- Oracle 9i and above
- MySQL 5.0 and above
- PostgreSQL 8.0 and above
- Teradata 13.0 and above
- DB2 8.2 and above
- Sybase ASE 12.0 and above
- Sybase SQL Anywhere 10.0 and above
- Informix IDS 9 and above
- VistaDB 3.0 and above
- SQLite 3.7 and above
- ENEA Polyhedra 7.0 and above
- Raima RDM Server 8.1
If the platform you are working with is not in the list above, let us know and we'll consider adding it.
Read more about the many features of SqlSpec here.
See our testimonials page to see what others are saying about SqlSpec.
You don't have to take their word for it though. Check out these examples of what SqlSpec can do.
Why not try out SqlSpec for yourself? The trial version is free. It costs $149 to upgrade to the full version. The trial version is identical to the full version, except that it nags you to upgrade, and it inserts text into the generated documentation to remind you that it's a trial version.
You can find detailed documentation about the many features of SqlSpec here. In particular, the Requirements section tells you what SqlSpec requires to work, and the Quickstart section will tell you how to get up and running quickly.
- works with all major DBMS on the market.
- comment editor supporting SQL Server, Oracle, and more
- both GUI and command line interface
- fine control over what is documented
- customizable look and feel via CSS and custom header/footer
- generate your own entity-relation-diagrams (ERD)
- FREE email support!
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 on the market today. See the pages below for a detailed list of the items documented by SqlSpec for all supported platforms.
- Microsoft SQL Server
- Microsoft Analysis Server
- Microsoft Report Server
- Microsoft Integration Server
- Microsoft Access
- Sybase ASE
- Sybase SQL Anywhere
- ENEA Polyhedra
SqlSpec is supported by a very responsive development team. If you have an idea for a feature that SqlSpec is missing, let us know.
Besides excellent technical support and compatibility with every major DBMS on the market, there are several features that make SqlSpec stand out from the crowded field of database documentation tools available today:
- 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 funtions, 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 affordable tool.