./databases/sql-workbench, JDBC-based cross-platform SQL query tool.

[ CVSweb ] [ Homepage ] [ RSS ] [ Required by ] [ Add to tracker ]

Branch: pkgsrc-2016Q3, Version: 120, Package name: sql-workbench-120, Maintainer: asau

SQL Workbench/J is a free, DBMS-independent, cross-platform SQL
query tool. It is written in Java and should run on any
operating system that provides a Java Runtime Environment.

Its main focus is on running SQL scripts (either interactively
or as a batch) and export/import features. Graphical query
building or more advanced DBA tasks are not the focus and are
not planned.

Features:

* Edit, insert and delete data directly in the query result.
* 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 compressed "on-the-fly".
* Powerful text, XML and spreadsheet 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.
* Supports running SQL scripts in batch mode.
* Supports running in console mode.
* Search text in procedure, view and other sources using a SQL
command or a GUI.
* Search for data across all columns in all tables using a SQL
command or a GUI.
* Reformatting (Pretty-Print) of SQL Statements.
* Select rows from related tables according to their foreign
key definitions.
* Tooltips for INSERT statements to show the corresponding
value or column.
* Copy data directly between to database servers using a SQL
command or a GUI.
* 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.
* Display database objects and their definitions.
* Display table source.
* Display view, procedure and trigger source code.
* Display foreign key constraints between tables.
* Full support for BLOB data in query results, SQL statements,
export and import.
* SQLWorkbench/J is free for almost everyone (published under
a modified the Apache 2.0 license).

Master sites:

SHA1: f54a651716a5f53006f3204612aec40068966b38
RMD160: ac910996d8b7862c01a4b6b068e04defa5d6f3d8
Filesize: 6058.188 KB

Version history: (Expand)