SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
SQL Assistant maintenance version 11.2 released

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 maintenance version 11.2 released
Author Message
Site Admin

Joined: 26 Nov 2006
Posts: 7859

Post SQL Assistant maintenance version 11.2 released Reply with quote
SQL Assistant maintenance version 11.2 is now available. It's a very significant version with lots of updates. We had been considering it for releasing as a new major version, but ultimately decided to stick with our maintenance release schedule and release it as a maintenance version.

Here is a list of changes in v11.2

New tools added to SQL Assistant toolset
1. Clone It - New utility for cloning databases, schemas, and individual database and schema scope objects.
2. Table Columns Usage report - Simplified tracking of table usage with columns specific references in various database procedures, constraints, etc...

Productivity and Intellisense enhancements
3. SQL Intellisense enhancements - Displaying used and unused columns in different colors to aid with spotting missing columns.
4. SQL Intellisense enhancements - Better intellisense for HAVING and GROUP BY clauses with automatic suggestions for multiple columns based on their references in other parts of the same query.
5. SQL Intellisense enhancements - Recognizing inner functions in Oracle PL/SQL packages and types.
6. SQL Intellisense enhancements - enhanced filling of values in UPDATE statements.
7. Data grids - Selective columns freezing.
8. Data grids - One click auto-fixing grid columns width to show full content.
9. Data grids - Memorizing column specific display formats as well as better management of common user-defined display format styles for different data types.
10. Data grids - Supporting Unicode data coping to Clipboard

SQL Editor IDE enhancements
11. Unique features for Oracle developers - multi-dimensional views of the server with database schema Edition drop-down and container Database drop-downs added to the toolbar for on the fly switching between different editions and different PDBs.
12. Query execution timing statistics shown automatically in the Message pane.
13. New advanced File Search and Replace supporting regular expressions, automatic file backups before changes, logging, etc.
14. Code folding - User defined regions are now mapped on on the syntax bar and can be used for fast code navigation.

Database specific enhancements
15. PostgreSQL - Now supporting latest PostgreSQL version 12.
16. PostgreSQL - Support for geometry data types.
17. Oracle - Recognition of Oracle editionable schema object properties and support for schema editions.
18. Oracle - Support for pluggable databases and their graphical management.
19. Oracle - Graphical database backup and restore.
20. Oracle - DDL generated for tables now includes all their direct dependencies such as indexes, triggers, etc...
21. Oracle - Support for two new index types: bitmap join and cluster indexes.
22. Oracle - Support for "inmemory" join group.
23. Oracle - Support for analytical views.
24. Oracle - Enhanced DBMS_OUTPUT interface supporting long messages printed via DBMS_OUTPUT package.
25. Oracle - ADO.NET based connections now support Oracle LONG data types.
26. Oracle - Added Java Class object type to DB Explorer and schema management.

27. SQL Server - New graphical management interface for SQL Agent, job scheduling, and alerting.
28. SQL Server - Performance Monitor now supports SQL Server instances running on Linux systems.
29. SQL Server - Performance Monitor added page life expectancy chart for enhanced monitoring of buffer cache usage.

30. Redshift - Support for materialized views.
31. Redshift - Support for stored procedures.

32. Multiple new graphical database and schema management dialogs with especially big push focused on Oracle schema management.

Improvements made in other utilities
33. Test data generator - Seed data libraries can be optionally defined by SQL queries fetching data from external databases (note that's quite different from the lookup tables supported before and now too).
34. Test data generator - Improved project management interface.
35. Test data generator - Unicode is now supported in data libraries.
36. Database Source Code Control - Improved automated scheduled syncing of database changes to repository, and from repository back to the database.
37. Data import - Supporting for tab separated files.
38. Schema compare - tons of improvements across the board, with deeper database analysis and more accurate results.

Improved Options and customizations
39. Multiple enhancements in the Options dialog including copying code formatting rules between styles.
40. New search in the configuration options (there are now over 2000 customizable options), in code snippets, formatting rules, and so on...
41. Greater control of types of database and schema object shown in DB Explorer and other places.
42. Improvements in UI themes, now supporting options for coloring regular expressions and template lexers.
43. Sticky size and width of data columns with various utilities.

44. Many other minor enhancements.
45. Database Source Code control - Multiple defects fixed in Git interface.
46. Fixed significant regression introduced in version v11.1 affecting code formatting and causing in some cases UNION keywords disappear from the reformatted code.
47. Over 150 other defects fixed.

Here is a link to the list of changes in the previous 11.1 maintenance major release
Mon Jun 29, 2020 6:06 pm 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.