SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
SQL Assistant 11 is now available!

This topic is locked: you cannot edit posts or make replies.    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
SQL Assistant 11 is now available!
Author Message
Site Admin

Joined: 26 Nov 2006
Posts: 7857

Post SQL Assistant 11 is now available! Reply with quote
Version 11 is a new major release with many new major features and enhancements.

Here is a list of changes

New database systems
1. 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
2. Support for MySQLWorkbench v8.x.
3. Support for SQL Server Management Studio 18.x.
4. Support for Visual Studio 2019.
5. Enhanced support for Heidi SQL.

New and improved UI
6. UI themes are finally here (two dark themes, Mac like theme, Soft blue) in addition to the default theme.
7. Many improvements including "recharged" SQL Editor Professional Edition.
8. Data-grids: column reorganization, dynamic data formatting, data additions to tables without primary keys and unique indexes, and more.
9. 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...
10. Redesigned database connection dialog with integrated management of connection profiles.

Database management interfaces
11. Extended support for managing partitioned tables including automatic no-data-loss conversions from regular tables to partitioned and back.
12. Support new features of PostgreSQL 11.
13. New graphical management interface for Amazon Redshift.
14. New graphical management interface for Pivotal Greenplum.
15. New graphical management interface for Apache Hive.
16. New graphical MySQL Scheduler management.
17. New graphical pgAgent Scheduler management.
18. New graphical DB2 workload management.
19. New graphical table type editors for SQL Server and Azure SQL.
20. Management of MariaDB temporal (system versioned) tables.
21. Performance Dashboard for SQL Server.
22. Performance Dashboard for Azure SQL.
23. Performance Dashboard for MySQL.
24. Performance Dashboard for MariaDB.
25. Index defraggers for SQL Server and Azure SQL.
26. Graphical table maintenance for PostgreSQL, Pivotal Greenplum, MySQL, and MariaDB.

SQL Intellisense and its dependencies
27. New SQL Reference for MariaDB v10.
28. New SQL Reference for Apache Hive.
29. New SQL Reference for Apache SparkSQL.

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

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

Database Source Code Control
35. 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
36. Support for external and partitioned tables in DB Explorer, in graphical database management dialogs, and in the schema comparison engine.
37. 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.
38. Oracle ADO.NET connections now support SYSDBA option.
39. Many other minor and not so minor improvements.
Fri Jul 26, 2019 2:30 am View user's profile Send private message
Display posts from previous:    
This topic is locked: you cannot edit posts or make replies.    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.