SQL Assistant to increase DBA productivity

STATEN ISLAND, USA: SoftTree Technologies, provider of database management and development solutions has announced that new version 4.6 of SQL Assistant enables database developers and DBAs to multiply their productivity and improve their code quality and accuracy.

The new version has been enhanced with the following features:

* 4th generation SQL Intellisense and code-completion technology dramatically reduces SQL programming time.

* Real-time syntax lookup, in-place prompts and checking eliminate the need to reach out to printed manuals or browse the web searching their electronic versions.

* Visual Bookmarks transforms what is today an obscure and rarely used function available in many code editors into one that even seasoned coders will grow to love and use often.

* Syntax help is enhanced via mouse-over hints for procedure and function parameters and for table and view columns for objects whose names contain spaces and special symbols.

* One-click comparison of code in the editor against code in database, files, other editors streamlines error checking processes.

Version 4.6 strengthens SQL Assistant’s position as the market’s most sophisticated SQL programming productivity tool. Its ability to eliminate up to 300 percent of keystrokes, automatically generate high quality SQL code, correct SQL syntax and spelling errors, use historical coding patterns to suggest commonly used queries will turbo-charge developer productivity.

SQL Assistant 4.6 supports all major databases. It is shipped pre-configured with support for Oracle, Microsoft SQL Server, IBM DB2, MySQL, PostgreSQL, Sybase ASA and ASE.

The product also integrates with many widely used database editors, database management and development environments, as wells as DBMS native utilities.