SoftTree SQL Assistant - Standard and Professional Edition Comparison
Feature | Standard | Professional |
---|---|---|
Supported database types | 16 (all) | 16 (all) |
Bundled multi-server Professional database integrated development environment IDE (32-bit and 64-bit included) | + | |
Bundled multi-server SQL editor (Light version, 32-bit only) | + | + |
Other supported code editors/IDEs (SSMS, Visual Studio, Toad, MySQL Workbench, PL/SQL Developer, HeidiSQL, etc...) | 24 (excludes Professional IDE) |
25 (all) |
SQL Intellisense | + | + |
Code formatters and beautifiers (interactive) | + | + |
Code formatters and beautifiers (command line batch mode) | + | |
Advanced code processing, regions, folding, preprocessor, macro-capabilities, automation (available in the Professional IDE) | + | |
Graphical database documenter with cross-platform web format output | + | |
Database schema modeling | + | |
Source code control interface (Subversion, TFS, Git, Perforce) | + | |
Database Explorer (all supported DBMS types) | + | + |
Graphical database and schema object management | + | + |
Graphical interfaces for database backups, schedulers, performance monitoring | + | + |
Programmable code snippets | + | + |
Code outlining | + | |
Code regions and folding | + | |
Interactive SQL reference system | + | + |
SQL preprocessor | + | + |
SQL syntax checker | + | + |
Spell checker | + | + |
One-click db data preview | + | + |
One-click db code preview and edit | + | + |
Data scripting and exporting in multiple formats | + | + |
SQL-to-application code conversion | + | + |
Fast SQL code navigation (code structure view, code bird's view) | + | + |
SQL code comparison | + | + |
Visual code bookmarks | + | + |
Graphical code logic visualizer | + | + |
SQL code execution (asynchronous, thread-safe) | + | + |
SQL code scheduling (compatible with all database servers) | + | |
Multi-server SQL code execution | + | |
Multi-server SQL code search and replace | + | |
Multi-server data search and replace | + | |
Code reusability suggestions with advanced full text search | + | + |
Advanced database and schema comparison | + | |
Advanced jobs/tasks comparison | + | |
Schema comparison (command line mode) | + | |
Multi-server data comparison | + | |
Multi-server data comparison (command line mode) | + | |
Data export / import from Excel, XML, flat files | + | + |
Data transfer across database servers | + | + |
Database Factory, and other ETL utilities | + | |
Data sanitizer for converting production databases to development databases | + | |
Tab manager and code history add-on | + | + |
Smart database and code refactoring | + | |
Advanced code dependencies analysis (with context and graphical diagrams) | + | |
Test data generator (interactive mode) | + | |
Test data generator (command line mode) | + | |
Bulk SQL code generator | + | |
Database unit testing framework (interactive mode) | + | |
Database unit testing framework (command line mode) | + | |
Database benchmarking for performance and scalability testing | + | |
Data analytics and reporting (with cube and pivot capabilities) | + | + |
Clone It - database and schema cloning utilities | + | |
Database performance dashboards | + | + |
Top SQL queries analysis, and other monitoring and tuning utilities | + | + |
Graphical SQL Profiler for SQL Server and Azure SQL | + | + |
Graphical SQL Profiler for Oracle | + | + |
Graphical SQL Profiler for PostgreSQL | + | + |
Data Factory | + | |
ETL Orchestrator | + | |
Application Data Lineage Analyzer | + |