Softpedia >Windows >Internet >Servers >Database Utils >SoftTree SQL Assistant >  Changelog

SoftTree SQL Assistant Changelog

What's new in SoftTree SQL Assistant 12.4.474

Oct 6, 2023
  • New major features and significant enhancements:
  • Advanced spreadsheet class conditional formatting in data grids allows data visualizations in colors with a few mouse clicks. This is a game changer for all who spent much time working with data.
  • Actual query execution plans for most of the supported database systems with capturing actual run-time metrics for internal query operations. New enhancements make analyzing query plans and tuning queries easier than ever. Various techniques are used depending on the database system type to monitor its internal operations and gather performance metrics.
  • SQL Assistant add-on for 64-bit version of Visual Studio 2022.
  • Improved and more intuitive UI for setting up Context SQL Search. New graphical Code Repository browser.
  • Code entry automation - new parameters for $CURRENT(word)$ macro support more use cases.
  • Database management enhancements and new features:
  • SQL Server - SQL Intellisense enhancements supporting features introduced in SQL Server 2022.
  • PostgreSQL - SQL Intellisense enhancements supporting features introduced in PostgreSQL 14.x and 15.x.
  • PostgreSQL - Graphical management of constraints ON DELETE features introduced in PostgreSQL 15.x.
  • Oracle - Table and index management tools now support graphical management of subpartitons.
  • DB2 - Table and index defragger.
  • Amazon Redshift - Graphical management of users, groups, and roles.
  • Amazon Redshift - Graphical management of external schemas and external tables.
  • Amazon Redshift - Graphical management of dynamic data masking policies.
  • Amazon Redshift - Graphical management of row-level security policies.
  • MariaDB - support for new UUID data type.
  • MariaDB - query execution plans for MariaDB versions 10.4 and later enriched with additional data from optimizer traces.
  • MySQL - query execution plans for MySQL versions 8.0 and later enriched with additional data from optimizer traces; table nameless aliases replaced with actual table names and more.
  • Snowflake - Improved data transfer UI allows copying data from multiple databases.
  • Snowflake - SQL Intellisense enhancements supporting many more Snowflake features.
  • Miscellaneous:
  • UI enhancements - DB Explorer and other database navigation controls support fixed columns to keep the important context visible on screen while scrolling.
  • MySQL - better handling of expired connections for all supported connectivity drivers; automatic reconnects are more reliable.
  • Test data generator - much faster generation of sequence values when inserting data into non-empty tables; optimized checks for unique values.
  • All Performance Dashboards - now support sorting columns in data grids on column header click.
  • A number of other minor improvements and bug fixes.

New in SoftTree SQL Assistant 12.3.431 (Aug 14, 2023)

  • Short introduction:
  • There are multiple new exciting features in version 12.3. The query execution plans have been significantly modernized. They are now available in multiple formats including graphical plan diagrams with customizable layouts in addition to tree based and raw plan versions in JSON, XML, tabular, and text formats. Additional plan statistics and database engine warnings have been added to plans where they are supported by database engines. The new Query Store Explorer for SQL Server, ASH and AWR Explorers for Oracle enable you to browse explore historical database performance, compare and analyze changes over time, identify applications and queries with steadily deteriorating performance. Below are more details on what's new in this maintenance release.
  • New major features and significant enhancements:
  • Query execution plan diagrams with customizable layouts.
  • New Connection Organizer - if you deal with many databases, this is for you, to help you group and organize your database connections and to find them faster.
  • New Bookmarks pane for bookmark lovers, so you can see all visual bookmarks with text previews at a glance.
  • Document manager metadata is now stored in SQLite database instead of XML files. Searches for historical documents are now faster, and a longer document change history can be supported. Saving documents is faster too, reliving you from a need to periodically purge the documents repository folder to speed up file access.
  • Code Visualizer enhancement - Upsert operation is represented as a compound DML operation with conditional IF blocks and multiple logical operations instead of a single statement.
  • Database Modeling enhancement - multiple model diagrams for the same database can be created and stored in the same project file.
  • Application Data Lineage enhancements - syntax highlighting for all supported file types.
  • Multiple enhancements in SQL Assistant SQL Editor (Pro Edition), including new multi-row tabbed interface, sticky tabs, and more.
  • SQL Intellisense enhancements - better handling of keywords that are not reserved keywords.
  • Updated Object Explorer add-on for the latest SQL Server Management Studio version 19.0.2.
  • Database management enhancements and new features:
  • SQL Server - Query Store Explorer, and historical query performance reports with graphical query plan comparison and more.
  • Oracle - Active Session History Explorer with historical resource usage reports by application and users.
  • Oracle - Automatic Workload Repository Explorer, and historical query performance reports with graphical query plan comparison and more.
  • Oracle - Enhancements in the graphical Table Properties dialogs, supporting management of partitioned indexes.
  • SQLite - Improved graphical explain plan.
  • Snowflake - Compare Jobs feature can be used with Snowflake and compare Snowflake tasks and their properties across databases.
  • Snowflake - Support for latest Snowflake features, added graphical management of Database Roles and Alerts, improved Password Policy, Account management.
  • PostgreSQL - Client tools updated to the latest version 15, to support latest PostgreSQL features.
  • PostgreSQL - Performance dashboard can be now used for monitoring PostgreSQL logical replication.
  • Amazon Redshift - Graphical management of materialized views.
  • MariaDB and MySQL - Much improved query plan presentations, and yet there is more coming soon in the next release.
  • Miscellaneous:
  • A number of other minor improvements and bug fixes.

New in SoftTree SQL Assistant 12.3.427 (May 2, 2023)

  • New major features and significant enhancements:
  • Query execution plan diagrams with customizable layouts.
  • New Connection Organizer - if you deal with many databases, this is for you, to help you group and organize your database connections and to find them faster.
  • New Bookmarks pane for bookmark lovers, so you can see all visual bookmarks with text previews at a glance.
  • Document manager metadata is now stored in SQLite database instead of XML files. Searches for historical documents are now faster, and a longer document change history can be supported. Saving documents is faster too, reliving you from a need to periodically purge the documents repository folder to speed up file access.
  • Code Visualizer enhancement - Upsert operation is represented as a compound DML operation with conditional IF blocks and multiple logical operations instead of a single statement.
  • Database Modeling enhancement - multiple model diagrams for the same database can be created and stored in the same project file.
  • Application Data Lineage enhancements - syntax highlighting for all supported file types.
  • Multiple enhancements in SQL Assistant SQL Editor (Pro Edition), including new multi-row tabbed interface, sticky tabs, and more.
  • SQL Intellisense enhancements - better handling of keywords that are not reserved keywords.
  • Updated Object Explorer add-on for the latest SQL Server Management Studio version 19.0.2.
  • Database management enhancements and new features:
  • SQL Server - Query Store Explorer, and historical query performance reports with graphical query plan comparison and more.
  • Oracle - Active Session History Explorer with historical resource usage reports by application and users.
  • Oracle - Automatic Workload Repository Explorer, and historical query performance reports with graphical query plan comparison and more.
  • Oracle - Enhancements in the graphical Table Properties dialogs, supporting management of partitioned indexes.
  • SQLite - Improved graphical explain plan.
  • Snowflake - Compare Jobs feature can be used with Snowflake and compare Snowflake tasks and their properties across databases.
  • Snowflake - Support for latest Snowflake features, added graphical management of Database Roles and Alerts, improved Password Policy, Account management.
  • PostgreSQL - Client tools updated to the latest version 15, to support latest PostgreSQL features.
  • PostgreSQL - Performance dashboard can be now used for monitoring PostgreSQL logical replication.
  • Amazon Redshift - Graphical management of materialized views.
  • MariaDB and MySQL - Much improved query plan presentations, and yet there is more coming soon in the next release.
  • Miscellaneous:
  • A number of other minor improvements and bug fixes.

