SoftTree SQL Assistant description
|
The ultimate tool for SQL developer productivity!
SQL Assistant easily integrates with many widely used database editors and database management and development environments including native tools that come with your database systems. It provides assistance with code typing, automatic word completion and database object and attributes browsing.
It provides functions for quick entry of common SQL constructs and code snippets. It also provides integrated and fully interactive SQL code assistance system for instant help with SQL command syntax and options available in specific database versions, code syntax checker, spell checker and a number of other vital coding tools.
A database application that can be used with both very small and very large database systems.
Here are some key features of "SoftTree SQL Assistant":
· Doubles SQL developer productivity.
· Improves code quality and accuracy.
· Provides advanced SQL code intellisense features, including support for databases, objects, parameters, script variables, syntax elements.
· Provides interactive SQL reference and SQL code assistance systems.
· Provides advanced SQL code formatters and beautifiers; SQL syntax validation, code structure views for fast code navigation.
· Provides integrated real-time code syntax and spell checker
· Supports 8 major database systems: Oracle, SQL Server, DB2, MySQL, PostgreSQL, Sybase ASE, Sybase ASA, MS Access, and their SQL dialects.
· Integrates with many SQL and non-SQL editors .
· Fast and has small disk and memory footprint .
· Can be easily installed without interrupting any existing processes and used immediately.
Requirements:
· Oracle 8i, 9i, 10g, 11g
· Microsoft SQL Server 2000, 2005, 2008
· DB2 UDB 7, 8, 9, 9.5
· DB2 UDB for iSeries
· MySQL 5.x
· Sybase ASE 12.x, 15.x
· Sybase ASA 7, 8, 9, 10
· PostgreSQL 8.x
· Microsoft Access 2003, 2007
· 12.5 MB disk space
· 128 MB RAM
· CPU Pentium or compatible
Limitations:
· 14 days trial What's New in This Release: [ read full changelog ]
New Features and Major Changes:
· New Schedule feature for scheduling runs of SQL code on single and multiple database systems using sequential and concurrent parallel runs.
· Completely rebuilt and greatly enhanced Database Code Refactoring engine now supporting the following smart-refactoring methods: Rename Table or View; Rename Table or View Column; Rename Procedure or Function; Rename Procedure or Function Parameter; Rename Local Variable; Add Table Column; Drop Table Column; Add Procedure or Function Parameter; Drop Procedure or Function Parameter; Drop Procedure or Function; Drop Table or View; Extract View; Extract Procedure; Qualify Object Names.
· Database refactoring coverage expanded from 3 to 8 different database system types.
· Lots of enhancements in database refactoring methods, including updating Oracle synonyms when renaming based objects; column renaming in 'return table' in table functions in SQL Server, and many others.
· Code formatter and beautifier now support...
|
|
Find us on Google+
Part of the 
