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.
http://jsqltool.joydownload.com/ - JSqlTool is a product developed by JSqlTool. This site is not directly affiliated with JSqlTool. All trademarks, registered trademarks, product names and company names or logos mentioned herein are the property of their respective owners. Our download manager distributes the original unmodified software, obtained directly from JSqlTool website, and does not modify it in any way.