SQL Assistant 6.3.153 is now available

SQL Assistant 6.3.153 is now available

Build 6.3.153 is now available for download

This maintenance release contains several new significant features, tons of minor enhancements, and bug fixes

Here is a list of new features and enhancements in version 6.3
===========================================
1. SQL Intellisense enhancements – multiple text matching methods including suffix name matching, spelling correlation, and matching characters highlighting.
2. New Task and Reminders interface – centralized view of persistent bookmarks and "to-do" reminders saved across multiple files, database servers and objects.
3. New plug-in for Oracle JDeveloper – complete drop-in development toolbox, including full set of SQL Assistant utilities and a full featured SQL Editor.
4. New plug-in for Oracle SQL Developer – complete drop-in development toolbox, including full set of SQL Assistant utilities and a full featured SQL Editor.
3. New multi-server, multi-database data search and replace with advanced options, regular expressions, preview-before-change, and more.
4. Enhancement in code formatting and layout controls - additional macro variables added to improve control of dynamically generated code headers.
5. Visual bookmarks enfacements – removed limitations on the number of persistently saved bookmarks in a single file.
6. Added new options for greater controls of application filters to aid users in resolving cross-application conflicts.
7. Better integration with external code comparison tools. External tools can be now used nearly in all places where an internal code compare is used.
8. Enhancement in SQL Intellisense for SQL Server – improved handling of user-defined data types (column descriptors now display the original data type along with its expanded description).
9. Enhancement for XML data import – new Truncate table option added for data loading.
10. Enhancement for XML Export and Data Generator produced deployment scripts – new option to generate CREATE TABLE commands as part of the script with multiple options, including IF NOT EXISTS.
11. Enhancement for XML Export/Import and Excel Import – added graphical scheduling for unattended operations.

Lots of other minor changes and enhancements.

* list of changes in version 6.2
* list of changes in version 6.1
* list of changes in version 6.0

Last edited by SysOp on Tue May 21, 2013 8:28 am; edited 1 time in total

The concept of Centralized Tasks and Reminders is splendid. The different name matching methods are brilliant as well (though they are a bit hard to get used to).

Thank you for your nice words. We are happy that you find the newly implemented features helpful. Many of the new features have been implemented in response to user's suggestions and enhancements requests. Your feedback in particular is always very helpful and much appreciated.

	SysOp wrote:
	Thank you for your nice words. We are happy that you find the newly implemented features helpful. Many of the new features have been implemented in response to user's suggestions and enhancements requests. Your feedback in particular is always very helpful and much appreciated.

I withdraw my last statement :) I got used to it pretty quickly. The "Name Contains Characters from Key String" Method is simply phenomenal. Makes filtering much faster in most of the cases, though it requires a great deal of intuition. A small notice: both "Name Contains Key String" and "Name Contains Characters from Key String" have a serious a handicap when the complete name (or all the characters) is a subset of other names. In this case the desired object might be pages away from the top in the popup and no further keypresses can make the list narrower. Providing that these two methods will disregard alphabetic order of the popup items anyway, perhaps sorting the filtered results by length first and alphabetically after could make this new feature even more powerful.

Great job you did there, thank you very much. Keep up the good work!

Would you please create a separate post with your enhancement suggestion and an example describing what you mean by "sorting the filtered results by length first?" Which length?

PS. The 2 new methods have been developed in response to users asking to allow filtering object names ignoring their prefixes. So if all tables in a database begin with a prefix like TBL_and all views begin with VW_ prefix, typing the prefixes wouldn't be required to locate *all* names containing the same common word. For example, TBL_Orders table and VW_OrdersSummary view will appear both in the popup after typing word Order.

Last edited by SysOp on Tue Nov 06, 2012 11:48 am; edited 1 time in total

	SysOp wrote:
	Would you please create a separate post with your entrancement suggestion and an example describing what you mean by "sorting the filtered results by length first?" Which length?

Sure. Here it is.