SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
SQL Assistant version 12.0 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 version 12.0 released
Author Message
Site Admin

Joined: 26 Nov 2006
Posts: 7883

Post SQL Assistant version 12.0 released Reply with quote
Here is what's new in version 12.0

New database systems
1. Now supporting MongoDB with MongoDB Connector for BI.

New major features
2. Full featured Reporting with integrated report designer, templates and wizards, and numerous predefined database administrative reports.
3. New ETL Orchestrator for automating ETL tasks and other processes.
4. Completely reworked Load Generator, converted to Database Benchmarking with ready-to-run templates for simulating real life applications and for application and database performance benchmarking.
5. New multifunctional task-oriented SQL Profiler for PostgreSQL.
6. New multifunctional task-oriented SQL Profiler for Oracle.
7. Data importing and exporting from/to Parquet files.
8. New Oracle Table and Index Defragger.
9. New plugins for Eclipse 4.x platform, and for DBeaver 20.x.
10. New Oracle Tablespace Manager with graphical space allocation maps.
11. New universal Go To command for SQL Assistant database development environment (a.k.a. SQL Editor Professional Edition) for quickly jumping to specific lines, bookmarks, regions, etc...

Significant enhancements
12. Greatly improved intellisense for DDL commands including in place suggestions for specific objects and options, graphically selected changes, and more.
13. Support for high resolution monitors with high DPI.
14. Bootstrap queries for database connections.
15. Very significant enhancements in the source code control interfaces, supporting now all recognized object types, code branching, ignore lists and filtering for insignificant and unwanted objects, new and improved advanced wizard for source control project and repository setup, and so on...
16. Source code control for TFS now supports non-English based environments. Source code control for Perforce now supports different file encodings.
17. Code Structure View is enhanced with code regions.
18. New SQLite databases can be now created directly from the Connection dialog.
19. Unit testing framework now supports all SQL Assistant recognizable object types.
20. Unit testing framework can now save unit test execution results in an unified XML format supporting multiple result sets and types of unit test outputs; enabling reading results from upstream test cases and feeding them to downstream test cases.
21. Unit testing framework now supports advanced validation of test case results using multiple new methods including custom SQL queries, Visual Basic scripting, Pascal scripting, etc...
22. Schema Compare and visual schema management tools for SQL Server and Azure now support XML indexes and Spatial indexes.
23. Asynchronous execution of Data Transfer and XML Import/Export tasks.
24. Enhanced data scripting functions with support for multi-row inserts and number of other new options.
25. Enhancements for interactive code snippets, the $OBJECT$ macro now supports many new types of schema objects.
26. Enhanced support for MS Access - full featured popup SQL editor with code highlighting, SQL Intellisense, DB Explorer, Code Structure, and all other functions supported by SQL Assistant.
27. Improved integration with Visual Studio 2017 and 2019, now supporting scripts opened from the Server Explorer.

Other enhancements
28. Compatibility changes with latest database versions.
29. Tons of other minor and not so minor improvements, too many to fit here.
Mon Oct 25, 2021 3:59 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.