SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
SQL Assistant version 6.0 available

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
SQL Assistant version 6.0 available
Author Message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7839

Post SQL Assistant version 6.0 available Reply with quote
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
Thu Aug 18, 2011 2:49 am View user's profile Send private message
jrandall



Joined: 06 Oct 2008
Posts: 27
Country: United States

Post ver 6 licenses Reply with quote
Version 6 does not accept version 5 licenses. We have a current maintenance contract, so how do we obtain version 6 licenses?
Fri Aug 19, 2011 12:43 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7839

Post Reply with quote
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.
Fri Aug 19, 2011 12:49 pm View user's profile Send private message
lmfs



Joined: 01 Apr 2009
Posts: 9
Country: Sweden

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

Do we order an upgrade or renewal for v6.x licenses?
Mon Aug 22, 2011 3:29 am View user's profile Send private message
lmfs



Joined: 01 Apr 2009
Posts: 9
Country: Sweden

Post Reply with quote
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...
Mon Aug 22, 2011 7:26 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7839

Post Reply with quote
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.
Mon Aug 22, 2011 10:52 am View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 2102

Post Reply with quote
Is it possible to upgrade to v6.0 Standard Edition from v5.x Pro?
Mon Aug 22, 2011 3:00 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7839

Post Reply with quote
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
Mon Aug 22, 2011 3:32 pm View user's profile Send private message
lmfs



Joined: 01 Apr 2009
Posts: 9
Country: Sweden

Post Reply with quote
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?
Tue Aug 23, 2011 6:30 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7839

Post Reply with quote
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.
Tue Aug 23, 2011 9:14 am View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 2102

Post Reply with quote
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.
Thu Aug 25, 2011 4:58 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7839

Post SQL Assistant version 6.0.86 available Reply with quote
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
Fri Sep 30, 2011 8:35 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.