Author |
Message |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7850
|
|
SQL Assistant 9.0 Beta Version |
|
Build 9.0.144 is now available for testing
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 |
|
![](templates/GreenTech/images/spacer.gif) |
ch21st
Joined: 19 Sep 2016 Posts: 2 Country: 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.
Access violation at address 000000000819B97A in module 'SqlAssist64.dll'. Read of address 00000000C7601BE0.
---------------------------
OK
---------------------------
the error system log is :
Log Name: Application
Source: Application Error
Date: 16/9/19 下午5:50:08
Event ID: 1000
Task Category: (100)
Level: Error
Keywords: Classic
User: N/A
Computer: xxxx
Description:
Faulting application name: EXCEL.EXE, version: 16.0.4432.1003, time stamp: 0x57cab06e
Faulting module name: KERNELBASE.dll, version: 10.0.14915.1000, time stamp: 0x57c125ca
Exception code: 0x0eedfade
Fault offset: 0x000000000004b3c8
Faulting process id: 0x197c
Faulting application start time: 0x01d2125b31c67e34
Faulting application path: C:\Program Files\Microsoft Office\Office16\EXCEL.EXE
Faulting module path: C:\WINDOWS\System32\KERNELBASE.dll
Report Id: 97b8855f-9149-4bf6-a9ad-aaa8d893622c
Faulting package full name:
Faulting package-relative application ID:
Event Xml:
<Event>
<System>
<Provider>
<EventID>1000</EventID>
<Level>2</Level>
<Task>100</Task>
<Keywords>0x80000000000000</Keywords>
<TimeCreated>
<EventRecordID>35606</EventRecordID>
<Channel>Application</Channel>
<Computer>NOLAN-WIN10</Computer>
<Security>
</System>
<EventData>
<Data>EXCEL.EXE</Data>
<Data>16.0.4432.1003</Data>
<Data>57cab06e</Data>
<Data>KERNELBASE.dll</Data>
<Data>10.0.14915.1000</Data>
<Data>57c125ca</Data>
<Data>0eedfade</Data>
<Data>000000000004b3c8</Data>
<Data>197c</Data>
<Data>01d2125b31c67e34</Data>
<Data>C:\Program Files\Microsoft Office\Office16\EXCEL.EXE</Data>
<Data>C:\WINDOWS\System32\KERNELBASE.dll</Data>
<Data>97b8855f-9149-4bf6-a9ad-aaa8d893622c</Data>
<Data>
</Data>
<Data>
</Data>
</EventData>
</Event>
|
|
Mon Sep 19, 2016 6:02 am |
|
![](templates/GreenTech/images/spacer.gif) |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7850
|
|
|
|
Please report each issue in a separate post so that we tack them and follow up.
|
|
Mon Sep 19, 2016 8:02 am |
|
![](templates/GreenTech/images/spacer.gif) |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7850
|
|
|
|
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 |
|
![](templates/GreenTech/images/spacer.gif) |
ch21st
Joined: 19 Sep 2016 Posts: 2 Country: United States |
|
|
|
![](templates/GreenTech/images/quote_header.gif) |
![](templates/GreenTech/images/spacer.gif) |
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 |
|
![](templates/GreenTech/images/spacer.gif) |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7850
|
|
|
|
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 |
|
![](templates/GreenTech/images/spacer.gif) |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7850
|
|
|
|
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 |
|
![](templates/GreenTech/images/spacer.gif) |
gemisigo
Joined: 11 Mar 2010 Posts: 2109
|
|
|
|
![](templates/GreenTech/images/quote_header.gif) |
![](templates/GreenTech/images/spacer.gif) |
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.
|
|
Tue Sep 27, 2016 3:09 am |
|
![](templates/GreenTech/images/spacer.gif) |
gemisigo
Joined: 11 Mar 2010 Posts: 2109
|
|
|
|
Confirmed, thank you very much.
|
|
Tue Sep 27, 2016 3:21 am |
|
![](templates/GreenTech/images/spacer.gif) |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7850
|
|
|
|
Build 9.0.152 is now available.
Here is a consolidated list of fixes in builds 9.0.145 to 9.0.152:
1. Fixes in the installer for updating registry entries specific to SQL Assistant's add-on registration for SSMS - correction of left overs from previous versions blocking add-on loading.
2. Crashes in 64-bit applications when SQL Assistant is run on Windows 10 64-bit systems.
3. PGSqlClient.Init exception - Can't find C:\Program Files (x86)\SQL Assistant 7\data\PGx86\libpq.dll. Looking for dlls in a wrong folder.
4. Database Modeling dialog - cannot move connector lines in ER diagrams.
5. Misaligned values in mouse over stats in data previews and results.
6. SQL Editor - Refresh cache doesn't refresh database list in the toolbar drop-down.
7. Exporting results from Count Rows dialog to Excel leads to eventual crash.
8. Test data generator and several other tools don't work with native PostgreSQL connections.
9. Multiple anomalies related to display and processing of double precision numbers when using native PostgreSQL connections.
10. PostgreSQL and ODBC connections - syntax check thread hanging randomly and not aborting on code run.
11. SQL Editor - Replace Text dialog, the Replace All function always replaces in the entire document ignoring "Selected Text" option.
12. Object's popup and $OBJECT$ macro occasionally shows duplicate entries when users type filter
13. Data preview and result grids- cell multi-line value indicator is not always shown.
14. Data preview and result grids- copying cell contents with multi-line values, line breaks lost.
15. Adding LIMIT clause to SQL statement disables SQL intellisense for the current statement.
16. Contents of some code snippets inserted incorrectly.
17. Netezza - EXPLAIN PLAN not returning correct results.
18. Fixes for several types of run-time exceptions.
|
|
Wed Sep 28, 2016 2:31 am |
|
![](templates/GreenTech/images/spacer.gif) |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7850
|
|
|
|
Build 9.0.157 is now available.
Here is a consolidated list of fixes in builds 9.0.153 to 9.0.157:
1. Login error when using SSMS and SQL based authentication and opening files or restoring tabs on startup.
2. Application conflicts, On 64-bit systems some application do not start correctly after SQL Assistant beta installation.
3. SSMS 2016 crashes on startup if SQL Assistant's systray application isn't running.
4. Syntax and database error highlighting triggers exceptions in WaveHiLi function.
5. Changes in data-type-mapping management interface in the Options.
6. Disabled diagnostics self-monitoring for frozen threads, when enabled it shows too many exceptions unrelated to the core functions.
7. Schema Compare generates invalid CREATE USER code for MSSQL targets.
8. Unicode characters not saved correctly in code snippets, and other places in the Options when SQL Assistant is installed on systems with Windows-1252 code page, resulting a bunch of question marks.
9. Common hotkeys cannot be changed in the Options.
10. ReadDiagramStream error in Database Model when opening complex diagrams fro ma file.
11. Various exceptions when closing target editors, TComClient.Destroy, memoRawGetLineStyle, etc...
12. Code snippet execution may produce invalid results and in certain cases trigger Access violation exceptions
13. Added SQL Reference for DB2 for iSeries v6.1
14. Several fixes for anomalies in $CURRENT(...)$ macro behavior.
|
|
Wed Oct 05, 2016 12:15 am |
|
![](templates/GreenTech/images/spacer.gif) |
GeneW
Joined: 10 Apr 2012 Posts: 19 Country: United States |
|
Netezza connection requirements |
|
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.
Client: Release 7.2.1.2 [Build 47843]
Server: 07.02.0001 Release 7.2.1.2 [Build 47843]
SQL State: HY000
ERROR: Permission denied on "_T_DATABASE".;
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 |
|
![](templates/GreenTech/images/spacer.gif) |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7850
|
|
|
|
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 |
|
![](templates/GreenTech/images/spacer.gif) |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7850
|
|
|
|
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 |
|
![](templates/GreenTech/images/spacer.gif) |
GeneW
Joined: 10 Apr 2012 Posts: 19 Country: United States |
|
|
|
Thanks - I see what you are referring to and it looks like that will provide enough details to get going.
|
|
Wed Oct 05, 2016 8:23 pm |
|
![](templates/GreenTech/images/spacer.gif) |
|