New in SoftTree SQL Assistant 12.2.387 (Feb 12, 2023)

  • New major features and significant enhancements:
  • The Application Data Lineage Analyzer.
  • New add-on for the latest SQL Server Management Studio version 19 (a.k.a SSMS 2022), updated in 12.2.387 for SSMS 19.0.1 release version.
  • Updated add-ons for Visual Studio 2017/2019 and 2022 supporting their latest releases.
  • An overhauled Table Info panel now featuring links to table and index statistics and usage reports.
  • And of course a bunch of new table and index scope statistics and usage reports that is now available to you.
  • Significant changes in SQL Assistant's system tray menu. Many available tools now can be launched directly and quickly right from the menu. And just a hint, if you make SQL Assistant's icon in the system tray always visible, you can access all the tools with just two clicks.
  • Multiple enhancements in SQL Assistant SQL Editor, including multiple new features for tab management, such as cloning open tabs, closing tabs to the right and left of the active tab, and more.
  • A number of SQL Intellisense enhancements for various databases including but not limited to supporting MySQL INSERT...SET... syntax, MariaDB Oracle compatibility mode, better column suggestions after SELECT DISTINCT..., and others.
  • Graphical Explain Plan for SQLite.
  • Database management enhancements and new features:
  • Snowflake - complete graphical database and schema management interface.
  • DB2 - support for updating table statistics and table reorgs right from the menus, no longer need to run command line tools manually on the server.
  • MariaDB - support for MariaDB packages.
  • SQLite - new Session Monitor for monitoring SQLite connections.
  • Miscellaneous:
  • 64-bit version of SQL Assistant Plugin Development IDE (included with v12.2.387).
  • Further enhancements for supporting SQL Assistant automatic recovery after Windows unattended updates and shutdowns.
  • A number of other minor improvements and bug fixes.

New in SoftTree SQL Assistant 12.2.381 (Dec 1, 2022)

  • New major features and significant enhancements:
  • The new Application Data Lineage can analyze your application source files and logs and identify the origin of data, observe and trace different touchpoints along the data flows in and out of the databases, and document them for you.
  • New add-on for latest SQL Server Management Studio 19 (a.k.a SSMS 2022).
  • Updated add-ons for Visual Studio 2017/2019, 2022 supporting latest Visual Studio releases.
  • Overhauled Table Info panel now featuring links to table and index scope statistics and usage reports.
  • And of course a bunch of new table and index scope statistics and usage reports.
  • Significant changes in SQL Assistant's system tray menus, many available tools can be launched directly and quickly.
  • Enhancements in SQL Assistant SQL Editor's tab management, now supporting cloning open tabs, closing tabs to the right and left of the active tab, and other new features.
  • A number of SQL Intellisense enhancements for various databases including but not limited to supporting MySQL INSERT...SET... syntax, MariaDB Oracle compatibility mode, better column suggestions after SELECT DISTINCT, and others.
  • Database management enhancements:
  • Snowflake - complete graphical database and schema management interface.
  • DB2 - support for updating table statistics and table reorgs.
  • MariaDB - support for MariaDB packages.
  • Miscellaneous:
  • Further enhancements for supporting SQL Assistant automatic recovery after Windows unattended updates and shutdowns.
  • A number of other minor improvements and bug fixes.

New in SoftTree SQL Assistant 12.0.191 (Feb 28, 2022)

  • New database systems:
  • Now supporting MongoDB with MongoDB Connector for BI.
  • New major features:
  • Full featured reporting with integrated report designer, templates and wizards, and numerous predefined administrative reports.
  • New ETL Orchestrator for automating ETL and ELT tasks, and other repetitive database processes.
  • Completely reworked Load Generator, upgraded to Database Benchmarking with ready-to-run templates for simulating real life applications and for application and database performance benchmarking.
  • New multifunctional task-oriented SQL Profiler for PostgreSQL.
  • New multifunctional task-oriented SQL Profiler for Oracle.
  • Data import and export from/to Parquet files.
  • New Oracle Table and Index Defragger.
  • New plugins for Eclipse 4.x platform, and for DBeaver 20.x.
  • New Oracle Tablespace Manager with graphical space allocation maps.
  • New universal Go To menu for quickly jumping to specific lines, bookmarks, regions, etc...
  • Significant enhancements:
  • Greatly improved intellisense for DDL commands including in place suggestions for specific objects and options, graphically selected changes, and more.
  • Support for high resolution monitors with high DPI.
  • Bootstrap queries for new database connections.
  • Many enhancements in the source code control interfaces, supporting now all recognized object types, code branching, ignore lists and filtering for insignificant and unwanted objects, new and improved advanced wizard for source control project and repository setup, and so on...
  • Source code control for TFS now supports non-English based environments. Source code control for Perforce now supports different file encodings.
  • Code Structure View is enhanced with code regions.
  • New SQLite databases can be now created directly from the Connection dialog.
  • Unit testing framework now supports all SQL Assistant recognizable object types.
  • Unit testing framework can now save unit test execution results in an unified XML format supporting multiple result sets and types of unit test outputs; enabling reading results from upstream test cases and feeding them to downstream test cases.
  • Unit testing framework now supports advanced validation of test case results using multiple new methods including custom SQL queries, Visual Basic scripting, Pascal scripting, etc...
  • Schema Compare and visual schema management tools for SQL Server and Azure now support XML indexes and Spatial indexes.
  • Asynchronous execution of Data Transfer and XML Import/Export tasks.
  • Enhanced data scripting functions with support for multi-row inserts and several other new options.
  • Enhancements for interactive code snippets, the $OBJECT$ code automation macro now supports many new types of schema objects.
  • Improved integration with MS Access, not supporting full featured popup SQL editor with code highlighting, SQL Intellisense, DB Explorer, Code Structure, and all other functions supported by SQL Assistant.
  • Improved integration with Visual Studio 2017 and 2019, now supporting scripts opened from the Server Explorer.
  • Other enhancements:
  • Compatibility changes with latest database versions.
  • Tons of other minor and not so minor improvements, too many to fit here.

