SQL Assistant v4 versions and updates info

SQL Assistant v4.0 is now available
Here is what's new and changed in 4.0

1. Enhanced 4th-generation SQL IntelliSense+ functionality, now supporting intelligent keyword suggestions, package variables, and more.
2. New real-time syntax checker automatically highlights syntax errors, incorrect object and column names, undeclared variables etc...
3. Enhanced SQL Formatter – industry's most advanced SQL, T-SQL, PL/SQL, MySQL, … code formatter and beautifier supports multiple code layout and formatting styles, provides great extensibility, and code layout customization features.
4. Multi-server SQL script execution function allows one-click code execution on multiple servers.
5. Support for Postgre SQL.
6. Updated SQL References for Oracle 11g and DB2 9.5.
7. New manual and self-check for updates feature with automatic downloading and installation of new versions, by default set to weekly schedule.
8. New _WOW_ code snippets for SQL Server and MySQL. Do not miss them, try them as soon as you get this upgrade!
9. New preconfigured targets for pgAdmin III.
10. New preconfigured targets for PowerBuilder.
11. New preconfigured targets for "Express" versions of Visual Studio 2008.
12. Targets for Visual Studio 2005/2008 enhanced to activate SQL Assistant only in files with .SQL and .DDL extensions and in the SQL query builder window.
13. Updated "Objects (MSSQL)" query now supports INFORMATION_SCHEMA in SQL Server 2005/2008 systems.
14. Filters tightened for Toad based targets to eliminate popups in inappropriate places.
15. SQL Assistant's configuration files moved to user's Application Data folder to simplify installation and use via Remote Desktop and on Windows Vista systems.

Last edited by SysOp on Sat Oct 09, 2010 3:06 pm; edited 2 times in total

Build 4.0.34 is now publicly available.

Please note that builds 4.0.31 to 4.0.33 have not been publicly released. These were private builds which we used to test and tune integration options with various target environments.

Build 4.0.34 contains the following improvements and bug fixes:
Build 4.0.34 is now publicly available.

Please note that builds 4.0.31 to 4.0.33 have not been publicly released. These were private builds which we used mostly to test and tune integration options with various target environments.

Build 4.0.34 contains the following improvements and bug fixes:

1. Implemented connection interception for certain types of Visual Studio (VS) targets. Currently only trusted connections can be intercepted.

2. Added TNS names drop-down on all places where an Oracle connection is required

3. Implemented additional integration options for VS 2005 Team for DB Professionals. SQL Assistant now supports both connected edit windows containing queries and object definitions opened from the database and disconnected edit windows containing code opened from source control systems.

4. Minor improvements made for better integration with SQL Server Management Studio versions 2005 and 2008

SQL Assistant v4.1 is now available
Here is what's new and changed in 4.1

