JSqlTool 1.1

JSqlTool - View and edit database tables content with this app.

View and edit database tables content with this app.

JSqlTool is a small, easy to use, Swing based software used to view / edit database tables content and to execute SQL scripts, by connecting to a database using JDBC/ODBC.

It'a a multilanguage application, tested on Oracle, SQLServer, MySQL, DB2 and many other databases.

This application will help you:

- connect to a database, using a JDBC or ODBC Driver
- view tables, views and synonyms list
- for each table/view/synonym see entity details, like: structure, data, indexes, constraints, SQL script and triggers
- table data can be visually ordered/filtered; you can add/edit/delete records directly on the table data grid
- table data can be exported as insert SQL statements, as text or in an Excel File Format (XLS)
- edit SQL statements in a SQL shell (by coloring SQL text according to syntax), by means of it you can execute queries or other statements and see query results; queries may contain parameters
- previous SQL statements are recorded to allow re-call and re-execution
- view a database schema E/R diagram, store and recall schemas, print and export them
- replicate a set of tables to another schema, by creating tables and populating them. Replication task can be replicated to update data
- many other features are available, according to the database type: edit/drop contraints, execution query explain plan, trace sessions.

Requirements:

- Java

JSqlTool 1.1 is licensed as Freeware for the Windows operating system / platform. JSqlTool is provided as a free download for all software users (Freeware).