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.0 [Jul 24, 2014]
- New "Code Context" solution for discovering and improving database code reusability.
- New Professional SQL Editor - a full-featured database development environment for 10 database types.
- New database workload generator for application scalability testing.
- New database server type supported – Amazon Redshift.
- New context SQL search with real-time suggestions and centralized fully indexed code repository supporting full text search indexes for database code across multiple database servers.
- Enhanced Document Manager - visualizes file context when closing development environment and saving multiple files; no more guess work when prompted to save a bunch of generically named scripts without being able to see their content.
- Document Managers implemented for Toad, Eclipse, DB Tools, Notepad , pgAdmin.
- Enhanced Document Manager now enables fast recent documents filtering by context.
- Improved DB Explorer– completely rewritten, the new robust explorer interface supports all target editors and databases; even Windows Notepad can be now turned into full featured database editor. DB Explorer features a number of unique functions, including in-line display of object stats, last modification time, object and column comments, linking to external files, and more.
- Unit Testing Framework now enables logging and saving unit test results to a database table for advanced data analysis using specialized analytical and reporting software.
- All databases: SQL Intellisense enhancements for UPDATE and CALL statements - use of {fields} for faster code entry.
- All databases: SQL Intellisense enhancements enable selecting of "Name Matching Method" in runtime, name matching and sorting can be changed with two clicks directly in SQL Intellisense popups.
- MSSQL and Sybase ASE: SQL Intellisense enhancements for temporary tables - column suggestions now provided for temporary tables having their definition predictable in design time.
- New command line interface and scheduling for the Data Compare utility, now data comparisons can be scheduled, as well as integrated with Unit Tests.
- Enhanced $OBJECT$ macro enables multiple columns selection.
- Compatibility changes for Toad for SQL Server 6.1 and later – now supporting database connection sharing, and other improvements.
- New add-on for Visual Studio 2013
- New add-ons for Delphi XE 1-5.
- Compatibility changes for supporting latest UltraEdit v20.
- MSSQL: support for database-level triggers.
- MSSQL: support for custom table-type data types.
- Interactive SQL Reference for Amazon Redshift.
- Interactive SQL Reference for MS SQL 2012
- Interactive SQL References for DB2 10.1, DB2 10.5
- All databases: The Source Code Control interface now supports custom data types.
Feature-rich relational database known for its high performance and excellent concurrency
