SoftTree SQL Assistant 9.5.469 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

Here is a list of new features and enhancements in version 9.5:

Data analytics enhancements: Instant charts for query results.
New SQL Assistant native toolbars for SQL Server Management Studio, Visual Studio, Notepad++.
Multiple enhancements in the Data Compare engine including new data difference synchronization capabilities, comparison of structurally different tables, comparison of view results, and a number of other new features…
Multiple enhancements in the Schema Compare engine across all database interfaces with much deeper and richer comparison for many types of schema objects, with advanced comparison of various schema, database and server scope structures, files and tablespaces, security attributes and permissions, and so on…
IntelliSense enhancements (all databases): hints for DML operations touching tables with triggers.
IntelliSense enhancements (all databases): SQL assistance for grouped nested JOINs.
IntelliSense enhancements (all databases): advanced control over generation of alises including custom methods using regular expressions, letter casing, predefined tables of custom aliases.
IntelliSense enhancements (PostgreSQL and Pivotal Greenplum): support for event functions.
IntelliSense enhancements (PosgreSQL and Pivotal Greenplum): support for complex table aliases with renamed columns, e.g. “FROM table_reference [AS] alias(column1 [, column2 [, …]])”.
Data-grid enhancements: in-place toolbar for common operations.
New code stress-testing method added to the database Unit Testing Framework.
User interface enhancements: new advanced filtering capabilities in the Schema Compare results, hide and show objects and their attributes based on scope, regular expressions, and more.
User interface enhancements: object references diagrams can be exported to image files.
Code Structure View now offers better navigation of CTE based SQL statements.
SQL Reference enhancements for SQL Azure.
Code execution enhancements, friendlier display of long diagnostic messages and error messages: formatted multi-line messages shown on mouse-over event.
Context SQL Search now supports sorting results by columns.
Connect to Database dialog updates: user-defined connection names can be entered and updated directly in the Conenct dialog.
Improvements in Oracle OCI interface: support for OCIDateTime and OCIInterval data types.
Code formatting: improvemed PostgreSQL operator formatting.
Macro scripting enhancements: $CURRENT(…)$ macro supports new optiona for handling special symbols.
More utilities and operations can be monitored and managed now using SQL Assistant Task Manager.
Improved handling of users-defined menus and commands.
Multiple accross the board improvements in the data export and data transfer utilities: better user interface, improved reporting of progress of work, more responsive, etc…
Support for new bulk insert methods in the data-transfer utility: implementation of multi-row inserts using single INSERT operation (Oracle, SQL Server, Azure, PosgreSQL, Pivotal Greenplum, SQL Anywhere, DB2 UDB, Redshift).
Multiple performance improvements in internal operations making SQL Assistant perform many database operations faster.
Enhancements in the Database Documenter: you can now attach custom database model files and save their diagrams as part of the generated database and schema documentations.
SQL Assistant API now directly supports WinForms and WPF applications.


database, Assistant, enhancements, Oracle, Server, Provides, Microsoft, databases, interface, Studio, supports, PostgreSQL, MySQL, integrated, Sybase, their, comparison, development, multi, IntelliSense, database, Assistant, enhancements, Oracle, Server, Provides, Microsoft, databases, interface, Studio, supports, PostgreSQL, MySQL, integrated, Sybase, their, comparison, development, multi, IntelliSense