SQL Assistant version 5.1 has been released - UPDATE

SQL Assistant build 5.1.10 is now available for download. Please give it a try, we are sure you won't be disappointed.

Here is a list of new features and enhancements in version 5.1
===========================================
New and Updated Add-ons and Plug-ins
1. New Visual Studio 2010 native add-on
2. New MySQL Workbench plug-in
3. New IBM Data Studio plug-in
4. Support for latest versions of Toad, PL/SQL Developer, UltraEdit, Notepad++

Connectivity Enhancements
5. Support for ADO.NET 4
6. Support for MySQL ODBC drivers from 5.1.x code branch
7. Support for large text value data types, such as Oracle clobs and longs, DB2 blobs, MySQL texts, SQL Server texts, and all types of varchar(max)/nvarchar(max)

SQL Intellisense Enhancements
8. Highlighting of matching Column/Value pairs in INSERT type queries, prompts for values
9. New option for controlling number of auto-expanded levels in JOIN suggestions
10. Support for multiple foreign keys between the same pair of tables in JOIN suggestions
11. SQL Server - support for Windows user logins not associated with any schema
12. Enhanced code generation for UPDATE and INSERT statements containing references to system generated values.

Miscellaneous
13. SQL Reference - enhanced in-place code entry using placeholders
14. Code compare - updated interface, new advanced text comparison algorithms supporting fine-grade difference highlighting within matching lines; navigation maps; additional customization options
15. Code formatting - support for decimal numbers in scientific notation
16. Data retrieval - support for long text values and their enhanced display in result sets, including multi-line text values
17. Fast reloading of SQL Assistant in target editors after settings changes; faster loading on startup
18. Auto-closure of displayed prompts after use of Ctrl+V shortcut
19. Over 100 of bug fixes and minor improvements

Last edited by SysOp on Thu Jun 23, 2011 9:14 am; edited 2 times in total

SQL Assistant version 5.1.40 is now available

Here is what's new and changed in this version:

Enhancements:
1. Windows Vista / 7 / 2008 - alerting users about attempts to use elevated privileges when required for updating certain options.
2. Highlighting of error messages in Unit Test output log.
3. Simplified DB2 connectivity – support for HOSTNAME property in connect string.
4. Column data-type hints on mouse-over events.
5. Data generator – new options for generating human readable random text.
6. Data generator – new options for using collections of symbols (character sets) for generating random text values.
7. Data generator – the Options dialog now supports customization of association rules for matching column names and library data files and columns, allowing fast data-generation project setups.
8. Hot-track based display of sample column data values.
9. Hot-track based preview for view DDL syntax in Oracle targets.

Fixes:
Over 30 fixes for known bugs.