SQL4X
Manager J Enterprise |
 |
SQL4X
Manager J Professional |
|
 |
SQL4X
Manager J Basic (Home Edition) |
|
|
|
WebBuilder
for MySQL |
|
|
|
|
| |
|
|
|
|
|
| Supported Database Servers |
|
|
|
|
|
| MySQL |
|
X |
X |
X |
X |
| Oracle 7/8/9i/10g |
|
|
X |
X |
X |
| Sybase ASE |
|
|
X |
X |
X |
| PostgreSQL |
|
|
X |
X |
X |
| Microsoft SQL Server 6.5/7/2000 |
|
|
X |
X |
X |
| OpenBase |
|
|
X |
X |
X |
| PrimeBase |
|
|
X |
X |
X |
| FrontBase |
|
|
X |
X |
X |
| IBM DB2 |
|
|
X |
X |
X |
| Any JDBC Compliant Server |
|
|
X |
X |
X |
| |
|
|
|
|
|
| Max. Database Connections |
|
|
|
|
|
| Up to 2 database connections |
|
|
X |
|
|
| Unlimited database connections |
|
X |
|
X |
X |
| |
|
|
|
|
|
| Supported OS /
Platform |
|
|
|
|
|
| MacOS X 10.2 or newer |
|
X |
X |
X |
X |
| Microsoft Windows 2000/XP or newer |
|
X |
|
|
|
| |
|
|
|
|
|
| Graphical
User Interface (All Databases) |
| Tabular Data Viewer / Editor |
|
X |
X |
X |
X |
| BLOB Viewer (Images, RTF, Text) |
|
|
X |
X |
X |
| Simple Query Builder |
|
|
X |
X |
X |
| Run SQL Commands (Tabular Resultview) |
|
X |
X |
X |
X |
| Run SQL Commands (Text Resultview) |
|
|
X |
X |
X |
| Run SQL Scripts |
|
|
X |
X |
X |
| SQL Syntax Coloring |
|
X |
X |
X |
X |
| SQL Table/Field Auto-Completion |
|
|
X |
X |
X |
| Mac OS X Finder-like DB Navigation |
|
|
X |
X |
X |
| Entity Relationship Modeller |
|
X |
|
|
X |
| Database Reverse Engineering |
|
X |
|
|
X |
| Display Connection Information |
|
X |
X |
X |
X |
| |
|
|
|
|
|
| Graphical
Assistants & Managers (All Databases) |
| Create & Alter Table Definitions |
|
X |
X |
X |
X |
| Rename & Drop Tables |
|
X |
X |
X |
X |
| Change Passwords |
|
X |
X |
X |
X |
| SQL Query Assistant |
|
|
X |
X |
X |
| Export Data / Query results |
|
X |
X |
X |
X |
| Import Text Data (CSV, Tab-Delimited, etc.) |
|
X |
|
X |
X |
| Import Text Data (Fixed Width) (*) |
|
|
|
|
X |
| Copy/Move Tables and Data |
|
X |
|
|
X |
| Backup Tables and Data (Applescriptable)
(*) |
|
X |
|
|
X |
| Restore Tables and Data (Applescriptable)
(*) |
|
|
|
|
X |
| Customizable "Special" Menus |
|
|
|
|
X |
| PHP Code Generator (PHP/MySQL) |
|
X |
|
|
X |
| JSP (Java Server Pages) Code Generator |
|
|
|
|
X |
| |
|
|
|
|
|
| Special Features (MySQL) |
|
|
|
|
|
| Create & Drop Databases |
|
X |
X |
X |
X |
| Create & Drop Index Definitions |
|
X |
X |
X |
X |
| Create, Alter & Drop Users |
|
X |
X |
X |
X |
| Manage Access Privileges |
|
X |
X |
X |
X |
| Display Server Status (Network Traffic,
Server Variables, Active Clients, etc.) |
|
X |
X |
X |
X |
| Check and Repair Tables |
|
X |
X |
X |
X |
| Analyze and Optimize Tables |
|
X |
X |
X |
X |
| PHP Code Generator |
|
X |
|
|
X |
| |
|
|
|
|
|
| Special GUI's (Oracle
7/8/9i/10g) |
|
|
|
|
|
| Create & Drop Index Definitions |
|
|
X |
X |
X |
| Create, Alter & Drop Views |
|
|
X |
X |
X |
| SQL*Plus Compatible Script Execution (SQL
Console) |
|
|
|
X |
X |
| Display Server Status (Memory Usage, Open
Cursors, Log File Usage, Active Clients, etc.) |
|
|
|
X |
X |
| Display Schema Information (Errors from
Stored Procedures, Policies, etc.) |
|
|
|
X |
X |
| Manage Functions, Procedures, Triggers,
Packages |
|
|
|
|
X |
| Support for PL/SQL Execution (SQL Console) |
|
|
|
|
X |
| PL/SQL Stored Procedure Editor |
|
|
|
|
X |
| Graphically Execute Stored Procedures (Single & Multiple
Resultset Display, etc.) |
|
|
|
|
X |
| |
|
|
|
|
|
| Special GUI's (MS SQL
Server) |
| Create & Drop Databases |
|
|
X |
X |
X |
| Create & Drop Index Definitions |
|
|
X |
X |
X |
| Create, Alter & Drop Views |
|
|
X |
X |
X |
| Display Server Status (Server Configuration,
Active Clients, Database Status, etc.) |
|
|
|
X |
X |
| Display Table Status (Space Used, Table
Statistics, etc.) |
|
|
|
X |
X |
| Stored Procedure Editor |
|
|
|
|
X |
| Graphically Execute Stored Procedures (Single & Multiple
Resultset Display, etc.) |
|
|
|
|
X |
| |
|
|
|
|
|
| Special GUI's (Sybase) |
|
|
|
|
|
| Create & Drop Databases |
|
|
X |
X |
X |
| Create & Drop Index Definitions |
|
|
X |
X |
X |
| Create, Alter & Drop Views |
|
|
X |
X |
X |
| Display Server Status (Server Configuration,
Active Clients, Database Status, etc.) |
|
|
|
X |
X |
| Display Table Status (Space Used, Table
Statistics, etc.) |
|
|
|
X |
X |
| Stored Procedure Editor |
|
|
|
|
X |
| Graphically Execute Stored Procedures (Single & Multiple
Resultset Display, etc.) |
|
|
|
|
X |
| |
|
|
|
|
|
| Special GUI's (PostgreSQL) |
|
|
|
|
|
| Create & Drop Databases |
|
|
X |
X |
X |
| Create & Drop Index Definitions |
|
|
X |
X |
X |
| Create, Alter & Drop Views |
|
|
X |
X |
X |
| |
|
|
|
|
|
| Special GUI's
(OpenBase) |
| Create & Drop Index Definitions |
|
|
X |
X |
X |
| |
|
|
|
|
|
| |
|
|
|
|
|
