SQL Assistant ver.4.8 private build is available for testing

Private build of SQL Assistant version 4.8 is now available for local testing and preview.

NOTE: This is a preview version. Additional changes might be made before retail version 4.8 is released. If you are interested in trying it, please email to support to obtain a download link. In order for this version to install correctly on your system, you must have a valid license with a valid maintenance option.

New features and enhancements
1. Redesigned SQL Intellisense for forced invocations using Ctrl+Space hotkey. Forced Intellisense prompts are now much smarter and in most cases match functionality of automatic while-you-type context prompts.
2. SQL Assistant now supports latest version of MySQL clients and server software v5.4.
3. Column-name based JOIN suggestions are now available for use with Oracle synonyms.
4. Column-level for JOIN suggestions is now automatically expanded if choice of tables available for joining is 4 or less.
5. New choice is available for Always Add Delimiters – Never
6. Scripting Table Data function now supports breaking long scripts into batches and adding progress of work messages. (bcp utility style)
7. Performance optimizations of data-preview. SQL Assistant is now using query syntax allowing the database server to choose the best execution plan. Performance gain for data-preview typically exceeds 400% in SQL Server and Oracle, when data-preview is used with large tables and complex views.
8. Forced auto-complete (Ctrl+Space) is now supported for partially entered variable names beginning with @ prefix.
9. All SQL Reference popup windows can be closed without reaching the mouse, using just the ESC key.
10. Fonts in SQL Assistant Options dialogs replaced with TrueType fonts optimized for multiple screen resolutions.
11. Support added for latest versions of ApexSQL using new type of SQL Editor.
12. First time database connections are now validated for consistency. That is to assist novices, who often choose mismatching database connection and SQL assistance types, and later struggle with various errors.

Bug fixes:
1. SQL Assistant add-on registration for SQL Server Management Studio and SQL Server Management Studio Express may fail if certain system files are missing on the target system..
2. Incorrect line highlighting after * symbol in several types of editors when * appears in the top line.
3. Issue causing conflicts with Notepad++ and other Scintilla based editors – before the fix non-Latin characters couldn't be entered while SQL Assistant was used.
4. Syntax-check bar moves horizontally when using SQL Assistant with MySQL Query Browser, syntax auto-check turned off and using horizontal scrolling.
5. TAB key cannot be used as an item selection key with Scintilla based editors.
6. Incorrect highlighting of syntax errors in several types of SQL Server editors – wrong line is highlighted on the screen.
7. Erratic data-type prompts
8. SQL parser hanging while parsing certain types of MySQL backup scripts.
9. SQL Assistant encloses local variable names in double quotes when name = keyword.
10. Secondary FROM clause is inserted into certain types of SELECT queries when SQL Assistant prompt is invoked in a middle of existing query.
11. SQL Assistant crashes while importing from previously saved settings if the Import Options dialog is invoked while the About tab is active and a settings file.
12. Background syntax check interferes with and could abort code execution.
13. Alias are automatically generated and added to tables and columns in queries generated after picking a table or view in a prompt following SELECT keyword.
14. SQL Assistant looses database connection context and misses database context changes occurring during code execution in SQL Server Management Studio.
15. Bug causing " unsupported buffer type" error with certain types of MYSQL client and server software packages.

Last edited by SysOp on Wed Oct 14, 2009 10:43 pm; edited 2 times in total

so when will this version release?

As of Monday this week, there were couple of issues that we needed to fix in 4.8 before making a public release. No exact ETA is known at the moment, could be really any time, maybe today, maybe next week.

FYI: version 4.8 has been released.

	Quote:
	10. Fonts in SQL Assistant Options dialogs replaced with TrueType fonts optimized for multiple screen resolutions.

Cooool...appreciate for your great work.cheers!