SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
SQL Assistant 9.5.469 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.5.469 is now available!
Author Message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7838

Post SQL Assistant 9.5.469 is now available! Reply with quote
Build 9.5.444 is now available for download. This is a very significant maintenance release with new major features and enhancements.

Here is a list of new features and changes:

    1. Data analytics enhancements: Instant charts for query results.
    2. 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...
    3. SQL Assistant native toolbars in SQL Server Management Studio, Visual Studio, Notepad++.
    4. 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...
    5. IntelliSense enhancements (all databases): hints for DML operations against tables with triggers.
    6. IntelliSense enhancements (all databases): SQL assistance for grouped nested JOINs.
    7. IntelliSense enhancements (all databases): advanced control over alias generation including custom methods using regular expressions, casing, predefined tables of custom aliases.
    8. IntelliSense enhancements (PostgreSQL and Pivotal Greenplum): support for event functions.
    9. IntelliSense enhancements (PosgreSQL and Pivotal Greenplum): support for complex table aliases with renamed columns, e.g. "FROM table_reference [AS] alias(column1 [, column2 [, ...]])".
    10. Data-grid enhancements: in-place toolbar for common operations.
    11. New code stress-testing method added to the database Unit Testing Framework.
    12. 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.
    13. User interface enhancements: Object References diagrams support saving to image files.
    14. Code Structure View now offers better support for CTE based SQL statements.
    15. SQL Reference enhancements for SQL Azure.
    16. Enhancements in code execution diagnostic messages and error messages processing: display of formatted multi-line messages on mouse-over event.
    17. Improvements in select "current" statement function: now supporting more types of SQL statements.
    18. Context SQL Search now supports sorting results by columns.
    19. Improvements in the Connect to Database dialog: customizable connection names.
    20. Improvements in Oracle OCI interface: support for OCIDateTime and OCIInterval data types.
    21. Code formatting: improvemed PostgreSQL operator formatting.
    22. Macro scripting enhancements: $CURRENT(...)$ macro added new optiona for handling special symbols.
    23. More utilities and operations can be monitored and managed now using SQL Assistant Task Manager.
    24. Better support for users-defined menus and commands.
    25. Multiple accross the board improvements in the data export and data transfer utilities.
    26. 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).
    27. Multiple performance improvements in internal operations making SQL Assistant perform many database operations faster.
    28. Enhancements in the Database Documenter: you can now attach custom database model files and save their diagrams as part of the generated documentations.
    29. SQL Assistant API now directly supports WinForms and WPF applications.



Last edited by SysOp on Wed Aug 22, 2018 1:12 am; edited 3 times in total
Mon Dec 18, 2017 3:22 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7838

Post Re: SQL Assistant 9.5.452 is now available! Reply with quote
Build 9.5.452 was released today. This is is a consolidated bug fix release containing fixes for functional regressions reported in previous 9.5.x builds.
Mon Jan 15, 2018 3:24 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7838

Post SQL Assistant 9.5.469 is now available! Reply with quote
Build 9.5.469 was released yesterday. This is is a consolidated bug fix release containing the following fixes

SA0033354 - Import from Excel: integer values can change to random numbers.
SA0033310 - Cloned connections don't always work correctly.
SA0033327 - $$...$$ macro usage with SQL Server environments, in certain cases may trigger multiple executions of the same macro.
SA0033398 - Schema compare raises silent Out of Memory exception and stop when processing large databases with many MBytes of procedural code.
SA0033396 - Code-generator generates full multi-part names with repeating parts in templates where only simple one-part names are expected.
SA0033407 - Snippets Engine - processing may fail if the editor tab with the source connection is closed.
SA0033434 - Schema Compare templates for PostgreSQL, Amazon Redshift, and Pivotal Greenplum: "Column Convert" template uses wrong quoting symbols.
SA0033413 - Schema Compare for SQL Server: system generated constraint names may distort schema compare results.
SA0033483 - Task Manager and Query Execution dialogs/panes don't refresh task progress and details of new tasks started.
Fri Apr 13, 2018 1:43 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.