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.5 [Feb 25, 2016]
New Features and Major Changes
Major enhancements in the data import/export and related functions, including but not limited to import/export to JSON files.
Automatic data type remapping when importing or exporting from/to different types of database systems, or using the data transfer utility, or performing schema comparison between two different database types.
A number of enhancements in the data transfer utility including 1-click solution for transferring limited data samples from production to development database systems; new options to disable triggers and referential constraints in destination tables.
Similar new options added to the Test Data Generator utility to disable triggers and referential constraints in destination tables.
Test Data Generator now supports data generation for tables with self-referencing referential constraints.
Added new table scope right-click menu Export to… command to export table data to flat files in a number of different data formats.
Import from Excel utility enhanced to support multiple repetitive file imports.
Enhanced Code Structure View – related operations are now grouped together, for example, a bunch of INSERTs into a single table is now shown as a single expandable item.
New Scheduler Manager utility for managing and editing SQL Assistant’s scheduled tasks.
Support for custom connection parameters in database connection settings.
Syntax Indicator Bar stickiness in SQL Assistant’s SQL Editor (Professional Edition).
New code execution progress showing percent of work done and providing a better display of individual operations performed.
Improved Open in Excel function – automated conditional formatting in Excel files, plus ready-to-use data filtering.
Support for INTERVAL data types in Oracle, PostgreSQL, DB2, ASA, and SQL Server.
Support for WITH SCHEMABINDING clause in SQL Server procedural objects.
Added two new functions in database source code control interfaces - Undo, and Scan for Database Changes; available for Git, SVN, Perforce, and TFS.
Miscellaneous
Tons of other minor enhancements and bug fixes.
Feature-rich relational database known for its high performance and excellent concurrency
