Download SoftTree SQL Assistant Enterprise v12.1.279

SoftTree SQL Assistant Enterprise v12.1.279

SoftTree SQL Assistant Enterprise v12.1.279
SoftTree SQL Assistant Enterprise v12.1.279

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

Short introduction

We believe the new personal workspace database feature introduced in 12.1 delivers great productivity boost. This feature supports super simple methods for saving the data you work with, and quickly retrieving it later without needing to rerun long running queries again; and then comparing historical results saved over a period of time. It also enables advanced data analysis and data enrichment, across data sources data aggregations, and so on. As a teaser, imagine clicking a data grid populated with results of a long running query, selecting "Save to Workspace", and then using SQL queries or other built-in tools to join saved grid results with data from another database, another data grid, or with data from an external CSV file.
New database systems and interfaces

Support for Apache Cassandra and DataStax Enterprise databases, with full CQL/SQL intellisense, full graphical schema management. Most SQL Assistant tools and features available for relational SQL databases can be used with Cassandra too, including direct data migration to and from other databases.
Support for Snowflake databases and warehouses, most SQL Assistant tools and features available for relational databases can be used with Snowflake, including advanced SQL Intellisense, schema compare, data export and import, and so on...
Enhanced support for SQLite with new built-in native driver connections enabling use of regular expressions in SQL queries, table and index space usage stats, JSON data handling, attaching external data files as tables, supported by Visual Database Documenter, Schema Compare, and other SQL Assistant tools now enabled for SQLite.

New major features and significant enhancements

Personal workspace database, simply put this is the new productivity enhancement that can change how you work with your databases. With a couple of clicks you can now save data grids and results of queries to your personal workspace and then return to them later, query them like other tables, join/enrich with other data, and of course update their data too! We believe this new feature redefines the meaning of productive database development and analytical use. Easily much and mix data from different database, catalog and save query results and more, its your personal database that you can share with others too.
Many enhancements in the SQL History. The entire feature has been completely redesigned and now supports storing history for long time, not limited to the current session time; It now supports fuzzy searches and code filtering, enables reusing historical SQL statements across databases, provides more efficient UI with important details shown at the top of the queries and not important details compressed or hidden by default.
New and enhanced functions for working with CSV files. You can use the new Data File Query utility to query and update data in CSV files as if they were tables in a relational database using full power of SQL language, regular expressions, transactions, and so on...
The new Data File Transformation utility further extends advanced support for CSV files, enabling you to add, remove, modify, and rearrange columns, remove duplicate data, pivot columns and rows, filter using regular expressions, and make other transformational file changes, all that without needing a desktop spreadsheet program.
Many small and not so small SQL Intellisense enhancements including but not limited to advanced intellisense for index specific DDL operations, triggers, smarter Intellisense for schema context, suggestions for arguments for built-in database functions, improved JOINs suggestions display differentiating referenced and referencing tables, and more.
Improvements in Database Messages pane including new searching and filtering capabilities, integration with SQL History, and so on...
Significant changes in how SQL Assistant's Reports handle their queries. You can now use SQL scripts with multiple statements to retrieve the report data.
Now supporting data exports to Parquet files.

Database management enhancements

All supported databases - the Update Statistics utility is now run in the background, you can continue working while it's updating table statistics in the database.
PostgreSQL - Graphical dashboard and session monitors for PostgreSQL now show progress of work of long operations (PostgreSQL 11.x and later).
PostgreSQL - enhanced handling of partitioned tables, including but not limited to better SQL Intellisense, scripting DDL for the common table and all its partitions in one atomic operation.
PostgreSQL - Top Functions graphical monitor.
SQLite - Table and index space usage statistics.
Oracle - Graphical partition and subpartition manager.


Updated add-ons for Visual Studio 17 and previous versions which now enable using SQL Assistant immediately after the installation and don't require installing additional database specific extensions, like Visual Studio Database Tools or T-SQL Query Editor.
SQL Assistant's SQL Editor now preserves BOM in Unicode script files saved with BOM, as well as it can add BOM if such file encoding is selected.
SQL Assistant can better support automatic Windows updates and can automatically recover its environment after updates and restarts.
A number of other minor improvements.

Only for V.I.P
Warning! You are not allowed to view this text.
  • 21