New in SoftTree SQL Assistant 11.5.354 (Jan 11, 2021)

  • New Features and Major Changes
  • Productivity and Intellisense enhancements:
  • In this maintenance release we placed special focus on improving user interface and experience. Multiple "wizards" are added to help you with common tasks, to instantly find previously saved projects and settings, and so on...
  • Many graphical dialogs have been updated to seamlessly support themes. Themes can be now switched on the fly using new menus.
  • The Connection dialog is improved for aiding users working with many different database connections. The Connection dialog is now supporting filters and across the database listings.
  • SQL Intellisense enhancements - faster and more flexible selection of JOINs
  • SQL Intellisense enhancements - improved user interface and accuracy for suggestions in GROUP BY, HAVING, SORT BY, and similar SQL constructs.
  • SQL Intellisense enhancements - enhanced intellisense for Oracle object tables with and without inheritance.
  • Oracle's NLS_LENGTH_SEMANTICS parameter is now recognized; Its value may change behavior of graphical table management functions, and other SQL code generation functions.
  • New tools added to SQL Assistant toolset:
  • Data Factory - new automation utility for loading data into your databases.
  • Oracle - new graphical Performance Dashboard.
  • Other productivity enhancements:
  • Command Selector enables customizing its contents. You can choose which categories of commands and items you want to appear in the Command Selector.
  • Clone It can now be run in the background while you continue working with the development environment.
  • Test Data Generator now supports new Initialization and Finalization sections allowing custom project initialization and finalization steps executed directly from the project.
  • Load Generator now supports new Initialization and Finalization sections allowing custom project initialization and finalization steps executed directly from the project.
  • Clone It now supports cloning Oracle object tables with data.
  • SQL Editor Professional Edition now supports editing and compiling Java stored procedures.
  • MariaDB native client is installed with SQL Assistant allowing seamless connections to MariaDB servers and faster data operations.
  • SQL Editor Professional Edition now supports new Database menu containing database and schema management commands that were previously available in toolbars and various DB Explorer context menus only.
  • Database management enhancements:
  • Oracle - graphical management of XMLType Tables and columns.
  • DB2 - graphical management of database connection aliases, nodes, and databases.
  • Oracle - graphical management of DDL and LOGON triggers.
  • Oracle - management of pluggable database states, supporting starting, stopping and other common operations with PDBs.
  • Oracle - the Alert Log can be read remotely, supporting log record filtering by time, message severity, and text.
  • Miscellaneous:
  • Lots of other minor enhancements.
  • Over 20 known defects fixed.

New in SoftTree SQL Assistant 11.3.277 (Sep 10, 2020)

  • New tools added to SQL Assistant toolset:
  • SQL Server - Task-oriented SQL Profiler for SQL Server.
  • DB2 - Clone It for DB2 LUW databases and schemas.
  • Oracle - Clone It for Oracle databases and schemas.
  • Database performance monitoring and tuning:
  • DB2 - new Graphical Performance Dashboard.
  • PostgreSQL - Top SQL queries for tuning.
  • DB2 - Top SQL queries for tuning.
  • Oracle - Top SQL queries for tuning.
  • MariaDB - Top SQL queries for tuning.
  • MySQL - Top SQL queries for tuning.
  • SQL Server - Top SQL queries for tuning.
  • Azure SQL - Top SQL queries for tuning.
  • Redshift - Top SQL queries for tuning (experimental version).
  • Productivity and Intellisense enhancements:
  • SQL Intellisense enhancements - contents pf historical SQL queries section is easier to customizable, you can choose types of items to show or hide.
  • SQL Intellisense enhancements - Better intellisense for HAVING and GROUP BY clauses with automatic suggestions for multiple columns based on their references in other parts of the same query.
  • Data-grid enhancements - Columns smart auto-fit tailored to window size.
  • Data-grid enhancements - Search data history is preserved for reuse.
  • Oracle - Data-grid can now retrieve and update REF data types.
  • Load Generator - now supports Initialize and Cleanup sections for integrated preparation of the test environment.
  • Database management enhancements:
  • PostgreSQL - compatibility changes for supporting PostgreSQL version 12.
  • SQL Server - Graphical management of Linked Server profiles.
  • DB2 - Renovated graphical backup and restore interface.
  • Oracle - Enhanced Oracle graphical backup and restore interfaces now supports both RMON and DataPump based export/import.
  • Oracle - Oracle code execution, SQL Editor now supports creating Java stored procedures and compiling Java classes.
  • Oracle - Dependencies/references analysis now supports object types.
  • Oracle - graphical management of Object Type Tables
  • DB2 - Schema compare, many improvements supporting richer set of attributes and improved schema comparison results and schema synchronization.
  • Oracle - Schema compare, many improvements supporting richer set of attributes and improved schema comparison results and schema synchronization.
  • Miscellaneous:
  • Many other minor enhancements.
  • Over 30 defects fixed.

New in SoftTree SQL Assistant 11.0.25 (Jul 27, 2019)

  • New database systems:
  • Now supporting Apache Hive and Apache SparkSQL. Working with Hadoop using SQL Assistant + Hive or SparkSQL now is as simple as working with MySQL, SQL Server, and other database systems you already know well. Same kind of treatment for tables, views, SQL Intellisense, SQL commands and query execution, data import/export, schema compare, etc.. we got it all.
  • New and improved integration with other development tools:
  • Support for MySQLWorkbench v8.x.
  • Support for SQL Server Management Studio 18.x.
  • Support for Visual Studio 2019.
  • Enhanced support for Heidi SQL.
  • New and improved UI:
  • UI themes are finally here (two dark themes, Mac like theme, Soft blue) in addition to the default theme.
  • Many improvements including "recharged" SQL Editor Professional Edition.
  • Data-grids: column reorganization, dynamic data formatting, data additions to tables without primary keys and unique indexes, and more.
  • Redesigned progress of work dialogs for all kinds of batch operations with at a glance summary object processing statuses, including data imports/exports, code and data generation, load and unit testing, and so on...
  • Redesigned database connection dialog with integrated management of connection profiles.
  • Database management interfaces:
  • Extended support for managing partitioned tables including automatic no-data-loss conversions from regular tables to partitioned and back.
  • Support new features of PostgreSQL 11.
  • New graphical management interface for Amazon Redshift.
  • New graphical management interface for Pivotal Greenplum.
  • New graphical management interface for Apache Hive.
  • New graphical MySQL Scheduler management.
  • New graphical pgAgent Scheduler management.
  • New graphical DB2 workload management.
  • New graphical table type editors for SQL Server and Azure SQL.
  • Management of MariaDB temporal (system versioned) tables.
  • Performance Dashboard for SQL Server.
  • Performance Dashboard for Azure SQL.
  • Performance Dashboard for MySQL.
  • Performance Dashboard for MariaDB.
  • Index defraggers for SQL Server and Azure SQL.
  • Graphical table maintenance for PostgreSQL, Pivotal Greenplum, MySQL, and MariaDB.
  • SQL Intellisense and its dependencies:
  • New SQL Reference for MariaDB v10.
  • New SQL Reference for Apache Hive.
  • New SQL Reference for Apache SparkSQL.
  • Schema comparison engine:
  • Comparison of partitioned and external tables for all supported database system types.
  • Significantly enhanced DB2 schema compare including comparison of virtually all kinds of database objects and their attributes.
  • Data export/import, and data scripting:
  • Now supporting an array of bulk data insert methods using native connectivity, ADO.NET and ODBC interfaces for very fast data loading.
  • Enhanced data imports using INSERT commands with bind parameters for cases when build inserts cannot be used.
  • Data exports and data scripting can now be scheduled to run at predefined times.
  • Database Source Code Control:
  • Source Code Control now supports all types of database objects that can be scripted, and not just tables, views, and procedural code as in the previous versions.
  • Other enhancements:
  • Support for external and partitioned tables in DB Explorer, in graphical database management dialogs, and in the schema comparison engine.
  • Redesigned SQL Preprocessor pane - no longer requires manual activation, can be turned on and off in the options and works silently in the background just like a code preprocessor works in C/C++ development environments.
  • Oracle ADO.NET connections now support SYSDBA option.
  • Many other minor and not so minor improvements.

