SQL Assistant equips database developers and DBAs with the productivity tools they need to speed up the database development process, improve code quality and accuracy. Depending on what you are coding, SQL Assistant could boost your SQL coding productivity by 100% or more.
-Raises SQL developer productivity
-Improves code quality and accuracy
-Integrates with many SQL and non-SQL editors
-Provides interactive SQL reference and SQL code assistance systems
-Provides advanced SQL code intellisense features, including support for databases, objects, parameters, script variables, syntax elements and more...
-Includes code formatters and beautifiers; SQL syntax validation, code structure views for fast code navigation, and more...
-Provides integrated spell checker
-Supports 7 major database systems: Oracle, SQL Server, DB2 and MySQL, Sybase ASE, Sybase ASA, MS Access, and their SQL dialects
-Fast and has small disk and memory footprint
-Can be easily installed without interrupting any existing processes and used immediately
Disk space - 5.4 MB, Memory - 128 MB, CPU - Pentium or compatible
OS - 2000/XP/2003/Vista
Supported database systems:
-Oracle 8i, 9i, 10g, 11g
-Microsoft SQL Server 2000, 2005, 2008
-DB2 UDB 7, 8, 9, 9.5
-MySQL 5, 5.1
-Sybase ASE 12, 12.5, 15
-Sybase ASA 7, 8, 9, 10
-Microsoft Access 2003, 2007
New in Version 3.5
-Use of coding history cache has been turbo-charged. Code suggestions based on historical coding patterns are available in many places.
-Eclipse plug-in. That's right, SQL Assistant can be now used with Eclipse and derivate products, including Eclipse Data Tools Platform
-Multiple column selection lists are supported in UPDATE and INSERT statement. Checkboxes have been added to these column list allowing to choose multiple columns at once.
-Multiple-column foreign keys are supported in JOIN clauses. The entire JOIN with all columns can be now added with a single mouse click or a single key-press.
-New Code Bird's View feature helps to navigate long files and scripts, supporting jumps between code fragments without scrolling and reading the actual code.
-New coding statistics and productivity gain display. Some of our internal tests achieved as much as 1200% productivity gain from using SQL Assistant! Try it for yourself.
-Additional code-wrapping options have been added to formatting rules.
-Support for batch delimiters available for all environments, including parsing and support for MySQL's DELIMITER keyword and DB2's SET TERMINATOR.
-Expanded support for Oracle objects and packages - added code IntelliSense for types, type and package constants, exception handlers and declarations, package and type scope records.
-New code block commenting/uncommenting function can be used with non-SQL editors such Notepad, UltraEdit and other not supporting such commonly used function. Numerous other minor enhancements and usability changes..
-New graphical menus for enhanced user experience.
-Numerous other minor enhancements and usability changes.