SoftTree SQL Assistant 9.2.349 Enterprise Edition | Windows x86/x64 | English | Size: 92.73 MB

SQL Assistant equips database developers and DBAs with the productivity tools they need to speed up the database development process, improve code quality and accuracy. SQL Assistant can boost your database development productivity by 300%.

SQL Assistant supports all major databases. It is shipped pre-configured with support for Oracle, Microsoft SQL Server, IBM DB2, MySQL, PostgreSQL, Amazon Redshift, IBM Netezza, Teradata, Pivotal Greenplum, SQLite, SAP (Sybase) ASE and SQL Anywhere. Other major features include full-featured source control interface supporting Git, Subversion, Perforce, and Microsoft Team Foundation Server code repositories. Graphical Database Modeling and Dependencies, Code and Data Generation, Database Unit Testing, and many other. Many users have stated they do not know how they can code and manage their databases without SQL Assistant.

Target SQL and non-SQL editors - SQL Assistant integrates with many widely used database editors and database management and development environments including native tools that come with your database systems. It can also be used to database enable many universal code editors and used as a database development plugin.

SQL Assistant provides assistance with code typing, automatic word completion and database object and attributes completion and 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, real-time code syntax checker, spell checker and a number of other vital coding tools.

SQL Assistant is fast and can be used with both very small and very large database systems. It is also very flexible and can be easily customized by users to match their coding habits.

Key Features and Benefits
- Triples SQL developer productivity
- Improves code quality and accuracy
- Provides unmatched intelligent SQL code intellisense features
- 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, and more...
- Provides integrated database source code control interface
- Provides integrated real-time code syntax and spell checker
- Provides integrated real-time code performance analyzer
- Provides multi-server code execution, scheduling, multi-server code and data search and replace
- Provides user extendable comparison engine for schema, database, and jobs comparison
- Supports 14 major database systems and their SQL dialects
- Provides integrated real-time code performance analyzer
- Provides integrated code and data generators, unit testing and load testing framework
- Provides graphical database modeling
- Integrates with many SQL and non-SQL editors
- Provides full featured integrated multi-database development environment
- Fast and has small disk and memory footprint
- Can be easily installed without interrupting any existing processes and used immediately

Pre-configured targets:
- SQL Editor advanced database development environment for all supported database systems (installed with SQL Assistant)
- SQL Server Management Studio 2005, 2008, 2012, 2014, 2016
- SQL Query Analyzer
- SQL Server Enterprise Manager
- Visual Studio for Database Professionals (DataDude)
- Visual Studio .NET, 2005, 2008, 2010, 2013, 2015, 2017
- Visual Studio C# Express, VB Express, C++ Express, Web Developer Express
- Oracle SQL Developer
- Oracle JDeveloper
- Eclipse
- IBM Data Studio
- Delphi
- DB Tools for Oracle
- PL/SQL Developer
- Oracle SQL*Plus
- Toad for Oracle
- Toad for MySQL
- Toad for DB2
- Toad for SQL Server
- PowerBuilder
- PostgreSQL pgAdmin III
- Navicat
- MySQL Workbench
- Microsoft Access
- UltraEdit
- Notepad++
- Notepad
- Imagine your SQL editor here

Supported database systems:
- Oracle 8i, 9i, 10g, 11g, 12c
- Microsoft SQL Server 2000, 2005, 2008, 2012, 2014, 2016
- Microsoft SQL Azure 11.x, 12.x
- DB2 UDB 7.x, 8.x, 9.x, 10.x, 11.x
- DB2 UDB for iSeries 5.x, 6.x, 7.x
- MySQL 5.x
- SAP Adaptive Server Enterprise (Sybase ASE) 12.x, 15.x, 16.x
- SAP SQL Anywhere (Sybase ASA) 9.x - 16.x
- PostgreSQL 8.x, 9.x
- Amazon Redshift
- Teradata 14.x, 15.x
- IBM Netezza 7.x
- Pivotal Greenplum 4.x
- SQLite 3.x
- Microsoft Access 2003, 2007, 2010, 2013

New Features and Major Changes
1. Visual Studio addon updated to support Visual Studio 2017
2. Native plug-in for Notepad++ offers better integration.
3. Support for Navicat database tools.
4. New advanced object schema References analyzer supporting Oracle, DB2 UDB, PostgreSQL, SQL Server, and SQL Azure database servers.
5. SQL Assistant SQL Editor now changes colors of running tabs, displays number of running tasks in the status bar, and supports persistent docking of the Task Manager with better control of the running queries.
6. New database Session Monitor for monitoring database and user activities showing running queries and progress of long running operations with ETA.
7. New Task Manager for monitoring and managing all kinds of background operations including query execution, data export and import tasks, data and schema object scripting, data transfers and so on.
8. Improvements in the UI, SQL Assistant windows can be now docked to different sides of the editor and main windows, or be floated and moved to a second monitor.
9. Across the board SQL Intellisense enhancements for SELECT statements enabling more efficient coding.
10. Intellisense enhancements for DB2 for iSeries, indexed columns and constraints are now shown in Intellisense prompts.
11. Code formatting enfacements for DECLARE and ALTER statements, for LIMIT and OFFSET clauses.
12. Support for enumeration data type in PostgresSQL.
13. Better handling of overloaded functions in DB2 and PostgreSQL databases.
14. SQL Assistant queries for Oracle databases tuned for better performance.
15. Database schema modeling - better handling of newly added referential integrity constraints.
16. Schema Comparison enhancements for PosgreSQL databases.
17. Automatic detection and re-connect for dropped connection in MySQL and PostgreSQL databases.
18. The data-transfer utility now recognizes computed and other types of auto-generated columns.
19. The data-grid in edit more now supports inserting rows pasted from the Clipboard (that's right, you can now insert data into tables by copying data from Excel and other applications).
20. The data-grids now support multiple column sorting using Ctrl+Click method.
21. Optimized data retrieval operation for more efficient memory usage. On 64-bit systems your computer memory is the only limit now for how much data can be retrieved from the database. 2GB is a limit for 32-bit systems.
22. New SQL References for SQL Server 2017 and for SQL Server 2016 R2.
23. New SQL Reference for SAP ASE 16.0.
24. New SQL Reference for MySQL 5.7.
25. New SQL References for DB2 UDB 10.5 and for 11.1.

Miscellaneous
26. Many other minor enhancements and bug fixes.

Homepage
Kod:
https://www.softtreetech.com
Download link:



Links are Interchangeable - No Password - Single Extraction