SqlSpec generates database documentation for various DBMS, including Oracle, SQL Server, DB2, Sybase ASE, MySQL, and more. It helps database developers and administrators to generate documentation quickly and easily.
With SqlSpec, you only need to provide one or more connection strings, and it will generate documentation that includes the dependencies of these tables, the foreign keys they point to, which tables are used by which stored procedures, among other things. You can even see the code of each trigger, view, user defined function, check constraint, and stored procedure in the database.
The generated output is available in HTML and CHM format which makes it easy for you to store, share or print your documentation. You can also add web pages, COM objects, and other external code to your documentation by configuring SqlSpec to do it for you. SqlSpec also incorporates these objects into the dependency graphs it generates, making it easier for you to track the dependencies of each table.
SqlSpec makes it easier for you to keep your documentation updated. All you need to do is run SqlSpec on your databases, and it updates the documentation. If you're looking for a reliable tool to help you generate documentation quickly and accurately, SqlSpec is the software for you.
Version 6.5: SqlSpec now generates specs for SQL Server, Analysis Server, Oracle, DB2, Sybase ASE, Sybase SQL Anywhere, MySQL, PostgreSQL, Informix IDS, VistaDB, ENEA Polyhedra, and MS Access. . . See http://www.elsasoft.com/sqlspec.htm (history section) for details.
Version 6.2: SqlSpec now generates specs for SQL Server, Analysis Server, Oracle, DB2, Sybase ASE, Sybase SQL Anywhere, MySQL, PostgreSQL, Informix IDS, VistaDB, ENEA Polyhedra, and MS Access. . . See http://www.elsasoft.org/sqlspec.htm (history section) for details.
Version 5.0: SqlSpec now generates specs for MS SQL Server, MS Analysis Server, MS Report Server, MS Access, Oracle, DB2, Sybase ASE, Sybase SQL Anywhere, MySQL, PostgreSQL, Informix IDS, VistaDB, ENEA Polyhedra, and Raima RDM Server. See http://www.elsasoft.org/sqlspec.htm (history section) for details.
Version 4.0: SqlSpec now generates specs for SQL Server, Analysis Server, Oracle, DB2, Sybase ASE, Sybase SQL Anywhere, MySQL, PostgreSQL, Informix IDS, VistaDB, ENEA Polyhedra, and MS Access. . . See http://www.elsasoft.org/sqlspec.htm (history section) for details.
Version 3.7: SqlSpec now generates specs for SQL Server, Analysis Server, Oracle, DB2, Sybase ASE, MySQL, PostgreSQL, Informix IDS, VistaDB, ENEA Polyhedra, and MS Access. . . See http://www.elsasoft.org/sqlspec.htm (history section) for details.
Version 2.0.18: minor bug fix
Version 2.0.15: minor bug fix
Version 2.0.10: added several object types to documentation:. 1. schemas . 2. xml schema collections. 3. assemblies. 4. clr procedures. 5. symmetric and asymmetric keys. 6. certificates. 7. synonyms.
Version 2.0.3: fixed unicode bug in sproc comments.
Version 2.0: N/A