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.3 [Dec 26, 2015]
New Features and Major Changes
Completely reworked database source code control adding many new features, now supporting Git, Github, and Perforce in addition to SVN and TFS. Among many changes are transition to asynchronous background operations, support for more object types, propagation of item change statuses across the folder trees, fast predefined status change filters, and more.
Incremental improvements in the SQL Intellisense engine, including support for multiple CTE expressions in a single query, user-defined data types in PostgreSQL, Intellisense for additional types of ALTER and DROP commands, expanded support for triggers.
SQL Intellisense now supports more sorting and filtering methods for matching user input and optimization of suggestions.
New Data Transfer tool for copying data between different databases including data conversions between disparate database systems.
Automatic reconnection of broken database connections.
A number of enhancements in the refactoring functions which are now database version aware and can apply version specific refactoring templates.
Changes in code formatting and beatification functions for improved formatting of data types in variable and parameter declarations, functions returning tabular result sets, etc...
Enhanced display of aggregated and detailed row counts for a schema or entire database, yes, that one-click display of row counts for all tables in a schema or a database.
SQL Assistant's settings can now be exported and imported to/from XML files.
New command line interface for the schema compare, and job compare too.
Enhanced display of session information in SQL Assistant's integrated SQL Editor Professional Edition.
Support for retrieval and display of binary values across all supported database types, including VARBINARY, BINARY, RAW, BLOB, CLOB, IMAGE, TEXT, BYTEA, and so on.
Support for exporting and importing binary values such as images, sound tracks, and other types of binary data, including VARBINARY, BINARY, RAW, BLOB, CLOB, IMAGE, TEXT, BYTEA, and so on.
Scheduled tasks (scheduled code execution, unit tests, schema comparison, load generation, etc...) now support running operations under different user accounts.
Support for Visual Studio 2015.
Experimental support for SQL Server Management Studio 2016 from SQL Server 2016 CTP 2.0 preview release.
Miscellaneous
Tons of other minor enhancements and bug fixes.
Feature-rich relational database known for its high performance and excellent concurrency
