Version 6.3

• SQL Intellisense enhancements – multiple text matching methods including suffix name matching, spelling correlation, and matching characters highlighting.
• New Task and Reminders interface – centralized view of persistent bookmarks and "to-do" reminders saved across multiple files, database servers and objects.
• New plug-in for Oracle JDeveloper – complete drop-in development toolbox, including full set of SQL Assistant utilities and a full featured SQL Editor.
• New plug-in for Oracle SQL Developer – complete drop-in development toolbox, including full set of SQL Assistant utilities and a full featured SQL Editor.
• New multi-server, multi-database data search and replace with advanced options, regular expressions, preview-before-change, and more.
• Enhancement in code formatting and layout controls - additional macro variables added to improve control of dynamically generated code headers.
• Visual bookmarks enfacements – removed limitations on the number of persistently saved bookmarks in a single file.
• Added new options for greater controls of application filters to aid users in resolving cross-application conflicts.
• Better integration with external code comparison tools. External tools can be now used nearly in all places where an internal code compare is used.
• Enhancement in SQL Intellisense for SQL Server – improved handling of user-defined data types (column descriptors now display the original data type along with its expanded description).
• Enhancement for XML data import – new Truncate table option added for data loading.
• Enhancement for XML Export and Data Generator produced deployment scripts – new option to generate CREATE TABLE commands as part of the script with multiple options, including IF NOT EXISTS.
• Enhancement for XML Export/Import and Excel Import – added graphical scheduling for unattended operations.
• Many other enhancements. For complete list, see What's new page

Version 6.2

• Bulk SQL code generator with ready to use templates for generating CRUD procedures.
• New set of add-ons for SQL Server Management Studio 2005, 2008, 2012; SQL Assistant direct integration with the Database Object Explorer.
• Updated Visual Studio 2010 add-ons extending support to Ultimate Edition.
• Easy Excel data export / import to and from database.
• Hierarchical and flat XML data export / import.
• Improved SQL Intellisense – automatic and suggested corrections for misspelled keywords, names, parameters, etc…
• Improved SQL Intellisense – suggestions for code generating snippets.
• Referential integrity validation added to dependencies analyzer and smart database refactoring methods.
• Multi-server multi-database code search.
• Multi-server multi-database data search.
• Mouse-over hints for schema and database names with statistical info and action links.
• Support for MDX windows and queries in SQL Server Management Studio.
• Auto-bookmarks (visual bookmarks with screenshots) from specially formatted script comments.
• Enhancements in macro-script parameters processing, new options for processing updatable columns and key based columns.
• Automatic identification and highlighting of performance costliest operations in Query Execution Plans.
• Many other enhancements. For complete list, see What's new page

Version 6.1

• New add-on and integration with SQL Server Management Studio 2012
• Support for SQL Server 2012
• Automatic source control system repository updates
• SQL Intellisense enhancements
• SQL history and recall
• Hints for SQL Reference rules
• Oracle DBMS_OUTPUT polling and reading
• 1-click copying of DDL scripts from Code Preview to SQL editor
• Advanced version of the $OBJECT(...)$ macro
• Support for latest versions of MySQL Workbench, Toad, Ultraedit
• Many other enhancements. For complete list, see What's new page

Version 6.0

• Real time automatic code performance analysis and suggestions
• Integrated database source code control interface
• Code formatter enhancements
• Graphical code execution plans
• Customizable database version specific queries and settings
• On the fly reverse engineering of all types of database objects
• Table statistical hints and information panes
• SQL Intellisense enhancements, including support for CTEs
• Unit test scheduling
• New pre-defined interactive code snippets
• Support for latest versions of several types of SQL editors
• Many other enhancements. For complete list, see What's new page

Version 5.2

• Scheduling SQL code on single and multiple database systems
• Enhanced Database Code Refactoring engine
• Code formatter enhancements
• PostgreSQL 9.x support
• Column hints and super-fast column scope data previews
• SQL Intellisense enhancements
• In-line help with solving database and code errors

Version 5.1

• New and Updated Add-ons and Plug-ins (VS 2010, MySQL Workbench, others)
• Support for ADO.NET 4
• SQL Intellisense enhancements
• SQL Reference enhanced inetrface - in-place code entry using placeholders
• Over 100 bug fixes and minor improvements

Version 5.0

• Smart database and SQL code refactoring
• Code dependencies analysis
• Programmable macros in code snippets
• Test data-generator
• Database unit testing framework
• Batch formatting of SQL files
• Many other enhancements. For complete list, see What's new page

Version 4.8

