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.
v6.3 [Nov 16, 2012]
- SQL Intellisense enhancements – multiple text matching methods including suffix name matching, spelling correlation, and matching characters highlighting.
- New Task and Reminders interface – centralized view of persistent bookmarks and "to-do" reminders saved across multiple files, database servers and objects.
- New plug-in for Oracle JDeveloper – complete drop-in development toolbox, including full set of SQL Assistant utilities and a full featured SQL Editor.
- New plug-in for Oracle SQL Developer – complete drop-in development toolbox, including full set of SQL Assistant utilities and a full featured SQL Editor.
- New multi-server, multi-database data search and replace with advanced options, regular expressions, preview-before-change, and more.
- Enhancement in code formatting and layout controls - additional macro variables added to improve control of dynamically generated code headers.
- Visual bookmarks enfacements – removed limitations on the number of persistently saved bookmarks in a single file.
- Added new options for greater controls of application filters to aid users in resolving cross-application conflicts.
- Better integration with external code comparison tools. External tools can be now used nearly in all places where an internal code compare is used.
- Enhancement in SQL Intellisense for SQL Server – improved handling of user-defined data types (column descriptors now display the original data type along with its expanded description).
- Enhancement for XML data import – new Truncate table option added for data loading.
- Enhancement for XML Export and Data Generator produced deployment scripts – new option to generate CREATE TABLE commands as part of the script with multiple options, including IF NOT EXISTS.
- Enhancement for XML Export/Import and Excel Import – added graphical scheduling for unattended operations.
- Lots of other minor changes and enhancements.
Feature-rich relational database known for its high performance and excellent concurrency