1. Code highlighting for matching object, variable, column names.
2. One-click sorting in data preview.
3. Code Snippets added to menus with shortcuts.
4. Variable data-type hints on mouse-over.
5. Enhanced data-types alignment in formatted table and variable declarations, multi-line procedure parameters, etc...
6. Support added for package and type scope variables in Oracle procedural objects.
7. Updated SQL References for Oracle and MySQL - added description, syntax, interactive building of regular expressions.
8. "Smart Undo" feature.
9. Optional tab characters replacement with spaces.
10. SQL code copying to the clipboard as a "string" in a specific programming language format or as dynamic SQL script or batch files (including C#, Java, VB, PHP, Perl, and many others).
11. Automatic expansion of uniquely identified schema names in popups.
12. Other minor enhancements and usability changes.

SQL Assistant build 4.1.8 is now available for download

This build address several issues including,
#2330 - Edit tab switching in SQL Server Management Studio and Visual Studio could make take several seconds, which is caused by slow menu refreshes.
#2317 - Incorrect Oracle package body parsing affecting code structure view and suggestions for package variables.
#2312 - Minor enhancements in sample code snippets.

In response to many inquiries... here is the expected roadmap SQL Assistant releases for 2009. Please note that the referenced version numbers are subject to change

4.5 - end of January 09
4.6 - March 09
4.7 - mid of summer
5.0 - autumn 09

Many very existing enhancements are under development and should become available in the coming 4.x releases. For competitive reasons we cannot name them here, but can say that many of them are based on the enhancements requests we received from you.

Please make sure your annual license maintenance stays current so you can get these enhancements without purchasing license upgrades.

SQL Assistant build 4.5.9 is now available for download

New features and enhancements

1. One-click comparison for code in the editor against database, files, other editors.
2. Added optional display of table constraints and indexed columns in column popups and mouse-over hints.
3. Mouse-over hints for procedure and function parameters and for table and view columns.
4. Added auto-connect feature for non-shared connections. Now you can set the connection and forget about it, no need to use the Connect dialog.
5. Support added for DB2 aliases, sequences, and types.
6. Support added for pass-through queries in MS Access.
7. Auto-completed INSERT and UPDATE statements now automatically check for and skip identity columns.
8. Support added for SQL Scrapbook window in Eclipse and Eclipse based products.
9. Oracle procedural code compilation errors are recognized reported as code execution errors.
10. All popups now remember user-selected size.
11. All dialogs are now resizable.
12. Other minor enhancements and usability changes.

Bug fixes:

1. SQL Assistant popups stop appearing after new db is created in SQL Server
2. Oracle ODBC-based connections may lead to "ORA-24374: define not done before fetch or execute and fetch"
3. Compatibility issues with PosgreSQL before 8.3 - automatic INET data type conversion to string is not handled by PosgreSQL before 8.3 release.
4. Certain types of errors captured during code execution in PostgreSQL may be reported twice.
5. Bracket highlighting is not updated after invocation of code formatting using the associated hot-keys.
6. Using "Show Table Data" in SQL*Plus always lead to Nothing is Selected error.
7. Using "Show Table Data" in "Toad for Oracle FREEWARE" always lead to Nothing is Selected error.
8. SQL Assistant dialogs are missing icons when SQL Assistant is used with recent Toad versions.

SQL Assistant build 4.6.10 is now available for download

New features and enhancements

1. New Visual Bookmarks feature revolutionizes usage of code bookmarks, transforming this obscure and rarely used function available in many code editors into one that you will love and use often.
2. Code Structure View and Code Bird's View are now sticky and can be set to open automatically in every editor window of chosen targets.
3. Mouse-over hints for procedure and function parameters, for table and view columns for objects whose names contain spaces and special symbols.
4. Search capabilities added to SQL Reference.
5. Smart handling of Home/End keys for improved coding productivity.
6. Support for global variables and built-in functions in Sybase ASE and Sybase ASA.
7. Automatic end-of-line text conversion from Unix to Windows conventions when copying database code from the Procedural Code View.
8. Support for executing very large SQL files.
9. Support for scrollable mouse-over hints - for tables and procedures with lost of columns and/or parameters.
10. Support for SQLCMD scripts in SQL Server 2008.
11. Other minor enhancements and usability changes.

Bug fixes:

1. Code Compare dialog - resizing panes can completely hide left pane
2. Incorrect position of semicolons after formatting T-SQL code.
3. Dollar sign $ symbol is not recognized as a special symbol, as a result names containing $ symbols not enclosed in brackets or quotes.
4. SQL Server Management. Studio editor and Visual Studio editors do not scroll to the inserted text when inserted text goes below visible screen area.
5. Access violation at address 0823021B in module 'SqlAssistPrefs.dll'.
6. Invalid formatting of Oracle CREATE TRIGGER statement containing DECLARE section
7. Cannot delete user-defined formatting rules added to default formatting styles.
8. Incorrect operator spacing formatting for || in DB2, Oracle, MySQL
9. Toad related - error hints don't appear on screen when mouse is over wavy red lines.
SQL Assistant build 4.6.10 is now available for download

Version 4.6.12 was released yesterday as an emergency build to fix the critical compatibility issue affecting users of PL/SQL Developer and Toad for Oracle, who are using them with SQL Assistant. In the previous build, that issue causes PL/SQL Developer and Toad for Oracle crashing on the application startup.

In addition, build 4.6.12 includes fix for a bug in SQL Assistant installer program causing it not to migrate settings automatically when the installer is run manual or automatically after use of "check for updates" function.

This topic is used for version history and inappropriate for other messages. I'm going to delete your post and respond in a separate topic.

Can you share what is being cooked for next release? I mean can you let SQL Assit user community know what is coming in for next update/release and when?

Sure. Maintenance release 4.7 was expected by mid/end of May but now is being delayed by a few weeks. Main changes in that release are cancellation of running queries; new macros for code snippets supporting SQL code generation specific to table key columns; scripting of table data; new utility for managing configuration changes – merging and sharing with co-workers; compatibility changes supporting latest versions of UltraEdit, Notepad++ and other latest editor updates; and of course bug fixes.

Version 4.7.11 has been released. Please see details here http://www.softtreetech.com/support/phpBB2/viewtopic.php?t=22924

Version 4.8.24 has been released. Please see details here http://www.softtreetech.com/support/phpBB2/viewtopic.php?t=22965

Please note that versions 4.8.1 to 4.8.23 have been built either for internal or private build testing.

Version 4.8.29 has been released. This version corrects 3 issues:

1. Auto-complete for global temporary tables broken in 4.8.24
2. Forced name completion for partially entered object names always displays prompt with a list of matches including single matches for uniquely identifiable names.
2. Automatic prompt after comma characters behavioral change in 4.8.24, requires typing extra space after coma for the prompt display.

Please note that versions 4.8.25 to 4.8.28 are internal builds not available for download.