summaryrefslogtreecommitdiff
path: root/databases/sql-workbench/DESCR
diff options
context:
space:
mode:
authorasau <asau>2015-07-20 20:19:16 +0000
committerasau <asau>2015-07-20 20:19:16 +0000
commit82fd1755fc423b8c5838f487961507570ede81da (patch)
treea521c353b032b43484ad9412c653656cb04264b6 /databases/sql-workbench/DESCR
parent772dd7cc65d982dfa3f78ba3f94c1e64943a5214 (diff)
downloadpkgsrc-82fd1755fc423b8c5838f487961507570ede81da.tar.gz
Import SQL Workbench/J build 117 as databases/sql-workbench.
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).
Diffstat (limited to 'databases/sql-workbench/DESCR')
-rw-r--r--databases/sql-workbench/DESCR50
1 files changed, 50 insertions, 0 deletions
diff --git a/databases/sql-workbench/DESCR b/databases/sql-workbench/DESCR
new file mode 100644
index 00000000000..e94740b092a
--- /dev/null
+++ b/databases/sql-workbench/DESCR
@@ -0,0 +1,50 @@
+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).