October 22nd, 2011· Add support for SSRS in SharePoint Integrated mode and a few other minor SSRS related fixes.
· Improve performance when excluding a large number of objects (like 10,000 or more). Yes, there are some large databases out there! SAP for example has nearly 300,000 tables in it according to this site: http://tables.ofsap.com. That’s not a typo. Three. Hundred. Thousand. Tables.
· Improve navigation of dialogs using arrow keys. Now you can move between the pages of the app with up/down arrows. Also move from one comment to the next in the “add comments” GUI using ctrl-up and ctrl-down.
· Add support for fetching permissions objects in Oracle.
· Add workaround for GraphViz bug.
· Add textboxes for delimiters in the GUI
· Fix Oracle diagrams if documenting a schema other than the default schema
· Add support for Informix 9.
· Fix package exclusion in Oracle.
· Better logging of arguments, progress. Color error messages red in the progress window so they stand out more.
October 22nd, 2011· Add support for fetching dependencies between objects in different schemas in Oracle. This is analogous to a cross-database dependency in SQL Server.
· Add support for drawing data model diagrams with GraphViz, here’s an example. GraphViz is a powerful graph rendering package from AT&T research, available here: http://www.graphviz.org
· Bug fix for DB2 if can't get pagesize.
· Bug fix for cross-schema dependencies in Oracle if dependency is on non-table object.
· Bug fix: exclude indexes if parent table is also excluded.
October 22nd, 2011· Add support for exclusion lists in SSRS (Microsoft Report Server)
· Fixed bug where choose objects checkboxes were not being populated when opening GUI from a .ssproj file.
· SSIS fix: take server name from file path for DTSX files if the path is UNC. Good suggestion Pat!
· Fixed bug in SSAS where things weren’t working if database name was different from database ID.
· Fixed bug in Oracle where functions weren’t being returned unless DocumentProcedure was set TRUE.
· Fixed bug in pie charts where imagemaps weren’t being used in all DBMS. Also picked some colors that are a bit easier on eyes.
October 22nd, 2011· Added support for Microsoft Integration Server 2005 and 2008.
· Added support for Teradata 13.
· Added support for SQLite.
· Added support for more platforms in the Extended Properties editor.
· Added support fo comments on proc params in Extended Properties editor.
· Added a “columns” section for table valued functions so you can see what columns they return (SQL Server only).
· Added a few properties to function and function overview page: deterministic, schema bound, inline (SQL Server only).
· Allow suppressing of dependencies of objects on schemas, see “schema dependency” checkbox in GUI (SQL Server only).
· Allow specifying max threads in GUI (this was already available from command line via /threads switch).
· Added support for replacing tabs with spaces in DDL. See “spaces per tab” textbox on the “optional settings” page of the GUI.
· Fixed bug where DDL was not using Consolas font when not colorized.
· Added scripting of users, logins, and roles for SQL Server
· Added support for connecting to Oracle using ODBC.
· Added details in foreign key section (cascade update, delete, etc) for SQL Server.
· Added support for replacing tabs with spaces in DDL.
· Added support for specifying sample rows from views separately from sample rows for tables. Some views can be very expensive to select from so you may want to NOT select from any views when generating docs.
· Added support for ordering sample rows. See the “sample sort order” drop down in the GUI.
October 22nd, 2011· Added an Extended Properties Editor, supports SQL Server, Oracle, and PostgreSQL. Using this GUI you can easily annotate all your database objects with comments.
· Support for documentation of user defined messages in SQL Server, controlled by “messages” checkbox in GUI, or /message command line arg.
· Fixed several bugs related to Analysis Server docs, see http://elsasoft.org/forum/topic.asp?TOPIC_ID=135 and http://elsasoft.org/forum/topic.asp?TOPIC_ID=303
· Added more server level documentation for Windows based servers, such as disks, processors, etc, fetched through WMI calls.
December 18th, 2009· Support for Microsoft Report Server 2005/2008
· Added upgrade check: if you purchased a license in the past and it is currently greater than one year old, you must purchase an upgrade license here: http://www.elsasoft.org/util/upgrade.aspx. If your license key is less than an year old, then this version is a free upgrade for you.
December 18th, 2009· Support for Raima RDM Server
· Support for SVG diagrams. With SVG, the diagrams can be rendered in all browsers, such as Firefox, Opera, Safari, and Internet Explorer.
· Added /sn command line switch to specify using “short names” in the documentation instead of two- and three-part names. This is supported in the GUI with a “short names” checkbox on the optional settings page.
· Add each table and view column to the CHM index.
· SQL Server: Support for an extended property filter. If you use a filter, only extended properties in the named in the filter will be fetched.
· Analysis Server: support for excluding XMLA and MDX code for objects.
October 31st, 2008· Support for Sybase SQL Anywhere
· Added a “choose objects” page in the GUI where you can specify what object types you want to document. Added many command line flags to support this.
· Support for all 12 DBMS platforms in the “exclude objects” GUI. Previously this GUI supported only SQL Server.
· Support for arbitrary HTML in database comments – see /pt command line switch.
· Support for using a different extended property from MS_Description for object comments. This is useful if you want to localize your documentation and have the same comment in multiple languages.
· Analysis Server: support for XML comments in MDX scripts. This enables documentation of calculated members.
· Support for cross database and cross server dependencies (through linked servers)
· Support for column dependencies. That is, SqlSpec will tell you which columns of which tables a stored procedure selects or updates.
· SQL Server: support for XML comments on objects that don’t have their DDL stored on the server, such as tables. This is implemented with extended properties.
· SQL Server: add extended properties filter. Using this you can restrict by name the extended properties that are fetched by SqlSpec.
· Access: fix bug where SqlSpec could not document linked tables. This was due to a limitation in the API that SqlSpec was using, GetOleDbSchemaTable. We switched to using DAO and that seems to have fixed it. We still use GetOleDbSchemaTable if DAO is not installed however.
February 16th, 2007· SqlSpec now generates specs for SQL Server, Oracle, DB2, MySQL, PostgreSQL, Analysis Server 2005, and Access
November 27th, 2006· SqlSpec now generates specs for Analysis Server 2005, as well as SQL Server 2000/2005
October 16th, 2006· SqlSpec now generates specs for Analysis Server 2005, as well as SQL Server 2000/2005
Find us on Google+
