SQL Assistant 7.0 BETA VERSION R3 available

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

Epic :)

What does "MSSQL: support for database-level triggers" cover?

Triggers are scriptable, shown in DB Explorer, can be added to source control interface

	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?

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 ...

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

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

	SysOp wrote:
	This build contains 2 dozen bug fixes and several new enhacements

Could you post a short list of those, please?

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

Thank you very much.

Amazing progress. Thanks :)

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.

	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@

You do need a new license key for v7. Please contact support to obtain a new key.