We are excited to announce v9.0 beta 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.

To download the beta version, click this link, review the beta testing agreement and then click the Download link

Last edited by SysOp on Fri Oct 28, 2016 12:11 am; edited 4 times in total

Sat Sep 17, 2016 10:36 pm

ch21st

Joined: 19 Sep 2016Posts: 2Country: United States

BETA 9 is violation with office 2016

If I start sql assistant 9.0.144, When open EXCEL 2016 or Access 2016 or Notepad, I will get the following error message:
---------------------------
Application Error
---------------------------
Exception EAccessViolation in module SqlAssist64.dll at 000000000011B97A.

Please report each issue in a separate post so that we tack them and follow up.

Mon Sep 19, 2016 8:02 am

SysOpSite Admin

Joined: 26 Nov 2006Posts: 6579

Could you please email a copy of your SQLAssist.log file from %APPDATa%\SQL Assistant\9.0 folder to support? The log file may have important details that can help identity the cause of the issue.

Mon Sep 19, 2016 8:05 am

ch21st

Joined: 19 Sep 2016Posts: 2Country: United States

SysOp wrote:

Please report each issue in a separate post so that we tack them and follow up.

Sorry, I want to remove it after post, but I can not find delete action link.

I already sent to error log to your support mail.

Thu Sep 22, 2016 9:03 pm

SysOpSite Admin

Joined: 26 Nov 2006Posts: 6579

thank you very much for the log. We will certainly look into that. I think the issue is related to running SQL assistant on Windows 10 64-bit with 64-bit apps. We are working on that, hope to have a fix soon.

Fri Sep 23, 2016 9:57 am

SysOpSite Admin

Joined: 26 Nov 2006Posts: 6579

Build 9.0.151 is now available. Among other fixes it contains fixes for handling 64-bit targets on Windows 10 systems. Crashes should no longer occur.

Tue Sep 27, 2016 12:26 am

gemisigo

Joined: 11 Mar 2010Posts: 1428

SysOp wrote:

Build 9.0.151 is now available.

While the downloaded file says it is v 9.0.151 indeed, the page still shows 9.0.144 as being the last version.

We have several people here that are excited about prospect of using SQL Assistant to work on Netezza. However, my first attempt I got an error trying to connect to Netezza instances that I did not have access to one of the system databases.

Our DBAs seem to have resolved that initial issue, but when I connect now I don't see any objects in the Explorer pane. DBAs want to know what else I may need access to - like system views, system tables, rights, etc in order to get schema details from our instances. Do you have any documentation specific to Netezza connections and using SQL Assistant with it?

Last edited by GeneW on Wed Oct 05, 2016 8:18 pm; edited 1 time in total

Wed Oct 05, 2016 7:10 pm

SysOpSite Admin

Joined: 26 Nov 2006Posts: 6579

Please have a look at database queries used with Netezza. They are all in the Options and customizable if needed. Look for DB Queries section on DB Options tab. To make it easier, in the Options dialog set a filter for Netezza, see the filter drop-down at the bottom of the dialog.

Wed Oct 05, 2016 7:23 pm

SysOpSite Admin

Joined: 26 Nov 2006Posts: 6579

What I meant is that in the queries you can find out all referenced database catalog objects and figure out what permissions you would need.

Wed Oct 05, 2016 7:27 pm

GeneW

Joined: 10 Apr 2012Posts: 18Country: United States

Thanks - I see what you are referring to and it looks like that will provide enough details to get going.