SQL查詢分析工具 SQL Workbench/J

openkk 12年前發布 | 37K 次閱讀 SQL 數據庫管理工具

SQL Workbench/J是一個獨立于DBMS，跨平臺的SQL查詢分析工具。支持：直接在查詢結果集中編輯，新增和刪除數據；在查詢結果集、SQL statement、導入和導出中支持BLOB數據。在SQL語句中采用變量替換；能夠生成數據結構的XML報告，以便能夠重構數據庫模型；能夠比較兩個數據庫在結構上有何不同之處；在編輯SQL語句時能夠自動提示表格和字段；所有SQL腳本運行在批處理模式下；SQL Workbench/J還提供一個DataPumper工具用于直接在兩臺服務器上相互復制數據，DataPumper功能還能夠當作SQL命令使用以實現批處理。

Display result data from SQL queries (Screenshot)
Edit, insert and delete data directly in the result table (Screenshot)
Powerful export command to write text files (aka "CSV"), XML, HTML or SQL (including BLOB data).
All user tables can be exported into a directory with a single command. Export files can be compress "on-the-fly".
Powerful text and XML file import. A set of files (including compressed files) can be imported from a directory with a single command. Foreign key constraints are detected to insert the data in the correct order
Compare two database schemas for differences. The XML output can be transformed into the approriate SQL ALTER statements using XSLT
Compare the data of two database and generate the necessary SQL statements to migrate one to the other.
Reformatting (Pretty-Print) of SQL Statements (Screenshot)
Full support for BLOB data in query results, SQL statements, export and import. Read more...
Select rows from related tables according to their foreign key definitions (Screenshot1 Screenshot2).
Search text in procedure, view and other sources using a SQL command or a GUI (Screenshot)
Search for data across all columns in all tables using a SQL command or a GUI (Screenshot)
Copy data directly between to database servers using a SQL command or a GUI (Screenshot)
Macros (aka aliases) for frequently used SQL statements
Variable substitution in SQL statements including smart prompting for values (can be combined with macros)
Auto completion for tables and columns in SQL statements (Screenshot)
Tooltips for INSERT statements to show the corresponding value or column (Screenshot)
All SQL Scripts (including Workbench specific commands) can be run in batch mode
An interactive console mode (Screenshot)
Display table, view and procedure definitions (Screenshot)
Display view, procedure and trigger source code (Screenshot)
Display foreign key constraints between tables (Screenshot)
SQLWorkbench/J is free (License agreement)