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 | + | |
| Database Migration Toolkit | + |
