Database management tools: Difference between revisions

Jump to navigation Jump to search

Database management tools (edit)

Revision as of 20:18, 3 April 2018

728 bytes added ,  3 April 2018
→‎Lists of database tools: + column: Specify Field and Row Terminators
(→‎Lists of database tools: + column: Specify Field and Row Terminators)
Line 6: Line 6:
* Import format: Import file into table is not availabe.
* Import format: Import file into table is not availabe.
* Export format: Export query result set as CSV, HTML, XML, JSON file <ref>[https://dbeaver.jkiss.org/docs/features/#Data_transfer_(export/import) Features | DBeaver]</ref>. More formats e.g. '''XLSX''' is available in the paid version <ref>[https://dbeaver.com/faq/ FAQ | DBeaver Enterprise Edition]</ref>.
* Export format: Export query result set as CSV, HTML, XML, JSON file <ref>[https://dbeaver.jkiss.org/docs/features/#Data_transfer_(export/import) Features | DBeaver]</ref>. More formats e.g. '''XLSX''' is available in the paid version <ref>[https://dbeaver.com/faq/ FAQ | DBeaver Enterprise Edition]</ref>.
* Specify Field and Row Terminators:
* Engine supported: "MySQL, PostgreSQL, SQLite, Oracle, DB2, SQL Server, MariaDB, Sybase, Teradata, Netezza, etc. Supports NoSQL databases: MongoDB, Cassandra, Redis, Apache Hive"
* Engine supported: "MySQL, PostgreSQL, SQLite, Oracle, DB2, SQL Server, MariaDB, Sybase, Teradata, Netezza, etc. Supports NoSQL databases: MongoDB, Cassandra, Redis, Apache Hive"
* Software licenses: Open source - Apache License Version 2.0<ref>[https://dbeaver.jkiss.org/about/ About | DBeaver]</ref>. Source code is available on [https://github.com/dbeaver/dbeaver github].{{Gd}}
* Software licenses: Open source - Apache License Version 2.0<ref>[https://dbeaver.jkiss.org/about/ About | DBeaver]</ref>. Source code is available on [https://github.com/dbeaver/dbeaver github].{{Gd}}
Line 14: Line 15:
* Import format: N/A. The feature is available in the paid version.
* Import format: N/A. The feature is available in the paid version.
* Export format: Export query result set as CSV/HTML. More formats e.g. SQL, XML, XLS/XLSX, JSON is available in the paid version.<ref>[https://www.dbvis.com/features/feature-list/ Data Visualization & DB Management Features - DbVisualizer]</ref>
* Export format: Export query result set as CSV/HTML. More formats e.g. SQL, XML, XLS/XLSX, JSON is available in the paid version.<ref>[https://www.dbvis.com/features/feature-list/ Data Visualization & DB Management Features - DbVisualizer]</ref>
* Specify Field and Row Terminators:
* SQL syntax checker: Available {{Gd}}
* SQL syntax checker: Available {{Gd}}
* Engine supported: "DB2 for LUW, H2, JavaDB/Derby, Mimer SQL, MySQL, NuoDB, PostgreSQL, Oracle, Redshift, SQLite, SQL Server, Sybase SQL Anywhere, Sybase ASE, Vertica"
* Engine supported: "DB2 for LUW, H2, JavaDB/Derby, Mimer SQL, MySQL, NuoDB, PostgreSQL, Oracle, Redshift, SQLite, SQL Server, Sybase SQL Anywhere, Sybase ASE, Vertica"
Line 23: Line 25:
* Import format: Import Access, Excel, CSV, XML file & ODVC source into table<ref>[http://sqlyogkb.webyog.com/article/271-import-external-data Import External Data - SQLyog Knowledge Base]</ref>
* Import format: Import Access, Excel, CSV, XML file & ODVC source into table<ref>[http://sqlyogkb.webyog.com/article/271-import-external-data Import External Data - SQLyog Knowledge Base]</ref>
* Export format: Export query result set as CSV, Json, HTML/XML, '''Excel XML''' file<ref>[http://sqlyogkb.webyog.com/article/215-export-data Export Data - SQLyog Knowledge Base]</ref><ref>[http://sqlyogkb.webyog.com/article/199-exporting-resultset Exporting Resultset - SQLyog Knowledge Base]</ref>
* Export format: Export query result set as CSV, Json, HTML/XML, '''Excel XML''' file<ref>[http://sqlyogkb.webyog.com/article/215-export-data Export Data - SQLyog Knowledge Base]</ref><ref>[http://sqlyogkb.webyog.com/article/199-exporting-resultset Exporting Resultset - SQLyog Knowledge Base]</ref>
* Specify Field and Row Terminators: available
* Engine supported: MySQL & MariaDB<ref>[http://sqlyogkb.webyog.com/article/166-what-is-sqlyog What is SQLyog - SQLyog Knowledge Base]</ref>
* Engine supported: MySQL & MariaDB<ref>[http://sqlyogkb.webyog.com/article/166-what-is-sqlyog What is SQLyog - SQLyog Knowledge Base]</ref>
* Software licenses: Proprietary
* Software licenses: Proprietary
Line 31: Line 34:
* Import format: Import CSV, Json file into table<ref>[https://dev.mysql.com/doc/workbench/en/wb-admin-export-import.html MySQL :: MySQL Workbench Manual :: 6.5 Data Export and Import]</ref>
* Import format: Import CSV, Json file into table<ref>[https://dev.mysql.com/doc/workbench/en/wb-admin-export-import.html MySQL :: MySQL Workbench Manual :: 6.5 Data Export and Import]</ref>
* Export format: Export query result set as TXT, CSV, Excel Spreadsheet (XML), HTML/XML, SQL INSERT statement
* Export format: Export query result set as TXT, CSV, Excel Spreadsheet (XML), HTML/XML, SQL INSERT statement
* Specify Field and Row Terminators: n/a
* SQL syntax checker: Available {{Gd}}
* SQL syntax checker: Available {{Gd}}
* Engine supported: MySQL
* Engine supported: MySQL
Line 40: Line 44:
* Import format: "CSV (comma delimited) /TSV (tab delimited) /PSV (pipe delimited) /SSV (semicolon delimited) /TXT/XML"
* Import format: "CSV (comma delimited) /TSV (tab delimited) /PSV (pipe delimited) /SSV (semicolon delimited) /TXT/XML"
* Export format: "CSV/TSV/PSV/SSV/SQL (INSERT statement) /XLSX/XLS/XML/JSON/HTM/MD"
* Export format: "CSV/TSV/PSV/SSV/SQL (INSERT statement) /XLSX/XLS/XML/JSON/HTM/MD"
* Specify Field and Row Terminators:
* Engine supported: "SQL Server, SQL Azure, LocalDB, MySQL, Oracle, IBM DB2, Informix, PostgreSQL, HP Vertica, NuoDB, Teradata, Sybase ASE, Firebird, SQLite, SQLCe, Access, '''Excel''', VistaDB, dBase, FoxPro, OleDB, ODBC, OData, Text, NoSQL"
* Engine supported: "SQL Server, SQL Azure, LocalDB, MySQL, Oracle, IBM DB2, Informix, PostgreSQL, HP Vertica, NuoDB, Teradata, Sybase ASE, Firebird, SQLite, SQLCe, Access, '''Excel''', VistaDB, dBase, FoxPro, OleDB, ODBC, OData, Text, NoSQL"
* Software licenses: Proprietary
* Software licenses: Proprietary
Line 48: Line 53:
* Import format:  
* Import format:  
* Export format: CSV, SQL statement ...
* Export format: CSV, SQL statement ...
* Specify Field and Row Terminators:
* Engine supported: MySQL ...
* Engine supported: MySQL ...
* Software licenses: GNU General Public License version 2.0 (GPLv2)
* Software licenses: GNU General Public License version 2.0 (GPLv2)
Line 56: Line 62:
* Import format: Import CSV file into table
* Import format: Import CSV file into table
* Export format: Export query result set in two ways (1) Export as file such as CSV, Json, HTML/XML (2) "Export as queries" update or insert queries<ref>[https://www.jetbrains.com/datagrip/features/importexport.html Import/Export Options From CSV To Database - Features | DataGrip]</ref> {{Gd}}
* Export format: Export query result set in two ways (1) Export as file such as CSV, Json, HTML/XML (2) "Export as queries" update or insert queries<ref>[https://www.jetbrains.com/datagrip/features/importexport.html Import/Export Options From CSV To Database - Features | DataGrip]</ref> {{Gd}}
* Specify Field and Row Terminators:
* Engine supported: MySQL, PostgreSQL, Microsoft SQL Server, Microsoft Azure, Oracle, Amazon Redshift, Sybase, DB2, SQLite, HyperSQL, Apache Derby and H2<ref>[https://www.jetbrains.com/datagrip/features/ Features - DataGrip]</ref>  
* Engine supported: MySQL, PostgreSQL, Microsoft SQL Server, Microsoft Azure, Oracle, Amazon Redshift, Sybase, DB2, SQLite, HyperSQL, Apache Derby and H2<ref>[https://www.jetbrains.com/datagrip/features/ Features - DataGrip]</ref>  
* Software licenses: Proprietary
* Software licenses: Proprietary
Line 64: Line 71:
* Import format: Import TXT, CSV, HTML/XML, EXCEL, JSON, Access & DBF file into table <ref>[https://www.navicat.com/cht/products/navicat-premium-feature-matrix Navicat Premium 功能列表 | Navicat]</ref>.  
* Import format: Import TXT, CSV, HTML/XML, EXCEL, JSON, Access & DBF file into table <ref>[https://www.navicat.com/cht/products/navicat-premium-feature-matrix Navicat Premium 功能列表 | Navicat]</ref>.  
* Export format: Export query result set as TXT, CSV, HTML/XML, '''EXCEL''', JSON, Access & DBF file
* Export format: Export query result set as TXT, CSV, HTML/XML, '''EXCEL''', JSON, Access & DBF file
* Specify Field and Row Terminators: available
* Engine supported: MySQL, MariaDB, SQL Server, Oracle, PostgreSQL, SQLite, Amazon RDS, Amazon Aurora, Amazon Redshift, SQL Azure, Oracle Cloud & Google Cloud<ref>[https://www.navicat.com/cht/products/navicat-premium Navicat Premium | 以單一的 GUI 同時連線到不同類型的資料庫]</ref>
* Engine supported: MySQL, MariaDB, SQL Server, Oracle, PostgreSQL, SQLite, Amazon RDS, Amazon Aurora, Amazon Redshift, SQL Azure, Oracle Cloud & Google Cloud<ref>[https://www.navicat.com/cht/products/navicat-premium Navicat Premium | 以單一的 GUI 同時連線到不同類型的資料庫]</ref>
* Software licenses: Proprietary
* Software licenses: Proprietary
Line 72: Line 80:
* Import format: Import CSV file into table
* Import format: Import CSV file into table
* Export format: Export query result set as CSV, Json, XML
* Export format: Export query result set as CSV, Json, XML
* Specify Field and Row Terminators:
* Engine supported: MySQL, MSSQL, Oracle, PostgreSQL
* Engine supported: MySQL, MSSQL, Oracle, PostgreSQL
* Software licenses: Proprietary
* Software licenses: Proprietary
Line 80: Line 89:
* Import format: Import CSV file into table
* Import format: Import CSV file into table
* Export format: Export query result set as CSV, SQL insert/merge statement
* Export format: Export query result set as CSV, SQL insert/merge statement
* Specify Field and Row Terminators:
* Engine supported: MySQL
* Engine supported: MySQL
* Software licenses: Proprietary
* Software licenses: Proprietary
Line 89: Line 99:
* Import format: Import CSV, XLS/XLSX/XLSM, FIL, TXT, XML file into table<ref>[https://www.toadworld.com/products/toad-extension-for-eclipse/b/weblog/archive/2014/08/15/export-and-import-your-database-data Export and Import your database data - Toad Extension for Eclipse Blog - Toad Extension for Eclipse - Toad World]</ref>
* Import format: Import CSV, XLS/XLSX/XLSM, FIL, TXT, XML file into table<ref>[https://www.toadworld.com/products/toad-extension-for-eclipse/b/weblog/archive/2014/08/15/export-and-import-your-database-data Export and Import your database data - Toad Extension for Eclipse Blog - Toad Extension for Eclipse - Toad World]</ref>
* Export format: Export query result set as CSV, '''Excel''', HTML/XML, SQL script
* Export format: Export query result set as CSV, '''Excel''', HTML/XML, SQL script
* Specify Field and Row Terminators:
* Engine supported: MySQL
* Engine supported: MySQL
* Software licenses: Proprietary
* Software licenses: Proprietary
Line 97: Line 108:
* Import format: Import CSV/TEXT file into table<ref>[https://www.heidisql.com/screenshots.php?which=import_textfile Screenshot: Import Textfile]</ref>
* Import format: Import CSV/TEXT file into table<ref>[https://www.heidisql.com/screenshots.php?which=import_textfile Screenshot: Import Textfile]</ref>
* Export format: Export query result set as CSV, Json, HTML/XML, SQL query, LaTeX, Wiki markup, Markdown or PHP files."<ref>[https://www.heidisql.com/screenshots.php?which=export_textfile Screenshot: Export Textfile]</ref>
* Export format: Export query result set as CSV, Json, HTML/XML, SQL query, LaTeX, Wiki markup, Markdown or PHP files."<ref>[https://www.heidisql.com/screenshots.php?which=export_textfile Screenshot: Export Textfile]</ref>
* Specify Field and Row Terminators:
* Engine supported:
* Engine supported:
* Software licenses: GPL<ref>[https://www.heidisql.com/help.php#license License]</ref> {{Gd}}
* Software licenses: GPL<ref>[https://www.heidisql.com/help.php#license License]</ref> {{Gd}}
Line 105: Line 117:
* Import format: N/A
* Import format: N/A
* Export format: N/A. Export query result set as Text, CSV, Excel & XML file is available in the paid version.<ref>[http://www.activedbsoft.com/features-querytool.html FlySpeed SQL Query - all essential tools to work with data]</ref>
* Export format: N/A. Export query result set as Text, CSV, Excel & XML file is available in the paid version.<ref>[http://www.activedbsoft.com/features-querytool.html FlySpeed SQL Query - all essential tools to work with data]</ref>
* Specify Field and Row Terminators:
* Engine supported: "Microsoft SQL Server, Oracle, MySQL, MS Access, MS Excel, PostgreSQL, InterBase, Firebird, IBM DB2, Informix, Sybase, Advantage DB, SQLite"
* Engine supported: "Microsoft SQL Server, Oracle, MySQL, MS Access, MS Excel, PostgreSQL, InterBase, Firebird, IBM DB2, Informix, Sybase, Advantage DB, SQLite"
* Software licenses: Proprietary
* Software licenses: Proprietary
Line 113: Line 126:
* Import format: Import CSV, Excel file (XLS), MS Access file & ODBC data source into table
* Import format: Import CSV, Excel file (XLS), MS Access file & ODBC data source into table
* Export format: Export query result set as CSV, Excel file (XLS), XML, HTML, PDF file
* Export format: Export query result set as CSV, Excel file (XLS), XML, HTML, PDF file
* Specify Field and Row Terminators:
* Engine supported: MySQL
* Engine supported: MySQL
* Software licenses: Proprietary
* Software licenses: Proprietary
Line 121: Line 135:
* Import format: N/A
* Import format: N/A
* Export format: Export query result set as SQL file
* Export format: Export query result set as SQL file
* Specify Field and Row Terminators:
* Engine supported: MySQL
* Engine supported: MySQL
* Software licenses: Proprietary
* Software licenses: Proprietary
Line 129: Line 144:
* Import format: CSV
* Import format: CSV
* Export format: Export query result set as SQL file
* Export format: Export query result set as SQL file
* Specify Field and Row Terminators:
* Engine supported: MySQL
* Engine supported: MySQL
* Software licenses: Proprietary
* Software licenses: Proprietary
Line 139: Line 155:
* Import format:
* Import format:
* Export format:
* Export format:
* Specify Field and Row Terminators:
* Engine supported: MySQL
* Engine supported: MySQL
* Software licenses: [https://www.phpmyadmin.net/license/ GNU General Public License, version 2] {{Gd}}
* Software licenses: [https://www.phpmyadmin.net/license/ GNU General Public License, version 2] {{Gd}}
Line 148: Line 165:
* Import format: Import SQL file into table
* Import format: Import SQL file into table
* Export format: Export query result set as SQL, CSV (,), CSV (;) & TSV
* Export format: Export query result set as SQL, CSV (,), CSV (;) & TSV
* Specify Field and Row Terminators:
* Engine supported: MySQL, SQLite, PostgreSQL, MS SQL, Oracle
* Engine supported: MySQL, SQLite, PostgreSQL, MS SQL, Oracle
* Software licenses: "Free for commercial and non-commercial use (Apache License or GPL 2)". Source code is available on [https://github.com/vrana/adminer/ GitHub] {{Gd}}
* Software licenses: "Free for commercial and non-commercial use (Apache License or GPL 2)". Source code is available on [https://github.com/vrana/adminer/ GitHub] {{Gd}}
Line 157: Line 175:
* Import format: Import ... file into table
* Import format: Import ... file into table
* Export format: Export query result set as ...
* Export format: Export query result set as ...
* Specify Field and Row Terminators:
* SQL syntax checker:  
* SQL syntax checker:  
* Engine supported:
* Engine supported:
Retrieved from "https://wiki.planetoid.info/index.php/Special:MobileDiff/19261"

Navigation menu