SoftTree SQL Assistant is an application that enables you to develop databases in a more efficient manner than other similar programs. It also assists you with increasing the accuracy of codes generated for specific software projects. This piece of software offers support for numerous database editors, such as DB Tools for Oracle, Delphi, IBM Data Studio, MS Enterprise Manager, MS Manager Studio, PL/SQL Developer, SQL Plus W, Ultra Edit, and many others, as well as database development environments.
Although SQL Assistant is able to fulfill multiple, complex tasks; it was designed with a sleek interface, so that you are able to easily manage it. Furthermore, to optimize projects performed using this application, SQL Assistant includes Source Control, Data Generator and Code Snippets features. These features ensure that the program has a highly flexible configuration.
As expectable for an application that was designed to improve database development, SQL Assistant also integrates a code formatting option. In order to use this feature, you should access the “Code Formatting” menu, located in the upper side of the main window. Furthermore, the program enables you to choose the desired format style, and then select the specific formatting rule.
All in all, SQL Assistant is a handy tool that successfully optimizes your database creation and management processes. In addition to this, the utility works smoothly, and integrates seamlessly with your system's background processes, so that it does not interfere with other applications that might be running at the same time.
v7.2 [Jun 1, 2015]
- Completely reworked schema and job comparison engines adding many new features.
- New advanced Schema and Job comparison for Oracle.
- New advanced Schema and Job comparison for DB2 UDB.
- A number of other across the board enhancements in the schema comparison engine and queries, including new extensions for SQL Server, Windows Azure, SQLite, MySQL, PostgreSQL.
- New search functions in the result data grids.
- Many significant enhancements for supporting latest DB2 versions and features. Expanded support for a number of schema object types including but not limited to modules, sequences, types, and type members, etc…
- Many significant enhancements for supporting latest Oracle versions and features. Expanded support for a number of schema object types including but not limited to materialized views, nested tables, object tables, overloaded package and type methods, etc…
- New data libraries added to the test data generator, including robotic parts, wine list, food ingredients, ore production, and more.
- Improved support for PostgreSQL code reverse-engineering for functions and aggregates.
- Support for virtual tables in SQLite.
- Integrated SQL Editor can now execute code in multiple databases concurrently using independent execution threads
- New hot keys for working with the sync-edit feature available in the integrated SQL Editor.
- Compatibility changes for latest versions of Toad.
Feature-rich relational database known for its high performance and excellent concurrency
