SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
SQL Assistant 7.0 BETA VERSION R3 available

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
SQL Assistant 7.0 BETA VERSION R3 available
Author Message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6499

Post SQL Assistant 7.0 BETA VERSION R3 available Reply with quote
Build 7.0.132 is now available for testing

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

1. New solution for improving database code reusability.
2. New Professional SQL Editor - a full-featured database development environment for 10 database types.
3. New database workload generator utility for application scalability testing.
4. New database type supported – Amazon Redshift.
5. New Context SQL Search with real-time suggestions and centralized and fully indexed code repository with full text search indexes for database code across multiple database servers.
6. Enhanced Document Manager - visualizes file context when closing development environment and saving multiple files; no more guess work when prompted to save a bunch of generically named scripts without being able to see their content.
7. Document Managers implemented for Toad, Eclipse, DB Tools, Notepad++, pgAdmin.
8. Enhanced Document Manager now enables fast recent documents filtering by context.
9. Improved DB Explorer– completely rewritten, the new robust explorer interface can be used with all supported target editors and databases; even Windows Notepad can be now turned to a full featured database editor. The improved DB Explorer features a number of unique functions, including display of object stats, last modification time, object and column comments, linking to external files, and more.
10. Unit Testing Framework now enables logging and saving unit test results to a database table for advanced data analysis using specialized analytical and reporting software.
11. All databases: SQL Intellisense enhancements for UPDATE and CALL statements - use of {fields} to faster code entry.
12. All databases: SQL Intellisense enhancements "Name Matching Method" is now customizable at runtime, name matching and sorting can be changed with two clicks directly in SQL Intellisense popups.
13. MSSQL and Sybase ASE: SQL Intellisense enhancements for temporary tables, column info provided for temporary tables having their definition predictable in design time.
14. New command line interface and scheduling for the Data Compare utility, now comparison can be scheduled as well as integrated with Unit Tests.
15. Enhanced $OBJECT(ins_column)$ macro enables multiple columns selection.
16. Compatibility changes for Toad for SQL Server 6.1 and later – database connection sharing now supported.
17. Compatibility changes supporting Visual Studio 2013. (not available in this beta; scheduled for general release).
18. Compatibility changes supporting latest UltraEdit v20.
19. New add-ons for Delphi XE 1-5.
20. MSSQL: support for database-level triggers.
21. MSSQL: support for custom table-type data types.
22. Interactive SQL Reference for Amazon Redshift.
23. Interactive SQL References for MS SQL 2012, DB2 10, DB2 10.5 (not available in this beta; scheduled for general release).
24. All databases: The Source Code Control interface now supports custom data types.
25. Lots of other minor changes and enhancements.

To download the beta version, visit the product's home page and click the Download v7.0 link


Last edited by SysOp on Thu Jul 31, 2014 9:19 am; edited 4 times in total
Mon Jun 30, 2014 1:55 am View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 1394

Post Reply with quote
Epic :)

What does "MSSQL: support for database-level triggers" cover?
Mon Jun 30, 2014 3:08 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6499

Post Reply with quote
Triggers are scriptable, shown in DB Explorer, can be added to source control interface
Mon Jun 30, 2014 8:30 am View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 1394

Post Reply with quote
SysOp wrote:
Triggers are scriptable, shown in DB Explorer, can be added to source control interface

That's something I hacked into v6 by adding them to DB query that retrieves procedures. But they were handled just as the procedures were. Is this different?
Mon Jun 30, 2014 8:33 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6499

Post Reply with quote
Yes, now handled differently as table child objects, rather as standalone procedures, that's one of the enhancement n v7.

This particular item in "what's new" is referring to database scope DDL triggers on CREATE, ALTER, DROP, GRANT, DENY, REVOKE, or UPDATE STATISTICS, in other words,
CREATE TRIGGER trigger_name ON DATABASE ...
Mon Jun 30, 2014 9:22 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6499

Post Reply with quote
Beta build 7.0.136 has been posted to the web server and available for download (use the same download link you used before)

This build contains bug fixes and new add-on for supporting VS 2013
Fri Jul 04, 2014 10:58 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6499

Post Reply with quote
Beta build 7.0.141 has been posted to the web server and is available for download (use the same download link you used before)

This build contains 2 dozen bug fixes and several new enhacements
Thu Jul 10, 2014 12:51 am View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 1394

Post Reply with quote
SysOp wrote:
This build contains 2 dozen bug fixes and several new enhacements


Could you post a short list of those, please?
Thu Jul 10, 2014 3:20 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6499

Post Reply with quote
Sure, here are the enhancements in Beta 7 R3.
1. Source code control interface - progress of work for long operations updating the repository and an ability to cancel them.
2. Multiple column selection for temporary tables.
3. Refactoring -> Qualify Object Names - enabled qualification for stored procedure names.
4. Undo/Redo/Find/Replace in code snippet editor, formatting rules, unit tests, and a number of other places where Rich Text Editor control was used and now replaced with integrated editor control.
5. Tab Manager for Visual Studio IDEs for all supported versions from 2005 to 2013
6. Edit hyperlink in mouse-over balloons for procedural objects and views - basically 1 click access to the Edit Code function.


The list of all bug fixes in the beta version is rather difficult for me to extract, it may take a while, so let me skip it for now and post it later. Just note that there are a number of bug fixes for issues reported in this forum during last week., including internal bugs, compatibility issues with VS and Toad, MySQL Workbench, fixes in ADO.NET db interface, etc...


Last edited by SysOp on Thu Jul 10, 2014 8:56 am; edited 1 time in total
Thu Jul 10, 2014 8:42 am View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 1394

Post Reply with quote
Thank you very much.
Thu Jul 10, 2014 8:45 am View user's profile Send private message
Mindflux



Joined: 25 May 2013
Posts: 616
Country: United States

Post Reply with quote
Amazing progress. Thanks :)
Thu Jul 10, 2014 3:17 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6499

Post Reply with quote
Ladies and Gentlemen,

SQL Assistant version 7 has been released and is now available for download. Please be aware that the beta version is going to expire tomorrow.

Sincerely,
Support team @ SoftTree Technologies, Inc.
Thu Jul 31, 2014 9:14 am View user's profile Send private message
Mindflux



Joined: 25 May 2013
Posts: 616
Country: United States

Post Reply with quote
SysOp wrote:
Ladies and Gentlemen,

SQL Assistant version 7 has been released and is now available for download. Please be aware that the beta version is going to expire tomorrow.

Sincerely,
Support team @ SoftTree Technologies, Inc.


I upgraded and am now stuck in trial mode. My SQL Assistant 6 key does not work in 7? I'll email support@


Thu Jul 31, 2014 9:33 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6499

Post Reply with quote
You do need a new license key for v7. Please contact support to obtain a new key.
Thu Jul 31, 2014 9:53 am 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.