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. SQL Assistant can boost your SQL coding productivity by 300%. SQL Assistant supports all major databases. It is shipped pre-configured with support for Oracle, Microsoft SQL Server, IBM DB2, MySQL, PostgreSQL, Amazon Redshift, SQLite, Sybase ASE and SQL Anywhere. The product also offers a full-featured source control interface that supports Git, Subversion, Perforce, and Microsoft Team Foundation Server code repositories. Many users have stated they don't know how they can code and manage their databases without SQL Assistant. To get a better idea of what it can do for you, download the trial and check it for yourself.

Targets Target SQL and non-SQL editors - SQL Assistant integrates with many widely used database editors and database management and development environments including native tools that come with your database systems. It can also be used to database enable many universal code editors and used as a database development plugin.

SQL Assistant provides assistance with code typing, automatic word completion and database object and attributes completion and browsing. It provides functions for quick entry of common SQL constructs and code snippets. It also provides integrated and fully interactive SQL code assistance system for instant help with SQL command syntax and options available in specific database versions, real-time code syntax checker, spell checker and a number of other vital coding tools.

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

Triples SQL developer productivity
Improves code quality and accuracy
Provides unmatched intelligent SQL code intellisense features
Provides interactive SQL reference and SQL code assistance systems
Provides advanced SQL code formatters and beautifiers; SQL syntax validation, code structure views for fast code navigation, and more...
Provides integrated database source code control interface
Provides integrated real-time code syntax and spell checker
Provides integrated real-time code performance analyzer
Provides multi-server code execution, scheduling, multi-server code and data search and replace
Provides user extendable comparison engine for schema, database, and jobs comparison
Supports 11 major database systems: Oracle, SQL Server, DB2 UDB, DB2 for iSeries, MySQL, PostgreSQL, Redshift, Sybase ASE, Sybase ASA, SQLite, MS Access, and their SQL dialects
Provides integrated real-time code performance analyzer
Provides integrated code and data generators, unit testing and load testing framework
Integrates with many SQL and non-SQL editors
Provides full featured integrated multi-database development environment
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, 2012, 2014, 2016
SQL Query Analyzer
SQL Server Enterprise Manager
Visual Studio for Database Professionals (DataDude)
Visual Studio .NET, 2005, 2008, 2010, 2013, 2015
Visual Studio C# Express, VB Express, C++ Express, Web Developer Express
Oracle SQL Developer
Oracle JDeveloper
Eclipse
IBM Data Studio
Delphi
DB Tools for Oracle
PL/SQL Developer
Oracle SQL*Plus
Toad for Oracle
Toad for MySQL
Toad for DB2
Toad for SQL Server
PowerBuilder
PostgreSQL pgAdmin III
MySQL Query Browser
MySQL Workbench
Microsoft Access
UltraEdit
Notepad++
Notepad
...Imagine your SQL editor here...

Technical specifications:
Disk space - 22 MB, Memory - 512 MB, CPU - Pentium or compatible
OS - Windows 2000/XP/2003/Vista/2008/7/8/8.1/10
Supported database systems:

Oracle 8i, 9i, 10g, 11g, 12c
Microsoft SQL Server 2000, 2005, 2008, 2012, 2014, 2016
Windows SQL Azure 11
DB2 UDB 7.x, 8.x, 9.x, 10.x
DB2 UDB for iSeries 5.x, 6.x, 7.x, 8.x, 9.x
MySQL 5.x
Sybase ASE 12.x, 15.x
Sybase ASA (SQL Anywhere) 9.x - 14.x
PostgreSQL 8.x, 9.x
Amazon Redshift
SQLite 3.x
Microsoft Access 2003, 2007, 2010, 2013

SoftTree SQL Assistant v9.2 (maintenance release) - What's New
New Features and Major Changes
New Data-pivot and Analytics.
New experimental Code Visualizer for generating graphical code flow and sequence diagrams for procedural schema objects, views, and arbitrary SQL code.
New experimental Visual Database Documenter is a graphical documentation generator for entire schemas and databases.
New Batch Database Refactoring interface takes schema object management to a new level. With just a few mouse clicks you can change ownership of many schema objects at once, change object permissions, their execution and data access modes, attributes, perform various maintenance tasks, index rebuilds, code recompilation. No more need to do it one by one, open and close many different dialogs.
New database refactoring method for renaming schemas supporting SQL Server, Oracle, MySQL, PostgreSQL, DB2 UDB, Redshift, Netezza.
New Tab Manager for tab management and faster code navigation
User interface enhancements: name filters are now available in all tools featuring schema object trees.
User interface enhancements: hot keys for SQL Execution Plan and some other hard to reach tools.
Schema compare enhancements for PostgreSQL: comparison and synchronization of database attributes, tablespaces.
Schema compare enhancements for MySQL: comparison and synchronization of database and object permissions, table indexes, table partitions.
Schema compare enhancements for SQLite: comparison and synchronization of column default values, auto-increment columns, triggers, indexes, referential constraints.
SQL Intellisense enhancements for multiple database types: support for labels in SQL code.
SQL Intellisense enhancements for PostgreSQL and DB2: improved listing of overloaded functions in Intellisense popups.
SQL Intellisense enhancement: auto-refresh of the data dictionary cache after DDL operations can be turned off temporarily to improve performance.
Code formatting enhancements for statements containing UNION clause.
Data export enhancements: additional options for delimiters and quoting; simplified data export to XML and JSON files.
Data export enhancements: enhanced use of Export To... menu in DB Explorer for schema and databases, all schema tables can be exported at once to table specific export files.
SQL Reference enhancements for Netezza, ASA, ASE, MySQL.
Enhancements in Database Modeling: default values can be now entered for table columns and saved in the model, ON UPDATE and ON DELETE actions can be enteresd for referential constraints, table and column comments supproted as well.
New customization options provided for DDL code extraction methods.
New options for adding user-defined commands to SQL Assistant context menus for executing external process and passing data to other programs using files and/or clipboard.
Improved support for TeradР°ta: users can now create stored procedure and macros directly from SQL Assistant SQL Editor and from other target editors.
Improved support for TeradР°ta: in SQL Assistant SQL Editor database context can be changed using database name double click or database drop-down list.
MariaDB server versions 5.x and 10.x are now officially supported.
Compatibility changes for latest MySQL Workbench versions.

Miscellaneous
Many other minor enhancements and bug fixes.

Only for V.I.P