SoftTree SQL Assistant 6.0.86 (maintenance release) - What's New
New major features
Real time as-you-type automatic code performance analysis and suggestions.
Full-featured integrated source control interface with 3-way database-files-repository code comparison and synchronization, checkin/checkout, change history, and so on… The source code control interface is supports Subversion and Microsoft Team Foundation Server code repositories.
Graphical code execution plans for all types of supported database servers.
Other significant improvements
Customizable database version specific queries and settings. Database version is recognized automatically and version specific settings are used as required.
On the fly reverse engineering of virtually all types of database objects, "Show DDL" is now available for all objects.
Customizable SQL Assistant menus, add/delete/reorder menu items to match your coding habits and increase your productivity.
All databases: Table statistical hints and information panes, including instant row count hints for tables of any size, table columns with unfolding user-defined data types, and more.
SQL Server and Sybase ASE/ASA databases: Intellisense is now offered for UPDATE...FROM and DELETE FROM ... FROM statements.
All databases: intellisense for Common Table Expressions (a.k.a CTE in SQL Server, and WITH clause in Oracle)
All databases: intellisense is now available for APPLY keywords
All databases: intellisense for UPDATE statements provides enhanced support for built-in database functions.
Test-data generator is now context sensitive. Right-click on a table name, choose Test-data Generator menu, and with one additional click you can start inserting realistic test-data into the selected table.
Test-data generator supports generating test values for Oracle's LONG data-type.
PostgreSQL: warnings and notices are reported separately from errors.
PostgreSQL: intellisense for SERIAL and IDENTITY column in INSERT/UPDATE statements.
All databases: intellisense for various SEQUENCE and sequence-like objects and functions, for example in Oracle, ".nextval", in DB2: "NEXT VALUE FOR ", in PostgreSQL "naexval()" and pg_get_serial_sequence function, and so on
All databases: intellisense for JOIN suggestions now provides previews of table aliases for to be inserted code.
Sybase ASA: support for unsigned data types.
All databases: intellisense for INSERT...VALUES supports script variables and procedure parameters.
All databases: improved Intellisense for ALTER TABLE statement.
All databases: intellisense now supports coding database triggers.
Unit-test can now be scheduled directly from SQL Assistant interface.
Column name filtering is now available in code snippets using $OBJECT$ macros.
Refactoring templates now support standard set of SQL Assistant macros.
New pre-defined interactive code snippets.
Support for latest versions of MySQL Workbench.
Support for latest versions of Ultraedit.