SqlSpec

  • Rating:
  • Version: 6.6
  • Publisher:
    www.elsasoft.org
  • File Size: 591.71 KB
  • Date: Aug 20, 2012
  • Price: $149.00
  • License: Free Trial Software
  • Category:
    Database Management
    Business & Finance
SqlSpec Download
Free Download SqlSpec 6.6

SqlSpec will generate easy-to-read docs for any SQL Server, Analysis Server, Oracle, DB2, Sybase ASE, MySQL, PostgreSQL, Informix IDS, VistaDB, ENEA Polyhedra, or MS Access database. Given one or more connection strings, SqlSpec will generate documentation about all the tables, views, stored procedures, triggers, indexes, constraints, schemas, assemblies, CLR procedures, xml schema collections, synonyms, symmetric and asymmetric keys, user defined types, and user defined functions in your database. It will also tell you what the dependencies are (which tables point to other tables via foreign keys, which tables are used by which stored procedures, etc.) It will show the code for each trigger, view, user defined function, check constraint, and stored procedure in the database. SqlSpec generates output in HTML and CHM format. You can configure it to add external objects (such as web pages, COM objects, and other external code) to the documentation as well. You can even incorporate such objects into the dependency graphs generated by SqlSpec. With SqlSpec, it is easy to keep documentation in sync with the actual database, since you can just run SqlSpec on your databases and your documentation gets updated.

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:
* SQL Server 2000/2005/2008
* Analysis Server 2005
* Oracle 9i and above
* DB2 8.2 and above
* Sybase ASE 12.0 and above
* Informix IDS 10.0 and above
* PostgreSQL 8.0 and above
* MySQL 5.0 and above
* Access 97 and above
* VistaDB 3.0 and above
* ENEA Polyhedra 7.0 and above
* SQL Anywhere 10.0

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:
* 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.

The license of this software is Free Trial Software, the price is $149.00, you can free download and get a free trial.

More Details:
Related Software: