SoftTree SQL Assistant download

v9.2 [Jul 31, 2017]
- New Data-pivot and Analytics.
- New experimental Code Visualizer for generating graphical code flow and sequence diagrams for procedural schema objects, views, and arbitrary SQL code.
- New experimental Visual Database Documenter is a graphical documentation generator for entire schemas and databases.
- New Batch Database Refactoring interface takes schema object management to a new level.
- New database refactoring method for renaming schemas supporting SQL Server, Oracle, MySQL, PostgreSQL, DB2 UDB, Redshift, Netezza.
- New Tab Manager for tab management and faster code navigation.
- User interface enhancements: name filters are now available in all tools featuring schema object trees.
- Schema compare enhancements for PostgreSQL: comparison and synchronization of database attributes, tablespaces.
- SQL Intellisense enhancements for multiple database types: support for labels in SQL code.
- SQL Reference enhancements for Netezza, ASA, ASE, MySQL.

v7.5 [Feb 25, 2016]
New Features and Major Changes
Major enhancements in the data import/export and related functions, including but not limited to import/export to JSON files.
Automatic data type remapping when importing or exporting from/to different types of database systems, or using the data transfer utility, or performing schema comparison between two different database types.
A number of enhancements in the data transfer utility including 1-click solution for transferring limited data samples from production to development database systems; new options to disable triggers and referential constraints in destination tables.
Similar new options added to the Test Data Generator utility to disable triggers and referential constraints in destination tables.
Test Data Generator now supports data generation for tables with self-referencing referential constraints.
Added new table scope right-click menu Export to… command to export table data to flat files in a number of different data formats.
Import from Excel utility enhanced to support multiple repetitive file imports.
Enhanced Code Structure View – related operations are now grouped together, for example, a bunch of INSERTs into a single table is now shown as a single expandable item.
New Scheduler Manager utility for managing and editing SQL Assistant’s scheduled tasks.
Support for custom connection parameters in database connection settings.
Syntax Indicator Bar stickiness in SQL Assistant’s SQL Editor (Professional Edition).
New code execution progress showing percent of work done and providing a better display of individual operations performed.
Improved Open in Excel function – automated conditional formatting in Excel files, plus ready-to-use data filtering.
Support for INTERVAL data types in Oracle, PostgreSQL, DB2, ASA, and SQL Server.
Support for WITH SCHEMABINDING clause in SQL Server procedural objects.
Added two new functions in database source code control interfaces - Undo, and Scan for Database Changes; available for Git, SVN, Perforce, and TFS.
Miscellaneous
Tons of other minor enhancements and bug fixes.

v7.3 [Dec 26, 2015]
New Features and Major Changes
Completely reworked database source code control adding many new features, now supporting Git, Github, and Perforce in addition to SVN and TFS. Among many changes are transition to asynchronous background operations, support for more object types, propagation of item change statuses across the folder trees, fast predefined status change filters, and more.
Incremental improvements in the SQL Intellisense engine, including support for multiple CTE expressions in a single query, user-defined data types in PostgreSQL, Intellisense for additional types of ALTER and DROP commands, expanded support for triggers.
SQL Intellisense now supports more sorting and filtering methods for matching user input and optimization of suggestions.
New Data Transfer tool for copying data between different databases including data conversions between disparate database systems.
Automatic reconnection of broken database connections.
A number of enhancements in the refactoring functions which are now database version aware and can apply version specific refactoring templates.
Changes in code formatting and beatification functions for improved formatting of data types in variable and parameter declarations, functions returning tabular result sets, etc...
Enhanced display of aggregated and detailed row counts for a schema or entire database, yes, that one-click display of row counts for all tables in a schema or a database.
SQL Assistant's settings can now be exported and imported to/from XML files.
New command line interface for the schema compare, and job compare too.
Enhanced display of session information in SQL Assistant's integrated SQL Editor Professional Edition.
Support for retrieval and display of binary values across all supported database types, including VARBINARY, BINARY, RAW, BLOB, CLOB, IMAGE, TEXT, BYTEA, and so on.
Support for exporting and importing binary values such as images, sound tracks, and other types of binary data, including VARBINARY, BINARY, RAW, BLOB, CLOB, IMAGE, TEXT, BYTEA, and so on.
Scheduled tasks (scheduled code execution, unit tests, schema comparison, load generation, etc...) now support running operations under different user accounts.
Support for Visual Studio 2015.
Experimental support for SQL Server Management Studio 2016 from SQL Server 2016 CTP 2.0 preview release.
Miscellaneous
Tons of other minor enhancements and bug fixes.

v7.2 [Jun 1, 2015]
- Completely reworked schema and job comparison engines adding many new features.
- New advanced Schema and Job comparison for Oracle.
- New advanced Schema and Job comparison for DB2 UDB.
- A number of other across the board enhancements in the schema comparison engine and queries, including new extensions for SQL Server, Windows Azure, SQLite, MySQL, PostgreSQL.
- New search functions in the result data grids.
- Many significant enhancements for supporting latest DB2 versions and features. Expanded support for a number of schema object types including but not limited to modules, sequences, types, and type members, etc…
- Many significant enhancements for supporting latest Oracle versions and features. Expanded support for a number of schema object types including but not limited to materialized views, nested tables, object tables, overloaded package and type methods, etc…
- New data libraries added to the test data generator, including robotic parts, wine list, food ingredients, ore production, and more.
- Improved support for PostgreSQL code reverse-engineering for functions and aggregates.
- Support for virtual tables in SQLite.
- Integrated SQL Editor can now execute code in multiple databases concurrently using independent execution threads
- New hot keys for working with the sync-edit feature available in the integrated SQL Editor.
- Compatibility changes for latest versions of Toad.

