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


Joined: 26 Nov 2006
Posts: 7839

Post SQL Assistant 9.0 is now available! Reply with quote
Build 9.0.162 is now available for download.

We are excited to announce v9.0 RTM version availability. That's correct, we mean version 9, not 8. This is one of the most significant releases in the entire SQL Assistant history. There are so many big changes that we've decided to skip number 8.

Here is a list of major new features:
1. Support for 32-bit and 64-bit development environments, 64-bit target editors, 32-bit and 64-bit database drivers and clients. All of that is packaged together and delivered by a single installation program.
2. Full support of Unicode in code, data, and files.
3. Support for 3 new data warehouse database systems: Teradata, IBM Netezza, and Pivotal Greenplum.
4. Database Modeling
5. Graphical Data Access and Code Dependencies, as well as Data Flows.
6. 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.
7. Significant SQL Intellisense improvements including enhanced support for analytical and window functions.
8. Native PostgreSQL connectivity (libPQ).
9. Enhanced SQL code execution mode using ADO.NET and native connections supporting asynchronous printing of message sent from stored procedures and internal database commands while they run.
9. Graphical data editing plus Excel style auto-stats on multiple cell selection in result sets.
10. Many database type specific enhancements, including but not limited to support of PosgreSQL materialized views, DB2 procedures with overloaded parameters, support for new data types, including intervals, execution of anonymous PL/pgSQL blocks in PosgreSQL, processing of COPY command in PostgreSQL scripts, and so on...
11. Virtual filters in Code Structure View (filter code by schema object references), this is a life saver for anyone working with complex procedures and deployment scripts.
12. Enhancements in Task and Reminders.
13. Enhancements in Code automation Snippets with new options and extensions in macro variables.
14. Enhanced management of SQL Assistant options with across the board filters by database type.
15. Multi-database Update Statistics and table space management functions.
16. 32-bit and 64-bit versions of SQL Assistant Professional SQL Editor.
17. Compatibility changes for supporting latest releases of SQL Server Management Studio 2016, pgAdmin and Toad.
18. Compatibility changes for supporting Windows 10.
19. Enhancements in the Data Transfer tools - many new data type mappings added for enhanced cross-platform support.
20. Lots of other minor changes and enhancements.


Last edited by SysOp on Fri Sep 01, 2017 5:12 pm; edited 1 time in total
Mon Oct 10, 2016 7:54 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7839

Post Reply with quote
Build 9.0.176 is now available for download. . This is a bug fix release, which also contains several minor enhancements.
Fri Oct 28, 2016 12:14 am View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 2102

Post [SA 9.0.176 Pro] - DB Connections Reply with quote
After upgrading to SA 9.0.176 a new setting appeared for connections in SqlAssist.sas. It's called appPlatform and its value is set to 0.

There's also another setting for targets called hotRefreshCache set to 00. Is that the hotkey for refreshing cache? Why is it set to 00? Does 00 mean that it is left at default?

Could you tell us what those are that for and what their values mean?
Fri Oct 28, 2016 4:45 am View user's profile Send private message
Mindflux



Joined: 25 May 2013
Posts: 807
Country: United States

Post Reply with quote
9.0.176 still has a protected help document.

Can't copy/paste stuff out of it.
Fri Oct 28, 2016 9:39 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7839

Post Reply with quote
Mindflux wrote:
9.0.176 still has a protected help document.

Can't copy/paste stuff out of it.


I can promise that will be fixed at some point, but I cannot say exactly when. It's in the queue. We are still working on some updates in the User's Guide.
Fri Oct 28, 2016 10:05 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7839

Post Reply with quote
Build 9.0.185 is now available for download. This is a bug fix release, it contains multiple bug fixes and several minor enhancements.
Mon Nov 21, 2016 1:49 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7839

Post Reply with quote
Here is a list of changes in builds from 9.0.177 to 9.0.185


#SA0008754 – Auto-Select First List Item option – pre-selects historical queries when no other items available. Ticket reopened.
#SA0029042 – New custom icons and actions in data-flow diagrams.
#SA0029986 – Test data generator – Save Script action may cause access violation exception.
#SA0027214 – Data transfer – process cannot be stopped.
#SA0029964 – Invalid license error when opening SQL files from Windows Explorer (Win 10).
#SA0029998 – Tasks and Reminders, add database object dialog is empty.
#SA0029967 – Corrupted configuration files after upgrade from previous version.
#SA0029997 – After closing SQL Editor, saScan process continues running.
#SA0030002 – Incorrect handling of list items having hide and show state and non-default name matching method.
#SA0030003 – SQL History pane shows only last 8 executed statements.
#SA0030056 – PG native driver, negative integer numbers converted to zeros.
#SA0030091 – Data-grid, stats balloon sometimes remains on screen after pane is closed.
#SA0030082 – SQL Intellisense incorrect handling of some types of historical statements, "INSERT INTO INTO" case.
#SA0030076 – SQL Intellisense for stored procedures and "Always add brackets" - extra brackets around parameters.
#SA0030089 - Customized SQL Assistant menu doesn't display correctly in SQL Editor.
#SA0029978 – MSSQL, Database Explore shows duplicate key columns for tables with same name foreign keys.
#SA0029784 – Git source compare doesn't highlight all differences.
#SA0029912 - SQL Editor, text change map colors in the left gutter.
#SA0029711 – MSSQL, both ADO and ODBC interfaces, Messages pane doesn't show number of rows affected for all executed SQL statement.
#SA0030115 - Multi-server manager: versioned queries loading does not work correctly.
#SA0030116 - Multi-server data search - painting text cells with found substrings is not always correct.
#SA0030023 - SQL Editor 64-bit creates its own separate MRT file.
#SA0030021 – PG, incorrect escape characters in scripted Unicode data.
#SA0030131 – PG, Exceptions while executing code.
#SA0030135 – Exception when loading recently opened file into an empty disconnected editor in SAL Editor.
#SA0030014 – Data flow diagrams, Paste menu is always disabled.
#SA0030041 - Word "(Current)" is saved as part of the connection name.
#SA0030132 – Excessive Automatic Cache Refresh, optimization for temp tables.
#SA0030146 – PG, SQL Intellisense prompt for functions, selecting function with 1 parameter inserts extra comma.
#SA0030144 - Old Procedure text cached and cannot be refreshed.
#SA0030012 – Data flow diagrams, resizing and rotation work incorrectly for some toolbox items.
#SA0030151 – PG, native interface, "name" data type processed incorrectly.
#SA0030153 – SQL Editor 64-bit, exception after repetitive opening and closing of SCS Repository Browser.
#SA0030005 – Exception after closing SCS project, leading to unstable behavior of Repository Browser.
#SA0030157 – Data transfer, Exceptions when picking schema after connection change, if there is at least one disabled connection.
#SA0030178 – Significant memory leak in Test Data Generator 32-bit, when connected to PG using ODBC drivers.
Wed Nov 23, 2016 2:53 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7839