New in SoftTree SQL Assistant 11.0.6 Beta (Jul 1, 2019)

  • New database systems:
  • Now supporting Apache Hive and Apache SparkSQL. Working with Hadoop using SQL Assistant + Hive or SparkSQL now is as simple as working with MySQL, SQL Server, and other database system you already know well. Same kind of treatment for tables, views, SQL Intellisense, SQL commands and query execution, data import/export, schema compare, etc.. we got it all.
  • New and improved integration with other development tools:
  • Support for MySQLWorkbench v8.x.
  • Support for SQL Server Management Studio 18.x.
  • Support for Visual Studio 2019.
  • Enhanced support for Heidi SQL.
  • New and improved integration with other development tools:
  • UI themes (two dark themes, Mac like theme, Soft blue) in addition to the default theme.
  • Many improvements including "recharged" SQL Editor Professional Edition.
  • Data-grids: column reorganization, dynamic data formatting, data additions to tables without primary keys and unique indexes, and more.
  • Redesigned progress of work dialogs for all kinds of batch operations with at a glance summary object processing statuses, including data imports/exports, code and data generation, load and unit testing, and so on...
  • Redesigned database connection dialog with integrated management of connection profiles.
  • Database management interfaces
  • Extended support for managing partitioned tables including automatic no-data-loss conversions from regular tables to partitioned and back.
  • Support new features of PostgreSQL 11.
  • New graphical management interface for Amazon Redshift.
  • New graphical management interface for Pivotal Greenplum.
  • New graphical management interface for Apache Hive.
  • New graphical MySQL Scheduler management.
  • New graphical pgAgent Scheduler management.
  • New graphical DB2 workload management.
  • New graphical table type editors for SQL Server and Azure SQL.
  • Management of MariaDB temporal (system versioned) tables.
  • Performance Dashboard for SQL Server.
  • Performance Dashboard for Azure SQL.
  • Performance Dashboard for MySQL.
  • Performance Dashboard for MariaDB.
  • Index defraggers for SQL Server and Azure SQL.
  • Graphical table maintenance for PostgreSQL, Pivotal Greenplum, MySQL, and MariaDB.
  • SQL Intellisense and its dependencies:
  • New SQL Reference for MariaDB v10.
  • New SQL Reference for Apache Hive.
  • New SQL Reference for Apache SparkSQL
  • Schema comparison engine:
  • Comparison of partitioned and external tables for all supported database system types.
  • Significantly enhanced DB2 schema compare including comparison of virtually all kinds of database objects and their attributes.
  • Data export/import, and data scripting:
  • Now supporting an array of bulk data insert methods using native connectivity, ADO.NET and ODBC interfaces for very fast data loading.
  • Enhanced data imports using INSERT commands with bind parameters for cases when build inserts cannot be used.
  • Data exports and data scripting can now be scheduled to run at predefined times.
  • Database Source Code Control:
  • Source Code Control now supports all types of database objects that can be scripted, and not just tables, views, and procedural code as in the previous versions.
  • Other enhancements:
  • Support for external and partitioned tables in DB Explorer, by database management interfaces, and by the schema comparison engine.
  • Redesigned SQL Preprocessor pane - no longer requires manual activation, can be turned on and off in the options and works silently in the background just like a code preprocessor works in C/C++ development environments.
  • Oracle ADO.NET connections now support SYSDBA option.
  • Many other minor and not so minor improvements.
  • Support Forum - SQL Assistant Support Forum. This forum contains messages from people using SQL Assistant. Browse or search to find answers for your questions, and to report issues with running SQL Assistant.

New in SoftTree SQL Assistant 10.1.278 (Mar 26, 2019)

  • New Features and Major Changes:
  • Separation of MySQL and MariaDB interfaces. MariaDB is now a separate database interface supporting new connection options and new features specific to MariaDB.
  • Visual database and schema management for Amazon Redshift.
  • Visual database and schema management for Pivotal Greenplum.
  • Visual database and schema management significantly expanded for DB2, MySQL, and MariaDB.
  • Visual management and monitoring of SQL Server Service Broker.
  • New SQL Preprocessor feature.
  • New SQL References for MySQL 8.0 and MariaDB 10.3.
  • DB Explorer now supports even greater number of schema object types and their features.
  • Enhanced support for PostgreSQL 11, stored procedures support, new table options, etc...
  • A number of SQL Intellisense usability enhancements.
  • Multifaceted support for partitioned and external tables across all database interfaces.
  • Data Compare provides new methods for saving data comparison results to CSV files, copying samples of data differences for further investigations.
  • Enhanced schema compare features for DB2, Redshift, PostgreSQL, Greenplum, MySQL, and MariaDB.
  • Support for custom .NET based plugins. Several examples are prepackaged with 10,1, including NS Lookup for IP addresses in data-grids, and others.
  • Customizable data display formats can be applied now to copied and exported data.
  • The DDL Preview pane enables use of the Code Format commands to reformat the reverse-engineered code for improved readability.
  • Enhancements in SQL Editor for more customizations including custom hot keys for code folding, and others.
  • Scheduling of data export and data scripting operations for unattended runs.
  • Code Generator now supports all types of database objects and can be used to automate repetitive data and schema change operations for a greater set of tasks.
  • Miscellaneous:
  • Lots of other minor changes and enhancements.

