SQL4X Manager J Enterprise |
 |
SQL4X Manager J Professional |
 |
 |
SQL4X Manager J Basic (Home Edition)
|
 |
 |
 |
MySQL4X Manager Pro |
 |
 |
 |
 |
MySQL4X
Manager Basic |
 |
 |
 |
 |
 |
| |
 |
 |
 |
 |
 |
| Supported
Database Servers |
|
|
|
|
|
| MySQL |
X |
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 |
|
X |
|
|
| Unlimited database connections |
|
X |
|
X |
X |
| |
|
|
|
|
|
| Graphical
User Interface (All Databases) |
| Designed for Mac OS X/Aqua |
X |
X |
X |
X |
X |
| Tabular Data Viewer / Editor |
X |
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 |
| Run SQL Commands (Text Resultview) |
X |
X |
X |
X |
X |
| Run SQL Scripts |
X |
X |
X |
X |
X |
| SQL Syntax Coloring |
|
|
X |
X |
X |
| SQL Table/Field Auto-Completion |
|
|
X |
X |
X |
| Mac OS X Finder-like DB Navigation |
X |
X |
X |
X |
X |
| Entity Relationship Modeller |
|
|
|
|
X |
| Database Reverse Engineering |
|
|
|
|
X |
| Display Connection Information |
|
|
X |
X |
X |
| |
|
|
|
|
|
| Graphical
Assistants & Managers (All Databases) |
| Create & Alter Table Definitions |
X |
X |
X |
X |
X |
| Rename & Drop Tables |
X |
X |
X |
X |
X |
| Change Passwords |
X |
X |
X |
X |
X |
| SQL Query Assistant |
|
|
X |
X |
X |
| Export Data / Query results |
X |
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 |
| Backup Tables and Data (Applescriptable)
(*) |
|
X |
|
|
X |
| Restore Tables and Data (Applescriptable)
(*) |
|
|
|
|
X |
| Customizable "Special"
Menus |
|
|
|
|
X |
| JSP (Java Server Pages) Code
Generator |
|
|
|
|
X |
| |
|
|
|
|
|
| Special Features
(MySQL) |
|
|
|
|
|
| Create & Drop Databases |
X |
X |
X |
X |
X |
| Create & Drop Index Definitions |
X |
X |
X |
X |
X |
| Create, Alter & Drop Users |
X |
X |
X |
X |
X |
| Manage Access Privileges |
X |
X |
X |
X |
X |
| Display Server Status (Network
Traffic, Server Variables, Active Clients,
etc.) |
X |
X |
X |
X |
X |
| Check and Repair Tables |
X |
X |
X |
X |
X |
| Analyze and Optimize Tables |
X |
X |
X |
X |
X |
| PHP Code Generator |
|
|
|
|
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 |
| |
|
|
|
|
|
| |
|
|
|
|
|