SQL Assistant version 6.0 available

SQL Assistant version 6 was released today. Build 6.0.65 is now available for download. Please give it a try, we are sure you won't be disappointed.

Version 6.0 delivers exciting new functionality with several new major features and over 100 minor enhancements, including, but not limited to:

Here is a list of new features and enhancements in version 6.0
===========================================

1. Real time as-you-type automatic code performance analysis and suggestions.
2. Full-featured source control interface with 3-way database-files-repository code comparison and synchronization, checkin/checkout, change history, and so on… This new source control interface supports Subversion and Microsoft Team Foundation Server repository servers.
3. Graphical code execution plans for all types of supported database servers.
4. Customizable database version specific queries and settings. Database version is recognized automatically and version specific settings are used as required.
5. On the fly reverse engineering of virtually all types of database objects, "Show DDL" is now available for all objects.
6. Customizable SQL Assistant menus, add/delete/reorder menu items to match your coding habits and increase your productivity.
7. All databases: Table statistical hints and information panes, including instant row count hints for tables of any size, table columns with unfolding user-defined data types, and more.
8. SQL Server and Sybase ASE/ASA databases: Intellisense is now offered for UPDATE...FROM and DELETE FROM ... FROM statements.
9. All databases: intellisense for Common Table Expressions (a.k.a CTE in SQL Server, and WITH clause in Oracle)
10. All databases: intellisense is now available for APPLY keywords
11. All databases: intellisense for UPDATE statements provides enhanced support for built-in database functions.
12. Test-data generator is now context sensitive. Right-click on a table name, choose Test-data Generator menu, and with one additional click you can start inserting realistic test-data into the selected table.
13. Test-data generator supports generating test values for Oracle's LONG data-type.
14. PostgreSQL: warnings and notices are reported separately from errors.
15. PostgreSQL: intellisense for SERIAL and IDENTITY column in INSERT/UPDATE statements.
16. All databases: intellisense for various SEQUENCE and sequence-like objects and functions, for example in Oracle, "<sequence_name>.nextval", in DB2: "NEXT VALUE FOR <sequence_name>", in PostgreSQL "naexval(<sequence_name>)" and pg_get_serial_sequence function, and so on
17. All databases: intellisense for JOIN suggestions now provides previews of table aliases for to be inserted code.
18. Sybase ASA: support for unsigned data types.
19. All databases: intellisense for INSERT...VALUES supports script variables and procedure parameters.
20. All databases: improved Intellisense for ALTER TABLE statement.
21. All databases: intellisense now supports coding database triggers.
22. Unit-test can now be scheduled directly from SQL Assistant interface.
23. Column name filtering is now available in code snippets using $OBJECT$ macros.
24. Refactoring templates now support standard set of SQL Assistant macros.
25. New pre-defined interactive code snippets.
26. Support for latest versions of MySQL Workbench.
27. Support for latest versions of Ultraedit.
28. Lots of other minor changes and enhancements.

Last edited by SysOp on Mon Jun 11, 2012 1:50 pm; edited 1 time in total

Version 6 does not accept version 5 licenses. We have a current maintenance contract, so how do we obtain version 6 licenses?

Every major SQL Assistant version requires new licenses. Please contact salesATsofttreetech.com and request new license keys for version 6. Please don't forget to mention your existing license keys. If your license maintenance is current, the upgrade is free.

Thank you.

Hmm. We have a couple of v5.x licenses, with annual maintenance.

Do we order an upgrade or renewal for v6.x licenses?

Hmm, hmm again... Tried to find the appropriate SKU for the upgrade but the pages are a bit confusing about what to select.

If we want to upgrade our v5.x licenses w/ annual maintenance to v6.x w/ annual maintenance, should we select SQL-60-UPM?

"Renewal" or "Upgrade" can be a bit confusing for existing license customers...

	Quote:
	Do we order an upgrade or renewal for v6.x licenses?

Neither. If your maintenance is current, the upgrade is free. Simply email your current license keys to salesATsofttreetech.com and request a new set.

However, if your maintenance is not current, you would need to purchase an upgrade.

Is it possible to upgrade to v6.0 Standard Edition from v5.x Pro?

You've got a special case. Please contact sales to request your free license upgrade. And thank you again for your continues support and help with SQL Assistant development

SysOp wrote:

	Quote:
	Do we order an upgrade or renewal for v6.x licenses?

Neither. If your maintenance is current, the upgrade is free. Simply email your current license keys to salesATsofttreetech.com and request a new set.

However, if your maintenance is not current, you would need to purchase an upgrade.

We have a couple of months worth of maintenance left. So we request new keys for v6.x and then, when the maintenance period is over - we order another year of maintenance?

Is that correct?

That's correct.

By the way, you can renew your maintenance at any time before it expires. You are not going to loose anything if you do it a bit in advance. The new maintenance end date is last end date rolling forward by 1 year.

	SysOp wrote:
	You've got a special case. Please contact sales to request your free license upgrade. And thank you again for your continues support and help with SQL Assistant development

I got the email with the license yesterday. Thank you very much.

SQL Assistant version 6.0.86 available

Build 6.0.86 is now available for download

This build contains several bug fixes and several enhancements:

1. New SQL Reference for MS Access 2007,
2. New MySQL version specific SQL References for MySQL 5.0, MySQL 5.1, MySQL 5.4, MySQL 5.5, and MySQL 5.6
3. New command line for automatically updating source code control systems from database schema changes. And a similar command for updating database schemas from source code control systems; Subversion and Team Foundation Servers are both supported