Post Reply with quote
Build 9.0.194 is now available for download. This is a bug fix release, it contains multiple bug fixes and several minor enhancements.
Fri Dec 02, 2016 1:48 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7839

Post Reply with quote
Here is a list of changes in builds from 9.0.186 to 9.0.194


#SA0029609 - Data-grid for simple SELECT statements, Edit mode is not accessible.
#SA0030187 - SSMS 2016 latest builds, No mouse over balloons for syntax errors highlighted with wavy red lines.
#SA0030186 - SSMS 2016 latest builds, Native Intellisense is active, interferes with SQL Assistant's Intellisense.
#SA0029863 - Exception may occur in Source code Control Project during synchronizing workspace and repository folders.
#SA0030196 - Database modeling, diagram may disappear after Undo operation.
#SA0030204 - SQL Editor, enhancement, summary code execution time shown in seconds, or minutes:seconds format if exceeds more than 2 minutes for short and long runs.
#SA0030201 - Database modeling, Export command doesn't prompt when overwriting existing files.
#SA0030206 - Database modeling, Export to PDF, image transparency is lost.
#SA0030171 - SQL Editor may freeze on opening binary files.
#SA0030203 - Database modeling, after changing diagram scope options, customized objects loose their customized sizes, colors, and other attributes reverting to default theme attributes
#SA0030197 - Database modeling, Undo and Redo operations don't support standard hotkeys.
#SA0030211 - Database modeling, Exception may occur during diagram changes
#SA0030213 - Database modeling, Adding a procedure to the diagram and immediately renaming it triggers internal exception.
#SA0030199 - Database modeling, doesn't save customized line colors permanently in the diagram file.
#SA0030198 - SQL Editor 64-bit, crash when searching PG schema and "use system tables" option is unchecked.
#SA0030209 - PG native interface, catalog queries not processed correctly in databases with very large OID identifiers.
#SA0029711 - MSSQL ADO interface, Messages pane doesn't show number of rows affected after code execution.
#SA0030224 - "Reset menu" in the Options dialog doesn't work correctly.
#SA0030093 - Database Source Code Control, incorrect check for Git version installed.
#SA0030220 - New SQL References for PG versions 9.2, 9.3, and 9.4.
#SA0030009 - New SQL Reference for SAP SQL Anywhere version 16.
#SA0030227 - PG Native: support for row-by-row fetch
#SA0030090 - PG native interface, cannot retrieve large result set in 64-bit SQL Editor.
#SA0030191 - PG ODBC - big data fetch, incorrect handling of out of memory scenarios.
#SA0030241 - MySQL native interface doesn't work correctly after changes in build 9.0.174.
#SA0030165 - Execute Code (Multi-server), "Single File Output" parameter is ignored.
#SA0030163 - PG, Schema Compare, missing important comparison attributes for functions, including "Volatility", "Security of definer", "Returns NULL on NULL input", "Returns Set", and some other.
#SA0030042 - PG, Schema Compare results show incorrect schema comments.
#SA0030247 - SQL Editor, SSMS, Edit procedure command in Database Explorer and Object Navigator, opened tab with procedure code has initial changed state.
#SA0030233 - SQL Editor 64-bit, Windows 10, SQL Assistant menu not appearing in right-click menu.
#SA0030246 - SQL Editor, An exception may be from on connection dialog resizing.
#SA0030245 - Code Dependencies Diagram, Undo function may corrupt the diagram.
#SA0030016 - Database modeling - ERD and data-flow diagrams print outs have no headers and page numbers.
#SA0030262 - Database Modeling - new options in Page Setup, new macro variables for use in headers and footers.
#SA0030279 - Test Data Generator, value range check error
#SA0029868 - Test Data Generator, an exception may be thrown in data preview.
#SA0030154 - SQL Assistant's configuration file may grow very big,
#SA0030285 - Transfer Data dialog, exception on editing "Destination Name" column.
#SA0030017 - Transfer Data and Import XML data dialogs, enhancement, table overlay icons shown for incompatible tables, for mismatching columns, for new tables.
#SA0030284 - XML Import, may throw error "failed to create table."
#SA0030031 - Invoking Export and some other commands from Database Explorer in a tab with active running queries causes freezing of the UI until the running queries complete. Now warning is shown after 15 seconds of wait and no freezing.
Fri Dec 02, 2016 1:49 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.