SoftTree SQL Assistant v7.5 (maintenance release) - What's New


New Features and Major Changes
  1. Major enhancements in the data import/export and related functions, including but not limited to import/export to JSON files.
  2. 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.
  3. 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.
  4. Similar new options added to the Test Data Generator utility to disable triggers and referential constraints in destination tables.
  5. Test Data Generator now supports data generation for tables with self-referencing referential constraints.
  6. Added new table scope right-click menu Export to... command to export table data to flat files in a number of different data formats.
  7. Import from Excel utility enhanced to support multiple repetitive file imports.
  8. 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.
  9. New Scheduler Manager utility for managing and editing SQL Assistant's scheduled tasks.
  10. Support for custom connection parameters in database connection settings.
  11. Syntax Indicator Bar stickiness in SQL Assistant's SQL Editor (Professional Edition).
  12. New code execution progress showing percent of work done and providing a better display of individual operations performed.
  13. Improved Open in Excel function - automated conditional formatting in Excel files, plus ready-to-use data filtering.
  14. Support for INTERVAL data types in Oracle, PostgreSQL, DB2, ASA, and SQL Server.
  15. Support for WITH SCHEMABINDING clause in SQL Server procedural objects.
  16. Added two new functions in database source code control interfaces - Undo, and Scan for Database Changes; available for Git, SVN, Perforce, and TFS.

Miscellaneous
  1. Tons of other minor enhancements and bug fixes.

 

SoftTree SQL Assistant v7.3 (maintenance release) - What's New


New Features and Major Changes
  1. 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.
  2. 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.
  3. SQL Intellisense now supports more sorting and filtering methods for matching user input and optimization of suggestions.
  4. New Data Transfer tool for copying data between different databases including data conversions between disparate database systems.
  5. Automatic reconnection of broken database connections.
  6. A number of enhancements in the refactoring functions which are now database version aware and can apply version specific refactoring templates.
  7. Changes in code formatting and beatification functions for improved formatting of data types in variable and parameter declarations, functions returning tabular result sets, etc...
  8. 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.
  9. SQL Assistant's settings can now be exported and imported to/from XML files.
  10. New command line interface for the schema compare, and job compare too.
  11. Enhanced display of session information in SQL Assistant's integrated SQL Editor Professional Edition.
  12. 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.
  13. 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.
  14. Scheduled tasks (scheduled code execution, unit tests, schema comparison, load generation, etc...) now support running operations under different user accounts.
  15. Support for Visual Studio 2015.
  16. Experimental support for SQL Server Management Studio 2016 from SQL Server 2016 CTP 2.0 preview release.

Miscellaneous
  1. Tons of other minor enhancements and bug fixes.

 

SoftTree SQL Assistant v7.2 (maintenance release) - What's New


New Features and Major Changes
  1. Completely reworked schema and job comparison engines adding many new features.
  2. New advanced Schema and Job comparison for Oracle.
  3. New advanced Schema and Job comparison for DB2 UDB.
  4. 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.
  5. New search functions in the result data grids.
  6. 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...
  7. 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...
  8. New data libraries added to the test data generator, including robotic parts, wine list, food ingredients, ore production, and more.
  9. Improved support for PostgreSQL code reverse-engineering for functions and aggregates.
  10. Support for virtual tables in SQLite.
  11. Integrated SQL Editor can now execute code in multiple databases concurrently using independent execution threads
  12. New hot keys for working with the sync-edit feature available in the integrated SQL Editor.
  13. Compatibility changes for latest versions of Toad.

Miscellaneous
  1. Tons of other minor enhancements and bug fixes.

 

SoftTree SQL Assistant v7.1 (maintenance release) - What's New


New Features and Major Changes
  1. New database server type supported; full support for SQLite databases, including full development environment, schema comparison, test data generation, unit testing, source code control, and so on...
  2. New schema comparison engine - fully dynamic, user customizable, database and schema compare and change synchronization engine driven by SQL queries and macro scripts. Preconfigured for SQL Server, Windows Azure, SQLite, MySQL, PostgreSQL. Also supports database jobs and schedules comparison and change synchronization.
  3. Enhancement in code reusability and context SQL search - improved results and their navigation.
  4. Auto-closing of previous execution results before running new SQL commands.
  5. Convergence of name matching methods and filters in DB Explorer.
  6. New hot key for custom formatting styles and on-the-fly style selection (Ctrl+Shift+F11).
  7. Reordering tabs in the integrated SQL Editor.
  8. Auto-formatting of code snippet processing results before inserting results into editor.
  9. Improved Intellisense for DECLARE statements in T-SQL environments.
  10. Improved Intellisense for temp tables in MySQL, Oracle, DB2 databases.
  11. Enhancement in the integrated SQL Editor - sticky connection color easy change (double-click server name in status bar, change color).
  12. Enhancement in the integrated SQL Editor - now supporting cancelation of long running operations in all types of database interfaces.
  13. Compatibility changes for latest versions of pgAdmin and Toad.

Miscellaneous
  1. Tons of other minor enhancements and bug fixes.

 

SoftTree SQL Assistant v7.0 (major release) - What's New


New Features and Major Changes
  1. New "Code Context" solution for discovering and improving database code reusability.
  2. New Professional SQL Editor - a full-featured database development environment for 10 database types.
  3. New database workload generator for application scalability testing.
  4. New database server type supported – Amazon Redshift.
  5. 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.
  6. 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.
  7. Document Managers implemented for Toad, Eclipse, DB Tools, Notepad++, pgAdmin.
  8. Enhanced Document Manager now enables fast recent documents filtering by context.
  9. 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.
  10. 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.
  11. All databases: SQL Intellisense enhancements for UPDATE and CALL statements - use of {fields} for faster code entry.
  12. 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.
  13. MSSQL and Sybase ASE: SQL Intellisense enhancements for temporary tables -  column suggestions now provided for temporary tables having their definition predictable in design time.
  14. New command line interface and scheduling for the Data Compare utility, now data comparisons can be scheduled, as well as integrated with Unit Tests.
  15. Enhanced $OBJECT$ macro enables multiple columns selection.
  16. Compatibility changes for Toad for SQL Server 6.1 and later – now supporting database connection sharing, and other improvements.
  17. New add-on for Visual Studio 2013
  18. New add-ons for Delphi XE 1-5.
  19. Compatibility changes for supporting latest UltraEdit v20.
  20. MSSQL: support for database-level triggers.
  21. MSSQL: support for custom table-type data types.
  22. Interactive SQL Reference for Amazon Redshift.
  23. Interactive SQL Reference for MS SQL 2012
  24. Interactive SQL References for DB2 10.1, DB2 10.5
  25. All databases: The Source Code Control interface now supports custom data types.

Miscellaneous
  1. Lots of other minor changes and enhancements.

 

Changes in Other Versions

See What's New 6.x page for details on new features added in SQL Assistant version 6.x releases.

See What's New 5.x page for details on new features added in SQL Assistant version 5.x releases.

See What's New page for details on new features added in SQL Assistant versions 2.x - 4.x.