• Redesigned SQL Intellisense for manually activated prompts Ctrl+Space hotkey. Manually activated Intellisense prompts are now much smarter and in most cases match or exceed functionality of automatic while-you-type context prompts
• Support for old and new versions of MySQL client software up to version v5.4. MySQL clients 4.x can now be used for connections to MySQL 5.x servers.
• Column-name based JOIN suggestions support Oracle synonyms.
• Column-level in JOIN suggestions is now automatically expanded for greater coding efficiency.
• New "Never" option added for Always Add Delimiters options.
• Functions for scripting table data now support breaking long scripts into batches and printing progress of work messages.
• Performance optimizations of data-previews. SQL Assistant now generates query syntax allowing the database server to choose best execution plan. Performance gains for data-preview typically exceed 400% in SQL Server and Oracle, when data-preview is used with large tables and complex views.
• Enhanced integration with different types and versions of SQL Server Management Studio and Management Studio Express.
• Compatibility changes for latest versions of ApexSQL Editor.
• Other minor enhancements and usability changes.

Version 4.7

• Scripting table data in multi-database formats.
• Ability to cancel running queries without closing SQL Editor/IDE.
• New macros for supporting table key columns in code snippets.
• Smart use of Home and End keys and highlighting of trailing spaces.
• Intellisense support for SQL Server 2008 MERGE statement.
• Compatibility changes for supporting latest versions of UltraEdit and PL/SQL Developer.
• New pre-configured target settings for Notepad++ editor.
• Support for team development and sharing of settings, macros, formatting rules, etc – new Options Import/Export graphical and command line interfaces.
• Other minor enhancements and usability changes.

Version 4.6

• 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.
• 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.
• Mouse-over hints for procedure and function parameters, for table and view columns for objects whose names contain spaces and special symbols.
• Search capabilities added to SQL Reference.
• Smart handling of Home/End keys for improved coding productivity.
• Support for global variables and built-in functions in Sybase ASE and Sybase SQL Anywhere.
• Automatic end-of-line text conversion from Unix to Windows conventions when copying database code from the Procedural Code View.
• Other minor enhancements and usability changes.

Version 4.5

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

Version 4.1

• Code highlighting for matching object, variable, column names.
• One-click sorting in data preview.
• Code Snippets added to menus with shortcuts.
• Variable data-type hints on mouse-over.
• Enhanced data-types alignment in formatted table and variable declarations, multi-line procedure parameters, etc...
• Support added for package and type scope variables in Oracle procedural objects.
• Updated SQL References for Oracle and MySQL - added description, syntax, interactive building of regular expressions.
• "Smart Undo" feature.
• Optional tab characters replacement with spaces.
• 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).
• Automatic expansion of uniquely identified schema names in popups.
• Other minor enhancements and usability changes.

Version 4.0

• Enhanced 4th-generation SQL IntelliSense+ functionality, now supporting intelligent keyword suggestions, package variables, and more.
• New real-time syntax checker automatically highlights syntax errors, incorrect object and column names, undeclared variables etc...
• Rebuild 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.
• Multi-server SQL script execution function allows one-click code execution on multiple servers.
• Support for Postgre SQL.
• Support for DB2 for iSeries.
• Updated SQL References for Oracle 11g and DB2 9.5
• New manual and self-check for updates feature with automatic downloading and installation of new versions, by default set to weekly schedule.
• New _WOW_ code snippets for SQL Server and MySQL. Do not miss them, try them as soon as you get this upgrade!
• New preconfigured targets for pgAdmin III.
• New preconfigured targets for PowerBuilder.
• New preconfigured targets for "Express" versions of Visual Studio 2008.
• 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.
• Updated "Objects (MSSQL)" query now supports INFORMATION_SCHEMA in SQL Server 2005/2008 systems.
• Filters tightened for Toad based targets to eliminate popups in inappropriate places.
• 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.

Version 3.5

• Use of coding history cache has been turbo-charged. Code suggestions based on historical coding patterns are available in many places.
• Eclipse plug-in. That's right, SQL Assistant can now be used with Eclipse and derivative products including Eclipse Data Tools Platform.
• Multiple column selection lists are supported in UPDATE and INSERT statement. Checkboxes have been added to these column lists allowing to choose multiple columns at once.
• Multiple-column foreign keys are supported in JOIN clauses. The entire JOIN with all columns can be now added with a single mouse click or a single key-press.
• New Code Bird's View feature helps to navigate long files and scripts, supporting jumps between code fragments without scrolling and reading the actual code.
• New coding statistics and productivity gain display. Some of our internal tests achieved as much as 1200% productivity gain from using SQL Assistant! Try it for yourself.
• Additional code-wrapping options have been added to formatting rules.
• Support for batch delimiters available for all environments, including parsing and support for MySQL's DELIMITER keyword and DB2's SET TERMINATOR.
• Expanded support for Oracle objects and packages - added code IntelliSense for types, type and package constants, exception handlers and declarations, package and type scope records.
• New code block commenting/uncommenting function can be used with non-SQL editors such Notepad, UltraEdit and other not supporting such commonly used function.
• Numerous other minor enhancements and usability changes.

