SQL4X Manager J supports all major database vendors and Open Source servers.
Tools for Database Managers
SQL Scripts
This section describes how to run SQL scripts. Scripts can include all commands supported by your database server. A script usually contains several commands separated by a semicolon.
SQL4X Manager J supports many options for query execution. You can display query results as text or copy the result directly to the clipboard (the clipboard contents can then directly be pasted into many applications like MS Excel or MS Word), save queries in the Favorites Panel (similar to your web browser's favorites) or save, load and execute queries from sql files.
Stored Procedures
The Object Manager is a graphical interface to view object definitions (Stored Procedures, etc.), create new object and modify or drop existing objects. The integrated Object Manager handles functions, stored procedures and other database objects for MS SQL Server, Sybase and Oracle database server. The Object Manager can be started with Database Navigators Corner Menu (select your database connection, catalog and schema -> open the Corner Menu in the Objects list -> select "Object Manager...").
Import Data
SQL4X Manager J includes the Direct Import Assistant to import data into any existing tables. The Direct Import Assistant loads data from text files, converts the data (including character set conversion, if necessary) and runs SQL commands to insert the loaded data into your database server.
Data Transfer Manager
The Data Transfer Manager is a graphical interface to copy tables (definition and content) from a JDBC compliant database server to any other JDBC compliant database server. Data Transfer Manager makes it easy to copy data from test systems to production systems (or vice versa) and migrate tables from your old database server to your new database server.
Included tools for database developers
Database Design
Entity Relationship Modeller
The Entity Relationship Modeller can be used to graphically design your database layout or to reverse engineer existing databases.
Click on the Image above to get more information on important parts of the Entity Relationship Modeller interface.
Database reverse engineering
The integrated Entity Relationship Modeller helps you to design complex database layouts and get an easy overview over existing database projects. It let's you either design a model from scratch or easily import (reverse engineer) an existing database.
Reverse engineer a database
Entity Relationship Modeller
Select E/R Modeller from the Tools menu to open the Entity Relationship Modeller. After launching the ER Modeller you will see a white page to design your model.
To reverse engineer an existing database click the "Import ER Model" icon in the toolbar.
You can now select any existing database connection. The ER Modeller contacts your database and checks whether it supports Catalogs and/or Schemas and presents the available Catalogs and/or Schemas for selection. Now select the Catalog and/or Schema you want to reverse engineer and click select to start the import.
Reverse engineering supports all database types supported by SQL4X Manager J. However some database types (like MySQL without InnoDB tables) do not support or ignore foreign keys (referential integrity). In case your database server supports foreign keys they are loaded with each table (entity) and displayed as relation (each foreign key will be displayed as a line connecting to the destination table for the referential integrity constraint).
If your database server does not support foreign keys, they simply will no be shown. If you want the relations between your table to show up as lines connecting the entities on screen and your database server does not provide the necessary foreign key information, you have to add the foreign key constraints with the Inspector to each table manually.
Create SQL from an Entity Relationship Model
Click "Generate SQL" in the toolbar to save a SQL script that will create the ER Model. The generated SQL script is ANSI SQL92 compliant.
Save an Entity Relationship Model as Image
Click "Export as Image " in the toolbar to save the displayed ER Model as TIFF image.
Print an Entity Relationship Model
Printing an ER Model is not yet supported. You have to save the ER Model as TIFF image as use Mac OS X's Preview (or any other application) to print the ER Model.
Reporting
Reporting Tool
The Reporting Tool creates and prints simple reports from your SQL queries.
Click on the Image above to get more information on important parts of the Reporting Tool interface.
PHP/JSP Code Generator
SQL4X Manager J Enterprise Edition includes a PHP/JSP code generator to automatically create PHP web pages and Java Server Pages (JSP) based on your database tables. The code generator can create list views (with edit/delete/add option and page navigation), input/edit forms and delete pages. The created PHP and JSP code is compatible with Dreamweaver MX and can be executed with any PHP installation starting with PHP 4.x or any JSP 1.2 container (like Tomcat, WebSphere, etc.).
The generated PHP code works with MySQL only. The generated JSP works with any database server that is accessible with SQL4X Manager J.
Order
Please note that SQL4X Manager J Professional does not contain the following tools:
-
Database Reverse Engineering
- Import Text Data (Fixed Width)
- Copy/Move Tables and Data
- Restore Tables and Data (Applescriptable) (*)
- Customizable "Special" Menus
- JSP (Java Server Pages) Code Generator
- PHP Code Generator
- Manage Functions, Procedures, Triggers, Packages
- Support for PL/SQL Execution (SQL Console)
- PL/SQL Stored Procedure EditorGraphically Execute Stored Procedures (Single & Multiple Resultset Display, etc.)
- Stored Procedure Editor
- Graphically Execute Stored Procedures (Single & Multiple Resultset Display, etc.)Graphically Execute Stored Procedures (Single & Multiple Resultset Display, etc.)
Platform :Mac OS X
| Additional Information: SQL4X Manager J | ||
| Professional Edition | $129.00 | |
| Enterprise Edition | $249.00 | |
Please see also:
Create and run your SQL Script
Manage Srored Procedures, Functions, Triggers
More Software More Database Software