Difference between revisions of "Database management tools"

From LemonWiki共筆
Jump to navigation Jump to search
m
 
(38 intermediate revisions by the same user not shown)
Line 1: Line 1:
Database management tools
+
Comparison of database management tools e.g. import Excel data into a MySQL database
  
 
== Lists of database tools ==
 
== Lists of database tools ==
=== 64 bit OS architecture support ===
+
=== 64 bit OS architecture ===
 +
[https://dbeaver.jkiss.org/ DBeaver] Community Edition v. 4.2.1 & Enterprise Edition v. 5.2.2 (32bit & 64bit) for {{Win}}, {{Mac}} & {{Linux}}
 +
* 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>.
 +
* 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"
 +
* 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}}
 +
* Data type of cell value: (1) Need to convert string to number/date time type! {{exclaim}} (2) Large number became string type.
 +
* Comments: Quick to export large data (rows count exceed 10,000 rows) {{Gd}}
 +
 
 +
[https://www.dbvis.com/features/ DbVisualizer] Free v. 10.0.1 & Pro v. 10.0.1 (64bit) for {{Win}}, {{Mac}} & {{Linux}}
 +
* 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>
 +
* Specify Field and Row Terminators:
 +
* 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"
 +
* Software licenses: Proprietary
 +
* Data type of cell value:
 +
* Comments: Quick to export large data (rows count exceed 10,000 rows) {{Gd}}
 +
 
 +
[https://www.heidisql.com/ HeidiSQL] Portable v. 9.5.0.5196  for {{Win}}
 +
* 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>
 +
* Specify Field and Row Terminators:
 +
* Engine supported:
 +
* Software licenses: GPL<ref>[https://www.heidisql.com/help.php#license License]</ref> {{Gd}}
 +
* Data type of cell value:
 +
* Comments:
 +
 
 +
''$'' [https://www.webyog.com/product/sqlyog SQLyog] Ultimate v. 12.4.3 for {{Win}}
 +
* 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> (You may convert '''Excel XML''' to Excel .XLSX file by using Microsoft Excel on {{Win}} or [https://zh-tw.libreoffice.org/discover/calc/ LibreOffice Calc])
 +
* 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>
 +
* Software licenses: Proprietary
 +
* Data type of cell value:
 +
* Comments: Quick to export large data (rows count exceed 10,000 rows) {{Gd}}
 +
 
 
[https://www.mysql.com/products/workbench/ MySQL Workbench] v. 6.3 for {{Win}}, {{Mac}} & {{Linux}}
 
[https://www.mysql.com/products/workbench/ MySQL Workbench] v. 6.3 for {{Win}}, {{Mac}} & {{Linux}}
 
* 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}}
 
* Engine supported: MySQL
 
* Engine supported: MySQL
 
* Software licenses: Proprietary<ref>[https://dev.mysql.com/doc/workbench/en/wb-preface.html MySQL :: MySQL Workbench Manual :: Preface and Legal Notices]</ref>
 
* Software licenses: Proprietary<ref>[https://dev.mysql.com/doc/workbench/en/wb-preface.html MySQL :: MySQL Workbench Manual :: Preface and Legal Notices]</ref>
* Comments: {{exclaim}} Excel Spreadsheet (XML) may not be able to opened by Microsoft Excel 2016 or LibreOffice Calc v. 5.2.3.3 when the structure of file is complicated, I met the error message "XML parsing error".
+
* Data type of cell value:
 +
* Comments: {{exclaim}} Excel Spreadsheet (XML) generated by MySql Workbench may not be able to opened by Microsoft Excel 2016 or LibreOffice Calc v. 5.2.3.3 when the structure of file is complicated, I met the error message "XML parsing error".
  
 
[http://fishcodelib.com/Database.htm Database .NET] for {{Win}} 64 bit OS support is available in the paid version.
 
[http://fishcodelib.com/Database.htm Database .NET] for {{Win}} 64 bit OS support is available in the paid version.
 
* 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
 +
* Data type of cell value: Need to convert string to number/date time type! {{exclaim}}
 
* Comments:
 
* Comments:
  
[https://www.dbvis.com/features/ DbVisualizer] Free v. 10.0.1 (64bit) for {{Win}}, {{Mac}} & {{Linux}}
+
[https://sourceforge.net/projects/orbada/ Orbada - Database manager download | SourceForge.net] v. Sao Paulto, Brazil 1.2.5.395 (2016/12/6)
* Import format: N/A. The feature is available in the paid version.
+
* Import format:
* 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: CSV, SQL statement ...
* Engine supported: "DB2 for LUW, H2, JavaDB/Derby, Mimer SQL, MySQL, NuoDB, PostgreSQL, Oracle, Redshift, SQLite, SQL Server, Sybase SQL Anywhere, Sybase ASE, Vertica"
+
* Specify Field and Row Terminators:
* Software licenses: Proprietary
+
* Engine supported: MySQL ...
 +
* Software licenses: GNU General Public License version 2.0 (GPLv2)
 +
* Data type of cell value:
 +
* Comments: {{exclaim}} When I tried to export the query result set as XLS file but no file was generated!
 +
 
 +
[https://www.sequelpro.com/ Sequel Pro] v. 1.1.2 for {{Mac}}
 +
* Import format: CSV, SQL
 +
* Export format: (1) Export query result set as CSV/XML file. (2) Export table as SQL/CSV/XML and DOT (ERD Database Structure) file.
 +
* Specify Field and Row Terminators: Available
 +
* SQL syntax checker:
 +
* Engine supported: MySQL<ref>[https://sequelpro.com/docs/get-started/get-connected Getting Connected]</ref>
 +
* Software licenses: [https://github.com/sequelpro/sequelpro/blob/master/LICENSE MIT LICENSE]. Source code available on [https://github.com/sequelpro/sequelpro github].
 +
* Data type of cell value:
 
* Comments:
 
* Comments:
  
''$'' [https://www.webyog.com/product/sqlyog SQLyog] Ultimate v. 12.4.3 for {{Win}}
+
''$'' [https://www.jetbrains.com/datagrip/ DataGrip: Cross-Platform IDE for Databases & SQL by JetBrains] v. 2020. for {{Win}} & {{Mac}} 30 days trial
* 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 CSV file into table
* 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 in two ways (1) Export as file such as CSV, Json, HTML/XML, Excel (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}}
* Engine supported: MySQL & MariaDB<ref>[http://sqlyogkb.webyog.com/article/166-what-is-sqlyog What is SQLyog - SQLyog Knowledge Base]</ref>
+
* 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>  
 
* Software licenses: Proprietary
 
* Software licenses: Proprietary
* Comments: Quick to export {{Gd}}
+
* Data type of cell value:
 +
* Comments:
  
 
+
''$'' [https://www.navicat.com/cht/products/navicat-premium Navicat Premium] v. 12 for {{Win}} & {{Mac}} 14 days trial
''$'' [https://www.jetbrains.com/datagrip/ DataGrip: Cross-Platform IDE for Databases & SQL by JetBrains] v. 2017.2.2 for {{Mac}} 30 days trial
+
* 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 CSV file into table
+
* Export format: Export query result set as TXT, CSV, HTML/XML, '''EXCEL''', JSON, Access & DBF file
* Export format: Export query result set in two ways (1) Export as file/text 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: available
* 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, 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
 +
* Data type of cell value: No need to convert string to number/date time type! {{Gd}}
 
* Comments:
 
* Comments:
  
Line 42: Line 99:
 
* 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
 +
* Data type of cell value:
 
* Comments:
 
* Comments:
  
Line 49: Line 108:
 
* 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
 +
* Data type of cell value:
 
* Comments:
 
* Comments:
  
 
+
=== 32 bit OS architecture ===
=== 32 bit OS architecture support ===
 
 
[https://www.toadworld.com/products/toad-for-mysql Toad for MySQL] v. 8.0.0.296 for {{Win}}
 
[https://www.toadworld.com/products/toad-for-mysql Toad for MySQL] v. 8.0.0.296 for {{Win}}
 
* 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
* Comments:
+
* Data type of cell value:
 
 
[https://www.heidisql.com/ HeidiSQL] Portable v. 9.4.0.5125  for {{Win}}
 
* 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>
 
* Engine supported:
 
* Software licenses: GPL<ref>[https://www.heidisql.com/help.php#license License]</ref> {{Gd}}
 
 
* Comments:
 
* Comments:
  
Line 72: Line 127:
 
* 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
 +
* Data type of cell value:
 
* Comments:
 
* Comments:
  
Line 79: Line 136:
 
* 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
 +
* Data type of cell value:
 
* Comments: {{exclaim}} Excel file (XLS) has 65,536 rows limit!
 
* Comments: {{exclaim}} Excel file (XLS) has 65,536 rows limit!
  
Line 86: Line 145:
 
* 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
 +
* Data type of cell value:
 
* Comments:
 
* Comments:
  
Line 93: Line 154:
 
* 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
 +
* Data type of cell value:
 
* Comments: {{exclaim}} I met the message "Error 1300: Invalid utf8 character string: '\xA5D\xA4\xC0' " after query.
 
* Comments: {{exclaim}} I met the message "Error 1300: Invalid utf8 character string: '\xA5D\xA4\xC0' " after query.
 +
 +
 +
=== Architecture independent (using browser) ===
 +
[https://www.phpmyadmin.net/ phpMyAdmin]
 +
* Import format:
 +
* Export format:
 +
* Specify Field and Row Terminators:
 +
* Engine supported: MySQL
 +
* Software licenses: [https://www.phpmyadmin.net/license/ GNU General Public License, version 2] {{Gd}}
 +
* Data type of cell value:
 +
* Comments:
 +
 +
 +
[https://www.adminer.org/ Adminer]
 +
* Import format: Import SQL file into table
 +
* Export format: Export query result set as SQL, CSV (,), CSV (;) & TSV
 +
* Specify Field and Row Terminators:
 +
* 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}}
 +
* Data type of cell value:
 +
* Comments:
  
 
(left blank intentionally)
 
(left blank intentionally)
Line 101: Line 185:
 
* 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:
 
* Engine supported:
 
* Engine supported:
 
* Software licenses:
 
* Software licenses:
 +
* Data type of cell value:
 
* Comments:
 
* Comments:
 
</pre>
 
</pre>
  
 
== Further reading ==
 
== Further reading ==
 +
* Wikipedia contributors (2017). [https://en.wikipedia.org/wiki/Comparison_of_database_tools Comparison of database tools - Wikipedia] {{access | date = 2017-09-26}}
 +
* [https://en.wikipedia.org/wiki/Category:Database_administration_tools Category:Database administration tools - Wikipedia] {{access | date = 2017-09-26}}
 
* Rob Gravelle (2016). [http://www.databasejournal.com/features/mysql/slideshows/top-10-mysql-gui-tools.html Top 10 MySQL GUI Tools — DatabaseJournal.com] {{access | date = 2017-09-15}}
 
* Rob Gravelle (2016). [http://www.databasejournal.com/features/mysql/slideshows/top-10-mysql-gui-tools.html Top 10 MySQL GUI Tools — DatabaseJournal.com] {{access | date = 2017-09-15}}
 +
* Andrew Tabona (2015). [https://techtalk.gfi.com/top-10-free-database-tools-for-sys-admins/ Top 10 free database tools for sys admins] {{access | date = 2017-09-26}}
 +
* [https://www.quora.com/What-is-the-best-MySQL-client-for-Mac-OS-X-or-Windows (4) What is the best MySQL client for Mac OS X or Windows? - Quora] {{access | date = 2018-02-15}}
 
* [[Export MySQL query to Excel file]]
 
* [[Export MySQL query to Excel file]]
 +
* [[SQL syntax debug]]
 +
* [[NoSQL management tools]]
  
 
== References ==
 
== References ==
 
<references />
 
<references />
  
[[Category:Data Science]] [[Category:Excel]] [[Category:MySQL]] [[Category:Tool]]
+
[[Category:Data Science]] [[Category:Database]] [[Category:Excel]] [[Category:MySQL]] [[Category:Tool]]

Latest revision as of 15:42, 6 October 2021

Comparison of database management tools e.g. import Excel data into a MySQL database

Lists of database tools[edit]

64 bit OS architecture[edit]

DBeaver Community Edition v. 4.2.1 & Enterprise Edition v. 5.2.2 (32bit & 64bit) for Win Os windows.png , Mac icon_os_mac.png & Linux Os linux.png

  • Import format: Import file into table is not availabe.
  • Export format: Export query result set as CSV, HTML, XML, JSON file [1]. More formats e.g. XLSX is available in the paid version [2].
  • 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"
  • Software licenses: Open source - Apache License Version 2.0[3]. Source code is available on github.Good.gif
  • Data type of cell value: (1) Need to convert string to number/date time type! Icon_exclaim.gif (2) Large number became string type.
  • Comments: Quick to export large data (rows count exceed 10,000 rows) Good.gif

DbVisualizer Free v. 10.0.1 & Pro v. 10.0.1 (64bit) for Win Os windows.png , Mac icon_os_mac.png & Linux Os linux.png

  • 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.[4]
  • Specify Field and Row Terminators:
  • SQL syntax checker: Available Good.gif
  • Engine supported: "DB2 for LUW, H2, JavaDB/Derby, Mimer SQL, MySQL, NuoDB, PostgreSQL, Oracle, Redshift, SQLite, SQL Server, Sybase SQL Anywhere, Sybase ASE, Vertica"
  • Software licenses: Proprietary
  • Data type of cell value:
  • Comments: Quick to export large data (rows count exceed 10,000 rows) Good.gif

HeidiSQL Portable v. 9.5.0.5196 for Win Os windows.png

  • Import format: Import CSV/TEXT file into table[5]
  • Export format: Export query result set as CSV, Json, HTML/XML, SQL query, LaTeX, Wiki markup, Markdown or PHP files."[6]
  • Specify Field and Row Terminators:
  • Engine supported:
  • Software licenses: GPL[7] Good.gif
  • Data type of cell value:
  • Comments:

$ SQLyog Ultimate v. 12.4.3 for Win Os windows.png

  • Import format: Import Access, Excel, CSV, XML file & ODVC source into table[8]
  • Export format: Export query result set as CSV, Json, HTML/XML, Excel XML file[9][10] (You may convert Excel XML to Excel .XLSX file by using Microsoft Excel on Win Os windows.png or LibreOffice Calc)
  • Specify Field and Row Terminators: available
  • Engine supported: MySQL & MariaDB[11]
  • Software licenses: Proprietary
  • Data type of cell value:
  • Comments: Quick to export large data (rows count exceed 10,000 rows) Good.gif

MySQL Workbench v. 6.3 for Win Os windows.png , Mac icon_os_mac.png & Linux Os linux.png

  • Import format: Import CSV, Json file into table[12]
  • 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 Good.gif
  • Engine supported: MySQL
  • Software licenses: Proprietary[13]
  • Data type of cell value:
  • Comments: Icon_exclaim.gif Excel Spreadsheet (XML) generated by MySql Workbench may not be able to opened by Microsoft Excel 2016 or LibreOffice Calc v. 5.2.3.3 when the structure of file is complicated, I met the error message "XML parsing error".

Database .NET for Win Os windows.png 64 bit OS support is available in the paid version.

  • 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"
  • 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"
  • Software licenses: Proprietary
  • Data type of cell value: Need to convert string to number/date time type! Icon_exclaim.gif
  • Comments:

Orbada - Database manager download | SourceForge.net v. Sao Paulto, Brazil 1.2.5.395 (2016/12/6)

  • Import format:
  • Export format: CSV, SQL statement ...
  • Specify Field and Row Terminators:
  • Engine supported: MySQL ...
  • Software licenses: GNU General Public License version 2.0 (GPLv2)
  • Data type of cell value:
  • Comments: Icon_exclaim.gif When I tried to export the query result set as XLS file but no file was generated!

Sequel Pro v. 1.1.2 for Mac icon_os_mac.png

  • Import format: CSV, SQL
  • Export format: (1) Export query result set as CSV/XML file. (2) Export table as SQL/CSV/XML and DOT (ERD Database Structure) file.
  • Specify Field and Row Terminators: Available
  • SQL syntax checker:
  • Engine supported: MySQL[14]
  • Software licenses: MIT LICENSE. Source code available on github.
  • Data type of cell value:
  • Comments:

$ DataGrip: Cross-Platform IDE for Databases & SQL by JetBrains v. 2020. for Win Os windows.png & Mac icon_os_mac.png 30 days trial

  • 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, Excel (2) "Export as queries" update or insert queries[15] Good.gif
  • 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[16]
  • Software licenses: Proprietary
  • Data type of cell value:
  • Comments:

$ Navicat Premium v. 12 for Win Os windows.png & Mac icon_os_mac.png 14 days trial

  • Import format: Import TXT, CSV, HTML/XML, EXCEL, JSON, Access & DBF file into table [17].
  • 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[18]
  • Software licenses: Proprietary
  • Data type of cell value: No need to convert string to number/date time type! Good.gif
  • Comments:

$ SQLPro Studio v. 1.0.127 for Mac icon_os_mac.png

  • Import format: Import CSV file into table
  • Export format: Export query result set as CSV, Json, XML
  • Specify Field and Row Terminators:
  • Engine supported: MySQL, MSSQL, Oracle, PostgreSQL
  • Software licenses: Proprietary
  • Data type of cell value:
  • Comments:

$ Toad Edge v. 1.1 for Win Os windows.png & Mac icon_os_mac.png 30 days trial

  • Import format: Import CSV file into table
  • Export format: Export query result set as CSV, SQL insert/merge statement
  • Specify Field and Row Terminators:
  • Engine supported: MySQL
  • Software licenses: Proprietary
  • Data type of cell value:
  • Comments:

32 bit OS architecture[edit]

Toad for MySQL v. 8.0.0.296 for Win Os windows.png

  • Import format: Import CSV, XLS/XLSX/XLSM, FIL, TXT, XML file into table[19]
  • Export format: Export query result set as CSV, Excel, HTML/XML, SQL script
  • Specify Field and Row Terminators:
  • Engine supported: MySQL
  • Software licenses: Proprietary
  • Data type of cell value:
  • Comments:

FlySpeed SQL Query Free v. 3.5.6.3 (32bit) for Win Os windows.png

  • Import format: N/A
  • Export format: N/A. Export query result set as Text, CSV, Excel & XML file is available in the paid version.[20]
  • 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"
  • Software licenses: Proprietary
  • Data type of cell value:
  • Comments:

MySQL-Front v. 6.0 (Build 2.20) (32bit) for Win Os windows.png

  • 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
  • Specify Field and Row Terminators:
  • Engine supported: MySQL
  • Software licenses: Proprietary
  • Data type of cell value:
  • Comments: Icon_exclaim.gif Excel file (XLS) has 65,536 rows limit!

$ SQLWave v. 6.12.2 (32 bit) for Win Os windows.png 15 days trial

  • Import format: N/A
  • Export format: Export query result set as SQL file
  • Specify Field and Row Terminators:
  • Engine supported: MySQL
  • Software licenses: Proprietary
  • Data type of cell value:
  • Comments:

$ MyDB Studio v. 1.3 (32bit) for Win Os windows.png 30 days trial

  • Import format: CSV
  • Export format: Export query result set as SQL file
  • Specify Field and Row Terminators:
  • Engine supported: MySQL
  • Software licenses: Proprietary
  • Data type of cell value:
  • Comments: Icon_exclaim.gif I met the message "Error 1300: Invalid utf8 character string: '\xA5D\xA4\xC0' " after query.


Architecture independent (using browser)[edit]

phpMyAdmin


Adminer

  • Import format: Import SQL file into table
  • Export format: Export query result set as SQL, CSV (,), CSV (;) & TSV
  • Specify Field and Row Terminators:
  • 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 GitHub Good.gif
  • Data type of cell value:
  • Comments:

(left blank intentionally)

* Import format: Import ... file into table
* Export format: Export query result set as ...
* Specify Field and Row Terminators:
* SQL syntax checker: 
* Engine supported:
* Software licenses:
* Data type of cell value:
* Comments:

Further reading[edit]

References[edit]