New in SoftTree SQL Assistant 10.0.175 (Sep 20, 2018)

  • New Features and Major Changes:
  • Graphical database and schema object management for MySQL and MariaDB.
  • Graphical database and schema object management for SQL Server and Azure Database.
  • Graphical database and schema object management for PostgreSQL.
  • Graphical database and schema object management for SQLite.
  • Graphical database and schema object management for DB2 UDB.
  • New command selector (a.k.a. command palette) - the only hot key you would need to remember is the one displaying this tool, Ctrl+Shift+Space
  • New SQL Intellisense enhancements.
  • New Database Sanitizer utility for quick and easy obfuscation of production data in development environments.
  • Enhanced version of Visual Database Documenter supporting all object types and providing the complete database documentation with a click of a mouse.
  • Enhanced version of database / schema compare tools covering each and every aspect of database development.
  • Database schema comparison now supports Amazon Redshift databases.
  • New Visual Code Difference - now you can compare code version differences using code logic diagrams, not text.
  • Command line interface for data comparison tools - you can now schedule automated data comparison project runs with reports delivered by email.
  • User-defined data display formats in data grids.
  • New extensibility interface - easily develop your own extensions for SQL Assistant and for supported target environments too (SQL Server Management Studio, MySQL Workbench, Notepad++, Toad, etc...) Best of all, you don't need to know their internal working and extensibility frameworks; Your own plugins powered by SQL Assistant will work in all of the supported environments. A full featured IDE for developing plugins is included with SQL Assistant.
  • Miscellaneous:
  • Lots of other minor changes and enhancements.

New in SoftTree SQL Assistant 9.5.452 (Jan 15, 2018)

  • New Features and Major Changes:
  • 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. With just a few mouse clicks you can change ownership of many schema objects at once, change object permissions, their execution and data access modes, attributes, perform various maintenance tasks, index rebuilds, code recompilation. No more need to do it one by one, open and close many different dialogs.
  • 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.
  • User interface enhancements: hot keys for SQL Execution Plan and some other hard to reach tools.
  • Schema compare enhancements for PostgreSQL: comparison and synchronization of database attributes, tablespaces.
  • Schema compare enhancements for MySQL: comparison and synchronization of database and object permissions, table indexes, table partitions.
  • Schema compare enhancements for SQLite: comparison and synchronization of column default values, auto-increment columns, triggers, indexes, referential constraints.
  • SQL Intellisense enhancements for multiple database types: support for labels in SQL code.
  • SQL Intellisense enhancements for PostgreSQL and DB2: improved listing of overloaded functions in Intellisense popups.
  • SQL Intellisense enhancement: auto-refresh of the data dictionary cache after DDL operations can be turned off temporarily to improve performance.
  • Code formatting enhancements for statements containing UNION clause.
  • Data export enhancements: additional options for delimiters and quoting; simplified data export to XML and JSON files.
  • Data export enhancements: enhanced use of Export To... menu in DB Explorer for schema and databases, all schema tables can be exported at once to table specific export files.
  • SQL Reference enhancements for Netezza, ASA, ASE, MySQL.
  • Enhancements in Database Modeling: default values can be now entered for table columns and saved in the model, ON UPDATE and ON DELETE actions can be enteresd for referential constraints, table and column comments supproted as well.
  • New customization options provided for DDL code extraction methods.
  • New options for adding user-defined commands to SQL Assistant context menus for executing external process and passing data to other programs using files and/or clipboard.
  • Improved support for Teradata: users can now create stored procedure and macros directly from SQL Assistant SQL Editor and from other target editors.
  • Improved support for Teradata: in SQL Assistant SQL Editor database context can be changed using database name double click or database drop-down list.
  • MariaDB server versions 5.x and 10.x are now officially supported.
  • Compatibility changes for latest MySQL Workbench versions.
  • Miscellaneous:
  • Many other minor enhancements and bug fixes.

New in SoftTree SQL Assistant 9.5.444 (Dec 18, 2017)

  • New Features and Major Changes:
  • Data analytics enhancements: Instant charts for query results.
  • Multiple enhancements in the Data Compare engine including new data difference synchronization capabilities, comparison of structurally different tables, comparison of view results, and a number of other new features...
  • SQL Assistant native toolbars in SQL Server Management Studio, Visual Studio, Notepad++.
  • Tons of enhancements in the Schema Compare engine across all database interfaces with much deeper and richer comparison for many types of schema objects, with advanced comparison of various schema, database and server scope structures, files and tablespaces, security attributes and permissions, and so on...
  • IntelliSense enhancements (all databases): hints for DML operations against tables with triggers.
  • IntelliSense enhancements (all databases): SQL assistance for grouped nested JOINs.
  • IntelliSense enhancements (all databases): advanced control over alias generation including custom methods using regular expressions, casing, predefined tables of custom aliases.
  • IntelliSense enhancements (PostgreSQL and Pivotal Greenplum): support for event functions.
  • IntelliSense enhancements (PosgreSQL and Pivotal Greenplum): support for complex table aliases with renamed columns, e.g. "FROM table_reference [AS] alias(column1 [, column2 [, ...]])".
  • Data-grid enhancements: in-place toolbar for common operations.
  • New code stress-testing method added to the database Unit Testing Framework.
  • User interface enhancements: New advanced filtering capabilities in the Schema Compare results, hide and show objects and their attributes based on scope, regular expressions, and more.
  • User interface enhancements: Object References diagrams support saving to image files.
  • Code Structure View now offers better support for CTE based SQL statements.
  • SQL Reference enhancements for SQL Azure.
  • Enhancements in code execution diagnostic messages and error messages processing: display of formatted multi-line messages on mouse-over event.
  • Improvements in select "current" statement function - now supporting more types of SQL statements.
  • Context SQL Search now supports sorting results by columns.
  • Improvements in the Connect to Database dialog: customizable connection names.
  • Improvements in Oracle OCI interface: support for OCIDateTime and OCIInterval data types.
  • Code formatting: improvemed PostgreSQL operator formatting.
  • Macro scripting enhancements: $CURRENT(...)$ macro added new optiona for handling special symbols.
  • More utilities and operations can be monitored and managed now using SQL Assistant Task Manager.
  • Better support for users-defined menus and commands.
  • Multiple accross the board improvements in the data export and data transfer utilities: better user interface, improved reporting of progress of work, more responsive, etc...
  • Support for new bulk insert methods in the data-transfer utility: implementation of multi-row inserts using single INSERT operation (Oracle, SQL Server, Azure, PosgreSQL, Pivotal Greenplum, SQL Anywhere, DB2 UDB, Redshift).
  • Multiple performance improvements in internal operations making SQL Assistant perform many database operations faster.
  • Enhancements in the Database Documenter: you can now attach custom database model files and save their diagrams as part of the generated database and schema documentations.
  • SQL Assistant API now directly supports WinForms and WPF applications.
  • Miscellaneous:
  • Many other minor enhancements and bug fixes.

