SQL Assistant is fast and can be used with both very small and very large database systems. It is also very flexible and can be easily customized by users to match their coding habits.
Key Features and Benefits* Doubles SQL developer productivity
* Improves code quality and accuracy
* Provides advanced SQL code intellisense features, including support for databases, objects, parameters, script variables, syntax elements and much more...
* Provides interactive SQL reference and SQL luxter2.ru code assistance systems
* Provides advanced SQL code formatters and beautifiers; SQL syntax validation, code structure views for fast code navigation, and more...
* Provides integrated real-time code syntax and spell checker
* Supports 8 major database systems: Oracle, SQL Server, DB2, MySQL, PostgreSQL, Sybase ASE, Sybase ASA, MS Access, and their SQL dialects
* Integrates with many SQL and non-SQL editors
* Fast and has small disk and memory footprint
* Can be easily installed without interrupting any existing processes and used immediately
Pre-configured targets:* SQL Server Management Studio 2005/2008
* SQL Query Analyzer
* SQL Server Enterprise Manager
* Visual Studio for Database Professionals (DataDude)
* Visual Studio .NET/2005/2008
* Visual Studio C# Express, VB Express, C++ Express, Web Developer ExpressNew
* EclipseNew
* DB Tools for Oracle
* PL/SQL Developer
* Oracle SQL*Plus
* Toad for Oracle
* Toad for MySQL
* Toad for DB2
* Toad for SQL Server
* PowerBuilder 7/8/9/10.x/11.xNew
* PostgreSQL pgAdmin IIINew
* MySQL Query Browser
* Microsoft Access
* UltraEdit
* Notepad
* ...Imagine your SQL editor here...
New in Version 4.01. New real-time syntax checker automatically highlights syntax errors, incorrect object and column names, undeclared variables etc...
2. Rebuild SQL Formatter – industry's most advanced SQL, T-SQL, PL/SQL, MySQL, … code formatter and beautifier supports multiple code layout and formatting styles, provides great extensibility, and code layout customization features.
3. Multi-server SQL script execution function allows one-click code execution on multiple servers.
4. Support for Postgre SQL.
5. Support for DB2 for iSeries.
6. Updated SQL References for Oracle 11g and DB2 9.5
7. New manual and self-check for updates feature with automatic downloading and installation of new versions, by default set to weekly schedule.
8. New _WOW_ code snippets for SQL Server and MySQL. Do not miss them, try them as soon as you get this upgrade!
9. New preconfigured targets for pgAdmin III.
10. New preconfigured targets for PowerBuilder.
11. New preconfigured targets for "Express" versions of Visual Studio 2008.
12. Targets for Visual Studio 2005/2008 enhanced to activate SQL Assistant only in files with .SQL and .DDL extensions and in the SQL query builder window.
13. Updated "Objects (MSSQL)" query now supports INFORMATION_SCHEMA in SQL Server 2005/2008 systems.
14. Filters tightened for Toad based targets to eliminate popups in inappropriate places.
15. SQL Assistant's configuration files moved to user's Application Data folder to simplify installation and use via Remote Desktop and on Windows Vista systems..
16. Numerous other minor enhancements and usability changes.
Supported database systems:* Oracle 8i, 9i, 10g, 11g
* Microsoft SQL Server 2000, 2005, 2008
* DB2 UDB 7, 8, 9, 9.5
* DB2 UDB for iSeries
* MySQL 5.x
* Sybase ASE 12.x, 15.x
* Sybase ASA 7, 8, 9, 10
* PostgreSQL 8.x
* Microsoft Access 2003, 2007
