This item is available via subscriptions only

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
IBM Data Studio
DB Tools for Oracle
PL/SQL Developer
Oracle SQL*Plus
Toad for Oracle
Toad for MySQL
Toad for DB2
Toad for SQL Server
PostgreSQL pgAdmin III
MySQL Query Browser
MySQL Workbench
Microsoft Access
...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 v12.0 (major release) - What's New

New database systems

Now supporting MongoDB with MongoDB Connector for BI.

New major features

Full featured reporting with integrated report designer, templates and wizards, and numerous predefined administrative reports.
New ETL Orchestrator for automating ETL and ELT tasks, and other repetitive database processes.
Completely reworked Load Generator, upgraded to Database Benchmarking with ready-to-run templates for simulating real life applications and for application and database performance benchmarking.
New multifunctional task-oriented SQL Profiler for PostgreSQL.
New multifunctional task-oriented SQL Profiler for Oracle.
Data import and export from/to Parquet files.
New Oracle Table and Index Defragger.
New plugins for Eclipse 4.x platform, and for DBeaver 20.x.
New Oracle Tablespace Manager with graphical space allocation maps.
New universal Go To menu for quickly jumping to specific lines, bookmarks, regions, etc...

Significant enhancements

Greatly improved intellisense for DDL commands including in place suggestions for specific objects and options, graphically selected changes, and more.
Support for high resolution monitors with high DPI.
Bootstrap queries for new database connections.
Many enhancements in the source code control interfaces, supporting now all recognized object types, code branching, ignore lists and filtering for insignificant and unwanted objects, new and improved advanced wizard for source control project and repository setup, and so on...
Source code control for TFS now supports non-English based environments. Source code control for Perforce now supports different file encodings.
Code Structure View is enhanced with code regions.
New SQLite databases can be now created directly from the Connection dialog.
Unit testing framework now supports all SQL Assistant recognizable object types.
Unit testing framework can now save unit test execution results in an unified XML format supporting multiple result sets and types of unit test outputs; enabling reading results from upstream test cases and feeding them to downstream test cases.
Unit testing framework now supports advanced validation of test case results using multiple new methods including custom SQL queries, Visual Basic scripting, Pascal scripting, etc...
Schema Compare and visual schema management tools for SQL Server and Azure now support XML indexes and Spatial indexes.
Asynchronous execution of Data Transfer and XML Import/Export tasks.
Enhanced data scripting functions with support for multi-row inserts and several other new options.
Enhancements for interactive code snippets, the $OBJECT$ code automation macro now supports many new types of schema objects.
Improved integration with MS Access, not supporting full featured popup SQL editor with code highlighting, SQL Intellisense, DB Explorer, Code Structure, and all other functions supported by SQL Assistant.
Improved integration with Visual Studio 2017 and 2019, now supporting scripts opened from the Server Explorer.

Other enhancements

Compatibility changes with latest database versions.
Tons of other minor and not so minor improvements, too many to fit here.

No comments found.
Login to post a comment
This item has not received any review yet.
Login to review this item
No Questions / Answers added yet.
Recently viewed items

We use cookies to understand how you use our website and to improve your experience. This includes personalizing content and advertising. To learn more, please click Here. By continuing to use our website, you accept our use of cookies, Privacy policy and terms & conditions.