SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
SQL Assistant 9.2 is now available!

 
This topic is locked: you cannot edit posts or make replies.    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
SQL Assistant 9.2 is now available!
Author Message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7839

Post SQL Assistant 9.2 is now available! Reply with quote
Build 9.2.348 is now available for download. This is a very significant maintenance release with several new major features.

Here is a list of new features and changes:

    1. New Data-pivot and Analytics.
    2. New experimental Code Visualizer for generating graphical code flow and sequence diagrams for procedural schema objects, views, and other SQL code.
    3. New experimental Visual Database Documenter is a graphical documentation generator for schemas and databases.
    4. 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.
    5. New database refactoring method for renaming schemas supporting SQL Server, Oracle, MySQL, PostgreSQL, DB2 UDB, Redshift, Netezza.
    6. New Tab Manager for tab management and faster code navigation
    7. User interface enhancements: name filters are now available in all tools featuring schema object trees.
    8. User interface enhancements: hot keys for SQL Execution Plan and some other hard to reach tools.
    9. Schema compare enhancements for PostgreSQL: comparison and synchronization of database attributes, tablespaces.
    10. Schema compare enhancements for MySQL: comparison and synchronization of database and object permissions, table index, table partitions.
    11. Schema compare enhancements for SQLite: comparison and synchronization of column default values, auto-increment columns, triggers, indexes, referential constraints.
    12. SQL Intellisense enhancements for multiple database types: support for labels in SQL code.
    13. SQL Intellisense enhancements for PostgreSQL and DB2: improved listing of overloaded functions in Intellisense popups.
    14. SQL Intellisense enhancement: auto-refresh of the data dictionary cache after DDL operations can be turned off temporarily to improve performance.
    15. Code formatting enhancements for statements containing UNION clause.
    16. Data export enhancements: additional options for delimiters and quoting; simplified data export to XML and JSON files.
    17. 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.
    18. SQL Reference enhancements for Netezza, ASA, ASE, MySQL.
    19. 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 supported as well.
    20. New customization options provided for DDL code extraction methods .
    21. Added 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.
    22. Improved support for Teradata: users can now create stored procedure and macros directly from SQL Assistant SQL Editor and from other target editors.
    23. Improved support for Teradata: in SQL Assistant SQL Editor database context can be changed using database name double click or database drop-down list.
    24. MariaDB server versins 5.x and 10.x are now officially supported.
    25. Compatibility changes for latest MySQL Workbench versions.
    26. Lots of other minor changes and enhancements.

Sun Jul 30, 2017 10:55 am View user's profile Send private message
Display posts from previous:    
This topic is locked: you cannot edit posts or make replies.    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.