Version 3.1

• Direct code execution – Notepad and all other simple editors can now fully compete with specialized SQL editors and development environments.
• Table data mini-preview (single-click on a table, view, or synonym shows first 100 records)
• Support for MS Access as a back-end database, via direct integration with Access IDE and via ODBC database connection from other SQL editors (for example, you can now run MS Access queries and make data changes from Notepad).
• Data export to Excel and text files.
• SQL Code Structure support for CALL statements and other enhancements in the Structure view.
• DB2 and MySQL – support for FOR NOT FOUND and CURSOR..FOR constructs.
• Connection interception for SSMS in SQL Server 2008 (Katmai).
• Add-on registration for SSMS in SQL Server 2008 (Katmai)
• Branch expansion in popups and enhanced multi-level item filtering in expanded branches.
• Full support for synonyms in SQL 2005/2008
• New options to fully or partially qualify object names.
• Formatting code enhancements – added support for code structures beginning with the same keyword, for example, BEGIN and BEGIN TRY
• Logical join completion for subqueries - joins between tables referenced in the main query and tables referenced in subqueries.
• Support for join candidates using matching column names.
• Introduced 2 new macro-variables in code snippets for generating vertical column and parameter lists.
• Improved code auto-indent handling.
• Reworked and expanded database connection handling. Starting with this version ADO.NET-based and ODBC-based connections can be used with all supported database systems. For ODBC-based connections both DSN and DSN-less connections are now supported.
• Client-side authentication is now supported for DB2 and Sybase database connections using ADO.NET interfaces.
• Numerous other minor enhancements and usability changes.

Version 3.0

• Context SQL suggestions based on the typing history
• Matching brackets and code block delimiters (BEGIN..END, IF..END IF, LOOP..END LOOP, etc...) highlighting and one-click navigation
• One-step complete SELECT statement generation after selecting columns in SELECT prompt
• Support for multiple-column selection using check boxes in SELECT and other prompts
• Advanced Auto-indent features
• Support for procedure parameters in MySQL
• Support for subqueries and derived tables with variable parameters in SQL Server
• Code syntax validation for DB2 and MySQL
• Support for objects and columns declared in temp tables and table variables
• Code expansion for * and other elements in DML statements
• Advanced code completion in DML statements and statement generation based on selection of a JOIN or WHERE clause
• Context suggestions for code expansion in DDL statements. Context sensitive help with DDL commands
• Support for multiple formatting styles
• Advanced code snippets for auto-generating object-specific code fragments
• Advanced selection and code generation of variables in DECLARE statements
• Improved popup activation after dot or bracket
• Auto-generation of table aliases
• Support for MySQL native client connections
• MySQL Query Browser Connect Interception
• IntelliSense list content filtering control added to Options
• Improved code formatting - control of bracket positioning
• Built-in add-ons for SSMS, VS, VS for Database Team Professionals (former Data Dude)
• Support for Toad for MySQL/DB2/SQL Server
• Expiremental support for Sybase databases
• Other minor improvements over version 2.x

Version 2.5

• New one-click Procedural Code View - with a single click you can lookup and browse code of referenced procedures, functions, packages or just type the object name and click it to see the code of that object
• New integrated spell checker for SQL code comments and hard-coded string
• Improvements in Code Formatter and Beautifier
• Smarter IntelliSense in the code auto-completion features
• Enhancements in the Code Structure View - added support for loops and conditional statements, support for more types of SQL commands
• Added support for more SQL editors and IDEs
• Significant improvements made in the Options making it easier then ever to customize SQL Assistant behavior
• Other minor improvements over version 2.0

Version 2.0

• Support for MySQL and DB2 databases and editors
• Support for more editors and IDEs for SQL Server and Oracle with more flexible customization options
• Code Structure View for quick code navigation - anyone who deals with large SQL files would much appreciate this new feature
• Advanced code Intellisense and auto-completion for extended set of SQL commands, including many DML and DDL commands
• New code auto-expansion options
• Smart code auto-indent feature
• Code Formatter and Beautifier
• Code syntax validation for all Oracle and SQL Server editors, can be used even with Notepad
• Other minor improvements over version 1.0