SoftTree SQL Assistant 11.0 BETA

The ultimate tool for SQL developer productivity!

 

Beta Agreement  Review Beta Tester Agreement before you download the beta release.


What's new in version 11.0

New UI

New database systems

  • Now supporting Apache Hive and Apache SparkSQL. Working with Hadoop using SQL Assistant + Hive or SparkSQL now is as simple as working with MySQL, SQL Server, and other database systems you already know well. Same kind of treatment for tables, views, SQL Intellisense, SQL commands and query execution, data import/export, schema compare, etc.. we got it all.

New and improved integration with other development tools

  • Support for MySQLWorkbench v8.x.
  • Support for SQL Server Management Studio 18.x.
  • Support for Visual Studio 2019.
  • Enhanced support for Heidi SQL.

New and improved UI

  • UI themes are finally here (two dark themes, Mac like theme, Soft blue) in addition to the default theme.
  • Many improvements including "recharged" SQL Editor Professional Edition.
  • Data-grids: column reorganization, dynamic data formatting, data additions to tables without primary keys and unique indexes, and more.
  • Redesigned progress of work dialogs for all kinds of batch operations with at a glance summary object processing statuses, including data imports/exports, code and data generation, load and unit testing, and so on...
  • Redesigned database connection dialog with integrated management of connection profiles.

Database management interfaces

  • Extended support for managing partitioned tables including automatic no-data-loss conversions from regular tables to partitioned and back.
  • Support new features of PostgreSQL 11.
  • New graphical management interface for Amazon Redshift.
  • New graphical management interface for Pivotal Greenplum.
  • New graphical management interface for Apache Hive.
  • New graphical MySQL Scheduler management.
  • New graphical pgAgent Scheduler management.
  • New graphical DB2 workload management.
  • New graphical table type editors for SQL Server and Azure SQL.
  • Management of MariaDB temporal (system versioned) tables.
  • Performance Dashboard for SQL Server.
  • Performance Dashboard for Azure SQL.
  • Performance Dashboard for MySQL.
  • Performance Dashboard for MariaDB.
  • Index defraggers for SQL Server and Azure SQL.
  • Graphical table maintenance for PostgreSQL, Pivotal Greenplum, MySQL, and MariaDB.

SQL Intellisense and its dependencies

  • New SQL Reference for MariaDB v10.
  • New SQL Reference for Apache Hive.
  • New SQL Reference for Apache SparkSQL.

Schema comparison engine

  • Comparison of partitioned and external tables for all supported database system types.
  • Significantly enhanced DB2 schema compare including comparison of virtually all kinds of database objects and their attributes.

Data export/import, and data scripting

  • Now supporting an array of bulk data insert methods using native connectivity, ADO.NET and ODBC interfaces for very fast data loading.
  • Enhanced data imports using INSERT commands with bind parameters for cases when build inserts cannot be used.
  • Data exports and data scripting can now be scheduled to run at predefined times.

Database Source Code Control

  • Source Code Control now supports all types of database objects that can be scripted, and not just tables, views, and procedural code as in the previous versions.

Other enhancements

  • Support for external and partitioned tables in DB Explorer, by database management interfaces, and by the schema comparison engine.
  • Redesigned SQL Preprocessor pane - no longer requires manual activation, can be turned on and off in the options and works silently in the background just like a code preprocessor works in C/C++ development environments.
  • Oracle ADO.NET connections now support SYSDBA option.
  • Many other minor and not so minor improvements.

 

Support Forum  - SQL Assistant Support Forum. This forum contains messages from people using SQL Assistant. Browse or search to find answers for your questions, and to report issues with running SQL Assistant.

 


Other Information
Last version:
v11.0.12.BETA
Build Date: July 8, 2019

Technical specifications:

Disk space - 270 MB for full installation
Supported database systems:
  • Oracle 8i, 9i, 10g, 11g, 12g, 18c
  • Microsoft SQL Server 2000, 2005, 2008, 2012, 2014, 2016, 2017
  • Microsoft SQL Azure 11.x, 12.x
  • PostgreSQL 8.x, 9.x, 10.x, 11.x
  • Apache Hive 2.x, 3.x
  • Apache SparkSQL 2.2, 2.3, 2.4
  • DB2 UDB 7.2, 8.x, 9.x, 10.x, 11.x
  • DB2 UDB for iSeries 5.x, 6.x, 7.x
  • MySQL 5.x, 8.x
  • MariaDB 5.x, 10.x
  • SAP Adaptive Server Enterprise 12.x, 15.x, 16.x
  • SAP SQL Anywhere 7-16
  • Amazon Redshift
  • Microsoft Access 2003, 2007, 2010
  • Teradata 14.x, 15.x, 16.x
  • IBM Netezza 7.x
  • Pivotal Greenplum 4.x
  • SQLite 3.x
Database connections via OCI, LibMySQL, LibPQ, LibMariaDB, SMO, ODBC, ADO.NET
Download now Download SQL Assistant v11.0 BETA version
(55 MB)

PDF

On-line documentation
v11.0 (15 MB)