SoftTree SQL Assistant 11.0.35 Enterprise Edition
SoftTree SQL Assistant 11.0.35 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
Eclipse
IBM Data Studio
Delphi
DB Tools for Oracle
PL/SQL Developer
Oracle SQL*Plus
Toad for Oracle
Toad for MySQL
Toad for DB2
Toad for SQL Server
PowerBuilder
PostgreSQL pgAdmin III
MySQL Query Browser
MySQL Workbench
Microsoft Access
UltraEdit
Notepad++
Notepad
...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.0 (major release) - What's New
New Features and Major Changes
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, graphical schema management, data import/export, schema compare, etc.. we got it all.
New and improved integration with other development tools
Support for MySQL Workbench 8.x.
Support for SQL Server Management Studio 18.x.
Support for Visual Studio 2019.
Support for Microsoft Access 16.0 (2016 - Office 365).
Enhanced support for Heidi SQL.
New and improved UI
UI themes are finally here (two dark themes, Mac like theme, soft blue theme) 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 for 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 management interface for Apache SparkSQL.
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 functions 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 bulk 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, in graphical database management dialogs, and in 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.
New Features and Major Changes
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, graphical schema management, data import/export, schema compare, etc.. we got it all.
New and improved integration with other development tools
Support for MySQL Workbench 8.x.
Support for SQL Server Management Studio 18.x.
Support for Visual Studio 2019.
Support for Microsoft Access 16.0 (2016 - Office 365).
Enhanced support for Heidi SQL.
New and improved UI
UI themes are finally here (two dark themes, Mac like theme, soft blue theme) 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 for 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 management interface for Apache SparkSQL.
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 functions 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 bulk 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, in graphical database management dialogs, and in 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.
Only for V.I.P Warning! You are not allowed to view this text.