New in SoftTree SQL Assistant 9.2.348 (Jul 31, 2017)

  • New Features and Major Changes:
  • 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. With just a few mouse clicks you can change ownership of many schema objects at once, change object permissions, their execution and data access modes, attributes, perform various maintenance tasks, index rebuilds, code recompilation. No more need to do it one by one, open and close many different dialogs.
  • 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.
  • User interface enhancements: hot keys for SQL Execution Plan and some other hard to reach tools.
  • Schema compare enhancements for PostgreSQL: comparison and synchronization of database attributes, tablespaces.
  • Schema compare enhancements for MySQL: comparison and synchronization of database and object permissions, table indexes, table partitions.
  • Schema compare enhancements for SQLite: comparison and synchronization of column default values, auto-increment columns, triggers, indexes, referential constraints.
  • SQL Intellisense enhancements for multiple database types: support for labels in SQL code.
  • SQL Intellisense enhancements for PostgreSQL and DB2: improved listing of overloaded functions in Intellisense popups.
  • SQL Intellisense enhancement: auto-refresh of the data dictionary cache after DDL operations can be turned off temporarily to improve performance.
  • Code formatting enhancements for statements containing UNION clause.
  • Data export enhancements: additional options for delimiters and quoting; simplified data export to XML and JSON files.
  • Data export enhancements: enhanced use of Export To... menu in DB Explorer for schema and databases, all schema tables can be exported at once to table specific export files.
  • SQL Reference enhancements for Netezza, ASA, ASE, MySQL.
  • Enhancements in Database Modeling: default values can be now entered for table columns and saved in the model, ON UPDATE and ON DELETE actions can be enteresd for referential constraints, table and column comments supproted as well.
  • New customization options provided for DDL code extraction methods.
  • New options for adding user-defined commands to SQL Assistant context menus for executing external process and passing data to other programs using files and/or clipboard.
  • Improved support for Teradata: users can now create stored procedure and macros directly from SQL Assistant SQL Editor and from other target editors.
  • Improved support for Teradata: in SQL Assistant SQL Editor database context can be changed using database name double click or database drop-down list.
  • MariaDB server versions 5.x and 10.x are now officially supported.
  • Compatibility changes for latest MySQL Workbench versions.
  • Miscellaneous:
  • Many other minor enhancements and bug fixes.

New in SoftTree SQL Assistant 9.0.166 (Oct 21, 2016)

  • Support for 32-bit and 64-bit development environments, 64-bit targets, 32-bit and 64-bit database drivers and clients.
  • Full Unicode support in code, data, and files.
  • Support for 3 new data warehouse database systems: Teradata, IBM Netezza, and Pivotal Greenplum.
  • Database Modeling, Graphical Data Access Dependencies, and Data Flows.
  • New interactive SQL Reference systems for SQL Server 2014 and 2016, SQL Azure database, Teradata 14 and 15, Oracle 12c, Netezza 7, Access 2007 and 2010, PostgreSQL 9.5, and Redshift.
  • SQL Intellisense improvements including enhanced support for analytical and window functions.
  • Graphical data editing, plus Excel style auto-stats on multiple cell selection in result sets.
  • Native PostgreSQL connectivity (libPQ).
  • Enhanced SQL code execution mode using ADO.NET, native connections, and ODBC drivers supporting asynchronous printing of messages sent from stored procedures and internal database commands while they run.
  • Many database type specific enhancements, including but not limited to support of PostgreSQL materialized views, DB2 procedures with overloaded parameters, support for new data types, including intervals, execution of anonymous pgPlSQL blocks in PostgreSQL, and so on...
  • Virtual filters in Code Structure View (filter code by schema object references).
  • 32-bit and 64-bit versions of SQL Assistant Professional SQL Editor.
  • Compatibility changes for supporting latest releases of SQL Server Management Studio 2016, pgAdmin, and Toad.
  • Compatibility changes for supporting targets running in Windows 10.
  • Enhancements in Task and Reminders, Code Snippets, Options Management, and many other areas.

