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


New Features and Major Changes
  1. Separation of MySQL and MariaDB interfaces. MariaDB is now a separate database interface supporting new connection options and new features specific to MariaDB.
  2. Visual database and schema management for Amazon Redshift.
  3. Visual database and schema management for Pivotal Greenplum.
  4. Visual database and schema management significantly expanded for DB2, MySQL, and MariaDB.
  5. Visual management and monitoring of SQL Server Service Broker.
  6. New SQL Preprocessor feature.
  7. New SQL References for MySQL 8.0 and MariaDB 10.3.
  8. DB Explorer now supports even greater number of schema object types and their features.
  9. Enhanced support for PostgreSQL 11, stored procedures support, new table options, etc...
  10. A number of SQL Intellisense usability enhancements.
  11. Multifaceted support for partitioned and external tables across all database interfaces.
  12. Data Compare - new ways of saving data comparison results to CSV files, copying samples of different data.
  13. Enhanced schema compare features for DB2, Redshift, PostgreSQL, Greenplum, MySQL, and MariaDB.
  14. Support for custom .NET based plugins. Several examples are prepackaged with 10,1, including NS Lookup for IP addresses in data, and others.
  15. Customizable data display formats can now be applied to copied and exported data.
  16. The DDL Preview pane now enables using the Code Format command to reformat the displayed code for improved readability.
  17. Enhancements in SQL Editor for more customizations including custom hot keys for code folding, and others.
  18. Data export and data scripting can be scheduled now for unattended runs.
  19. 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
  1. Lots of other minor changes and enhancements.

 

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


New Features and Major Changes
  1. Visual database and schema object management for MySQL and MariaDB.
  2. Visual database and schema object management for SQL Server and Azure Database.
  3. Visual database and schema object management for PostgreSQL.
  4. Visual database and schema object management for SQLite.
  5. Visual database and schema object management for DB2 UDB.
  6. 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
  7. New SQL Intellisense enhancements.
  8. New Database Sanitizer utility for quick and easy obfuscation of production data in development environments.
  9. Enhanced version of Visual Database Documenter supporting all object types and providing the complete database documentation with a click of a mouse.
  10. Enhanced version of database / schema compare tools covering each and every aspect of database development.
  11. Database schema comparison now supports Amazon Redshift databases.
  12. New Visual Code Difference - now you can compare code version differences using code logic diagrams, not text.
  13. Command line interface for data comparison tools - you can now schedule automated data comparison project runs with reports delivered by email.
  14. User-defined data display formats in data grids.
  15. 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
  1. Lots of other minor changes and enhancements.

 

Changes in Other Versions

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

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

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.