v7.0 [Jul 24, 2014]
- New "Code Context" solution for discovering and improving database code reusability.
- New Professional SQL Editor - a full-featured database development environment for 10 database types.
- New database workload generator for application scalability testing.
- New database server type supported – Amazon Redshift.
- New context SQL search with real-time suggestions and centralized fully indexed code repository supporting full text search indexes for database code across multiple database servers.
- Enhanced Document Manager - visualizes file context when closing development environment and saving multiple files; no more guess work when prompted to save a bunch of generically named scripts without being able to see their content.
- Document Managers implemented for Toad, Eclipse, DB Tools, Notepad , pgAdmin.
- Enhanced Document Manager now enables fast recent documents filtering by context.
- Improved DB Explorer– completely rewritten, the new robust explorer interface supports all target editors and databases; even Windows Notepad can be now turned into full featured database editor. DB Explorer features a number of unique functions, including in-line display of object stats, last modification time, object and column comments, linking to external files, and more.
- Unit Testing Framework now enables logging and saving unit test results to a database table for advanced data analysis using specialized analytical and reporting software.
- All databases: SQL Intellisense enhancements for UPDATE and CALL statements - use of {fields} for faster code entry.
- All databases: SQL Intellisense enhancements enable selecting of "Name Matching Method" in runtime, name matching and sorting can be changed with two clicks directly in SQL Intellisense popups.
- MSSQL and Sybase ASE: SQL Intellisense enhancements for temporary tables - column suggestions now provided for temporary tables having their definition predictable in design time.
- New command line interface and scheduling for the Data Compare utility, now data comparisons can be scheduled, as well as integrated with Unit Tests.
- Enhanced $OBJECT$ macro enables multiple columns selection.
- Compatibility changes for Toad for SQL Server 6.1 and later – now supporting database connection sharing, and other improvements.
- New add-on for Visual Studio 2013
- New add-ons for Delphi XE 1-5.
- Compatibility changes for supporting latest UltraEdit v20.
- MSSQL: support for database-level triggers.
- MSSQL: support for custom table-type data types.
- Interactive SQL Reference for Amazon Redshift.
- Interactive SQL Reference for MS SQL 2012
- Interactive SQL References for DB2 10.1, DB2 10.5
- All databases: The Source Code Control interface now supports custom data types.

v6.5 [Dec 6, 2013]
- SQL Server 2014 is now supported.
- Added graphical Database Explorer for all supported database servers and target editors. Now every supported editor, even Notepad, can be converted to a fully functional database development tool.
- Experimental Tab Manager and Script Version History add-on for SQL Server Management Studio.
- Single editor-scope SQL Intellisense Suspend/Resume provides greater flexibility.
- Added sorting options for $COLUMNS$ macro.
- XML Schema Export/Import now saves and restores table primary keys.
- SSMS Object Explorer add-on - enhanced cache refreshing.
- Oracle performance analyzer and Explain Plan features now support use of shared public PLAN_TABLE synonym. Users no longer need individual PLAN_TABLE tables in their own schema.
- Oracle column data preview feature enhanced to support more data types
- Support for latest Notepad versions and other Scintilla based editors .
- Compatibility changes for DDL code revere-engineering in latest PostgreSQL database server versions.
- Trigger DDL code revere-engineering in all supported database systems.
- Lots of other minor changes and enhancements.

v6.3 [Nov 16, 2012]
- SQL Intellisense enhancements – multiple text matching methods including suffix name matching, spelling correlation, and matching characters highlighting.
- New Task and Reminders interface – centralized view of persistent bookmarks and "to-do" reminders saved across multiple files, database servers and objects.
- New plug-in for Oracle JDeveloper – complete drop-in development toolbox, including full set of SQL Assistant utilities and a full featured SQL Editor.
- New plug-in for Oracle SQL Developer – complete drop-in development toolbox, including full set of SQL Assistant utilities and a full featured SQL Editor.
- New multi-server, multi-database data search and replace with advanced options, regular expressions, preview-before-change, and more.
- Enhancement in code formatting and layout controls - additional macro variables added to improve control of dynamically generated code headers.
- Visual bookmarks enfacements – removed limitations on the number of persistently saved bookmarks in a single file.
- Added new options for greater controls of application filters to aid users in resolving cross-application conflicts.
- Better integration with external code comparison tools. External tools can be now used nearly in all places where an internal code compare is used.
- Enhancement in SQL Intellisense for SQL Server – improved handling of user-defined data types (column descriptors now display the original data type along with its expanded description).
- Enhancement for XML data import – new Truncate table option added for data loading.
- Enhancement for XML Export and Data Generator produced deployment scripts – new option to generate CREATE TABLE commands as part of the script with multiple options, including IF NOT EXISTS.
- Enhancement for XML Export/Import and Excel Import – added graphical scheduling for unattended operations.
- Lots of other minor changes and enhancements.

v6.1 [Feb 3, 2012]
New add-on and integration with SQL Server Management Studio 2012.
Support for SQL Server 2012
Automatic source control system repository updates and database synchronization using scheduled job.
Improved SQL Intellisense - smart parameter and column values input helpers; auto-selection and auto-deletion of specially formatted comments.
Improved SQL Intellisense - customizable table order in context popups.
SQL history and recall.
Hints for SQL Reference rules.
Oracle DBMS_OUTPUT polling and reading.
1-click copying of DDL scripts from Code Preview to SQL editor..
Improved code formatting - support for customizable column/table alias alignment options.
Advanced version of the $OBJECT(...)$ macro for use in interactive code snippets for fast code generation.
Support for latest versions of MySQL Workbench, Toad, Ultraedit.