New in SoftTree SQL Assistant 7.5.496 (Feb 16, 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

New in SoftTree SQL Assistant 7.3.429 (Oct 15, 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 all supported database systems including cross database type data conversions.
  • 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.

New in SoftTree SQL Assistant 7.2.336 (May 28, 2015)

  • New Features and Major Changes:
  • 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.
  • Miscellaneous:
  • Tons of other minor enhancements and bug fixes.

New in SoftTree SQL Assistant 7.1 (May 28, 2015)

  • New Features and Major Changes:
  • 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...
  • 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.
  • Enhancement in code reusability and context SQL search - improved results and their navigation.
  • Auto-closing of previous execution results before running new SQL commands.
  • Convergence of name matching methods and filters in DB Explorer.
  • New hot key for custom formatting styles and on-the-fly style selection (Ctrl+Shift+F11).
  • Reordering tabs in the integrated SQL Editor.
  • Auto-formatting of code snippet processing results before inserting results into editor.
  • Improved Intellisense for DECLARE statements in T-SQL environments.
  • Improved Intellisense for temp tables in MySQL, Oracle, DB2 databases.
  • Enhancement in the integrated SQL Editor – sticky connection color easy change (double-click server name in status bar, change color).
  • Enhancement in the integrated SQL Editor – now supporting cancelation of long running operations in all types of database interfaces.
  • Compatibility changes for latest versions of pgAdmin and Toad.
  • Miscellaneous:
  • Tons of other minor enhancements and bug fixes.

New in SoftTree SQL Assistant 7.0 (May 28, 2015)

  • New Features and Major Changes:
  • 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.
  • Miscellaneous:
  • Lots of other minor changes and enhancements.

New in SoftTree SQL Assistant 7.0.133 Beta (Jul 1, 2014)

  • New solution for improving database code reusability.
  • New Professional SQL Editor - a full-featured database development environment for 10 database types.
  • New database workload generator utility for application scalability testing.
  • New database type supported – Amazon Redshift.
  • New Context SQL Search with real-time suggestions and centralized and fully indexed code repository with 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 can be used with all supported target editors and databases; even Windows Notepad can be now turned to a full featured database editor. The improved DB Explorer features a number of unique functions, including 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} to faster code entry.
  • All databases: SQL Intellisense enhancements "Name Matching Method" is now customizable at 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 info provided for temporary tables having their definition predictable in design time.
  • New command line interface and scheduling for the Data Compare utility, now comparison can be scheduled as well as integrated with Unit Tests.
  • Enhanced $OBJECT(ins_column)$ macro enables multiple columns selection.
  • Compatibility changes for Toad for SQL Server 6.1 and later – database connection sharing now supported.
  • Compatibility changes supporting latest UltraEdit v20.
  • New add-ons for Delphi XE 1-5.
  • MSSQL: support for database-level triggers.
  • MSSQL: support for custom table-type data types.
  • Interactive SQL Reference for Amazon Redshift.
  • All databases: The Source Code Control interface now supports custom data types.
  • Lots of other minor changes and enhancements.

New in SoftTree SQL Assistant 6.5.258 (Dec 3, 2013)

  • New Features and Major Changes:
  • SQL Server 2014 is now supported.
  • New 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.
  • New 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.
  • Miscellaneous:
  • Lots of other minor changes and enhancements.

New in SoftTree SQL Assistant 6.4.230 (Jul 18, 2013)

  • New Features and Major Changes:
  • Windows SQL Azure Database is now supported.
  • New Data Compare for multi-server multi-database data comparison. It can compare single tables, schemas, and entire databases. It can compare data across different types of databases too.
  • New in-database Code Search and Replace function. It can be run across multiple database and servers. All changes can be previewed and managed before altering objects in the database.
  • Several SQL Intellisense enhancements, handling of DATE data types, SQL MERGE, CREATE INDEX, and more…
  • New extensions and options for $COLUMNS$ and $OBJECTS$ macros.
  • Support for latest Toad and Notepad++ versions.
  • Miscellaneous:
  • Lots of other minor changes and enhancements.

New in SoftTree SQL Assistant 6.3.153 (Nov 5, 2012)

  • New Features and Major Changes:
  • 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.
  • Miscellaneous:
  • Lots of other minor changes and enhancements.

New in SoftTree SQL Assistant 6.2.111 (Jun 15, 2012)

  • Bulk SQL code generator, with ready to use templates for generating CRUD procedures.
  • Easy Excel data export / import to and from database.
  • Hierarchical and flat XML data export / import (Experimental feature).
  • Improved SQL Intellisense – automatic and suggested corrections for misspelled keywords, names, parameters, etc…
  • Improved SQL Intellisense – suggestions for code generating code snippets.
  • New set of add-ons for SQL Server Management Studio 2005, 2008, 2012 for SQL Assistant integration with the Database Object Explorer.
  • Updated Visual Studio 2010 add-ons extending support to VS2010 Ultimate Edition
  • Referential integrity rules checking added to dependencies analyzer and smart database refactoring methods.
  • Multi-server multi-database Code search
  • Multi-server multi-database Data search.
  • Mouse-over hints for schema and database names with statistical info and action links.
  • Support for MDX windows and queries in SQL Server Management Studio.
  • Auto-bookmarks (visual bookmarks with screenshots) from specially formatted script comments..
  • Enhancements in macro-script parameters processing, new options for getting updatable columns and key based columns..
  • Auto-highlighting performance costliest operations and steps in Query Execution Plans. .
  • DDL code reverse-engineering now supports object and column based comments.

New in SoftTree SQL Assistant 5.2.59 (Apr 5, 2011)

  • New Features and Major Changes:
  • New Schedule feature for scheduling runs of SQL code on single and multiple database systems using sequential and concurrent parallel runs.
  • Completely rebuilt and greatly enhanced Database Code Refactoring engine now supporting the following smart-refactoring methods: Rename Table or View; Rename Table or View Column; Rename Procedure or Function; Rename Procedure or Function Parameter; Rename Local Variable; Add Table Column; Drop Table Column; Add Procedure or Function Parameter; Drop Procedure or Function Parameter; Drop Procedure or Function; Drop Table or View; Extract View; Extract Procedure; Qualify Object Names.
  • Database refactoring coverage expanded from 3 to 8 different database system types.
  • Lots of enhancements in database refactoring methods, including updating Oracle synonyms when renaming based objects; column renaming in 'return table' in table functions in SQL Server, and many others.
  • Code formatter and beautifier now supports space alignment for assignment operators.
  • Code dependencies engine now supports analysis of code dependencies for procedure and function parameters.
  • Code execution facility now reports specific compilation error details when executing code in Oracle targets.
  • Support added for new PostgreSQL 9.0 database server.
  • Column hints on mouse-over and super-fast column scope data previews on Ctrl+click.
  • Intellisense for SET statement in SQL Server, Sybase ASE, MySQL.
  • Support for new data types introduced in SQL Server 2008 R2.
  • Hot-track for script variables, hints and 1-click jump to declarations.
  • 1 key-press highlighting of the current statement.
  • Intelligent on-the-spot web searching for solutions helping to solve specific database, syntax, and compilation errors.
  • Miscellaneous:
  • Many other minor enhancements and usability changes.

New in SoftTree SQL Assistant 5.1 (Apr 5, 2011)

  • New and Updated Add-ons and Plug-ins:
  • New Visual Studio 2010 native add-on
  • New MySQL Workbench plug-in
  • New IBM Data Studio plug-in
  • Support for latest versions of Toad, PL/SQL Developer, UltraEdit, Notepad++
  • Connectivity Enhancements:
  • Support for ADO.NET 4
  • Support for MySQL ODBC drivers from 5.1.x code branch
  • Support for large text value data types, such as Oracle clobs and longs, DB2 blobs, MySQL texts, SQL Server texts, and all types of varchar(max)/nvarchar(max)
  • SQL Intellisense Enhancements:
  • Highlighting of matching Column/Value pairs in INSERT type queries, prompts for values
  • New option for controlling number of auto-expanded levels in JOIN suggestions
  • Support for multiple foreign keys between the same pair of tables in JOIN suggestions
  • SQL Server - support for Windows user logins not associated with any schema
  • Enhanced code generation for UPDATE and INSERT statements containing references to system generated values
  • Miscellaneous:
  • SQL Reference - enhanced in-place code entry using placeholders
  • Code compare - updated interface, new advanced text comparison algorithms supporting fine-grade difference highlighting within matching lines; navigation maps; additional customization options
  • Code formatting - support for decimal numbers in scientific notation
  • Data retrieval - support for long text values and their enhanced display in result sets, including multi-line text values
  • Auto-closure of displayed prompts after use of Ctrl+V shortcut
  • Fast reloading of SQL Assistant in target editors after settings changes; faster loading on startup
  • Over 100 bug fixes and minor improvements

New in SoftTree SQL Assistant 5.0 (Apr 5, 2011)

  • New Code Analysis and Refactoring Functions - smart object, column, and parameter renaming methods; smart code extraction methods; advanced code dependencies analysis
  • Graphical analysis of dependencies for objects (tables, views, procedures, functions), table and view columns, procedure and function parameters.
  • Code refactoring - Extract View definition from procedural code - 3 clicks method for conversion of a block of code to a view - customizable templates.
  • Code refactoring - Extract sub procedure definition from procedural code - 3 clicks method for conversion of a block of code to a stored procedure or function - customizable templates.
  • Code refactoring - Rename procedure/function in database including automatic discovery of dependencies, code preview before updating, including all dependencies.
  • Code refactoring - Rename table/view in database including automatic discovery of dependencies, code preview before updating, including all dependencies.
  • Code refactoring - Rename table/view column view in database including automatic discovery of dependencies, code preview before updating, including all dependencies.
  • Code refactoring - Rename procedure/function parameter in database including automatic discovery of dependencies, code preview before updating, including all dependencies.
  • Code refactoring - rename local variable - rename local variables in procedures and functions (standalone code loaded in the editor or part of a large script).
  • Syntax checker improvements - highlighting for unused variables.
  • Advanced Code Entry Automation - updated code snippets engine, programmable code snippets using SQL language
  • Support for user-defined interactive prompts. See new $PROMPT$ macro .
  • User-defined programmable macros using SQL code. See new $$..$$ and accompanying macros $CURRENT_NAME$, $CURRENT_SEL$, etc... .
  • Removed certain limitations on the use of functionally similar macros in the same snippet code. For example, $COLUMNS$ and $COLUMNS_KEYS$ macros can be now used in the same code snippet.
  • Improved SQL Intellisense and Code Formatting
  • Improved keyword prompts - preferred keywords and SQL constructs displayed on top of the keyword prompts. You can now customize preferred keywords list to match your preferences.
  • Column popups after ORDER BY and GROUP BY keywords are now feature checkboxes. Multiple columns can be picked at once.
  • While-you-type and standalone code formatters support new formatting options allowing simultaneous use of different cases for keywords and for system functions, for example uppercasing keywords and using mixed or lower case for system functions.
  • New options for handling name delimiters. "Always Add Delimiters" option supports new mode "Only if name = keyword (limited)" You can now customize list of keywords that you also use as object and column names, and which you don't want SQL Assistant to treat as keywords, for example, the default configuration includes ID and Name, names, you can add your own.
  • "Show Keys and Indexed Columns" is preset for all assistance types by default. Primary keys, foreign keys, and indexed columns are displayed by default in column popups and mouse-over hints.
  • Mouse-over hints for table and view columns display hyperlinks for sample data preview and for DDL code view for views. .
  • Mouse-over hints for procedure and function parameters display hyperlinks for procedure/function DDL code view.
  • Improved display of column name popups for PostgreSQL. The popups now indicate auto-generated values and indexed columns.
  • Improved recognition of auto-generated values in various SQL statements. For example, SQL Assistant does not insert references to "timestamp" columns in SQL server when generating code for table INSERT and UPDATE statements.
  • Improved control of column name popups. You can now configure additional symbols that trigger automatic column name popups, for example, you may add , BETWEEN and other symbols to trigger automatic column popup display.
  • SQL Intellisense implemented for CREATE INDEX statement.
  • SQL Intellisense implemented for CREATE OR REPLACE AND COMPILE JAVA SOURCE.
  • Preset code formatting rule added for Oracle VARRAY.
  • Preset code formatting rule added for DEFAULT VALUES in INSERT/UPDATE statements in Transact-SQL.
  • Database name and schema name completion is now supported after Ctrl+Space. That is handy if you work with long names and need to type them often.
  • Behavior change for query suggestions based on code entry history. To avoid accidental insertion of historical queries into the code, historical items are not pre-selected automatically. .
  • Added new option for controlling alias generation. You can now specify name prefixes that you want SQL Assistant to ignore.
  • Database Code Unit Testing Framework:
  • New complete database code unit testing framework supports interactive and automated database code unit testing; allows quick bulk setup of unit tests for multiple database projects.
  • New Add-ons:
  • Add-ons for Delphi with built-in SQL Editor. Add-ons are available for all Delphi Windows versions from Delphi 2005 to Delphi 2010;.
  • Experimental support for pre-release version of Visual Studio 2010 ( limited testing performed on Windows XP and Vista).
  • Data Import/Export/Generation:
  • New test data generator for quickly populating tables and schemas with realistic test data. Supports updates of multiple tables in one project.
  • Enhanced scripting and exporting table data now this feature supports exporting data from multiple tables and views, as well as from multiple schemas.
  • Miscellaneous:
  • Syntax Check Results and Messages panes support copying and saving messages.
  • New user-friendly interface for protecting from run-away queries and results.
  • Added handling for XML windows in SQL Server Management Studio. SQL Intellisense is disabled in XML windows.
  • Improved SEH (Structure Exception Handler) for better code quality and support.
  • Added new API functions, including new function for off-line code formatting, with support for multiple files.

New in SoftTree SQL Assistant 4.6.12 (Mar 16, 2009)

  • New Visual Bookmarks feature revolutionizes usage of code bookmarks, transforming this obscure and rarely used function available in many code editors into one that you will love and use often.
  • Code Structure View and Code Bird's View are now sticky and can be set to open automatically in every editor window of chosen targets.
  • Mouse-over hints for procedure and function parameters, for table and view columns for objects whose names contain spaces and special symbols.
  • Search capabilities added to SQL Reference.
  • Smart handling of Home/End keys for improved coding productivity.
  • Support for global variables and built-in functions in Sybase ASE and Sybase ASA.
  • Automatic end-of-line text conversion from Unix to Windows conventions when copying database code from the Procedural Code View.
  • Support for executing very large SQL files.
  • Scrollable mouse-over hints for tables with lots of columns and procedures with lots of parameters.
  • Support for SQLCMD scripts in SQL Server 2008.
  • Other minor enhancements and usability changes.

New in SoftTree SQL Assistant 4.0.34 (Nov 30, 2008)

  • Enhanced 4th-generation SQL IntelliSense+ functionality, now supporting intelligent keyword suggestions, package variables, and more.
  • New real-time syntax checker automatically highlights syntax errors, incorrect object and column names, undeclared variables etc...
  • Rebuild SQL Formatter – industry's most advanced SQL, T-SQL, PL/SQL, MySQL, … code formatter and beautifier supports multiple code layout and formatting styles, provides great extensibility, and code layout customization features.
  • Multi-server SQL script execution function allows one-click code execution on multiple servers.
  • Support for Postgre SQL.
  • Support for DB2 for iSeries.
  • Updated SQL References for Oracle 11g and DB2 9.5
  • New manual and self-check for updates feature with automatic downloading and installation of new versions, by default set to weekly schedule.
  • New _WOW_ code snippets for SQL Server and MySQL. Do not miss them, try them as soon as you get this upgrade!
  • New preconfigured targets for pgAdmin III.
  • New preconfigured targets for PowerBuilder.
  • New preconfigured targets for "Express" versions of Visual Studio 2008.
  • Targets for Visual Studio 2005/2008 enhanced to activate SQL Assistant only in files with .SQL and .DDL extensions and in the SQL query builder window.
  • Updated "Objects (MSSQL)" query now supports INFORMATION_SCHEMA in SQL Server 2005/2008 systems.
  • Filters tightened for Toad based targets to eliminate popups in inappropriate places.
  • SQL Assistant's configuration files moved to user's Application Data folder to simplify installation and use via Remote Desktop and on Windows Vista systems..
  • Numerous other minor enhancements and usability changes.