SoftTree SQL Assistant v11.2.246 Enterprise Edition

SoftTree SQL Assistant v11.2.246 Enterprise Edition
SoftTree SQL Assistant v11.2.246 Enterprise Edition

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 v11.2 (maintenance release) - What's New

New Features and Major Changes
New tools added to SQL Assistant toolset

Clone It - New utility for cloning databases, schemas, and individual database and schema scope objects.
Table Columns Usage report - Simplified tracking of table usage with columns specific references in various database procedures, constraints, etc...

Productivity and Intellisense enhancements

SQL Intellisense enhancements - Displaying used and unused columns in different colors to aid with spotting missing columns.
SQL Intellisense enhancements - Better intellisense for HAVING and GROUP BY clauses with automatic suggestions for multiple columns based on their references in other parts of the same query.
SQL Intellisense enhancements - Recognizing inner functions in Oracle PL/SQL packages and types.
SQL Intellisense enhancements - enhanced filling of values in UPDATE statements.
Data grids - Selective columns freezing.
Data grids - One click auto-fixing grid columns width to show full content.
Data grids - Memorizing column specific display formats as well as better management of common user-defined display format styles for different data types.
Data grids - Supporting Unicode data coping to Clipboard

SQL Editor IDE enhancements

Unique features for Oracle developers - multi-dimensional views of the server with database Edition drop-down and container Database drop-downs added to the toolbar for on the fly switching between different editions and different PDBs.
Query execution timing statistics shown automatically in the Message pane.
New advanced File Search and Replace supporting regular expressions, automatic file backups before changes, logging, etc.
Code folding - User defined regions are now mapped on the syntax bar and can be used for fast code navigation.

Database specific enhancements

PostgreSQL - Now supporting latest PostgreSQL version 12.
PostgreSQL - Support for geometry data types.

Oracle - Recognition of Oracle editionable schema object properties and support for schema editions.
Oracle - Support for pluggable databases and their graphical management.
Oracle - Graphical database backup and restore.
Oracle - DDL generated for tables now includes all their direct dependencies such as indexes, triggers, etc...
Oracle - Support for two new index types: bitmap join and cluster indexes.
Oracle - Support for "inmemory" join group.
Oracle - Support for analytical views.
Oracle - Enhanced DBMS_OUTPUT interface supporting long messages printed via DBMS_OUTPUT package.
Oracle - ADO.NET based connections now support Oracle LONG data types.
Oracle - Added Java Class object type to DB Explorer and schema management.

SQL Server - New graphical management interface for SQL Agent, job scheduling, and alerting.
SQL Server - Performance Monitor now supports SQL Server instances running on Linux systems.
SQL Server - Performance Monitor added page life expectancy chart for enhanced monitoring of buffer cache usage.

Redshift - Support for materialized views.
Redshift - Support for stored procedures.

Multiple new graphical database and schema management dialogs with especially big push focused on Oracle schema management.

Improvements made in other utilities

Test data generator - Seed data libraries can be optionally defined by SQL queries fetching data from external databases (note that's quite different from the lookup tables supported before and now too).
Test data generator - Improved project management interface.
Test data generator - Unicode is now supported in data libraries.
Database Source Code Control - Improved automated scheduled syncing of database changes to repository, and from repository back to the database.
Data import - Supporting for tab separated files.
Schema compare - tons of improvements across the board, with deeper database analysis and more accurate results.

Improved Options and customizations

Many enhancements in the Options dialog, including copying code formatting rules between styles.
New search in the options (there are now over 2000 customizable options), as well as in code snippets, formatting rules, unit test cases, code generator macros, and so on...
Greater control of types of database and schema object shown in DB Explorer, intellisense prompts, and in other places.
Improvements in UI themes, now supporting options for coloring regular expressions and template lexers.
Sticky size data columns in various too remembering your changes.

Bug fixes

Database Source Code control - Multiple defects fixed in Git interface.
Fixed significant regression introduced in version v11.1 which affected code formatting, causing in some cases disappearance of UNION keywords.
Over 150 other defects fixed.

Users of Guests are not allowed to comment this publication.