Database management tools

From LemonWiki共筆
Jump to: navigation, search

Comparison of database management tools

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 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!
  • 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!

DbVisualizer Free v. 10.0.1 & Pro v. 10.0.1 (64bit) for Win Os windows.png , Mac 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!
  • 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!

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

  • Import format: Import Access, Excel, CSV, XML file & ODVC source into table[5]
  • Export format: Export query result set as CSV, Json, HTML/XML, Excel XML file[6][7]
  • Specify Field and Row Terminators: available
  • Engine supported: MySQL & MariaDB[8]
  • Software licenses: Proprietary
  • Data type of cell value:
  • Comments: Quick to export large data (rows count exceed 10,000 rows) Good!

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

  • Import format: Import CSV, Json file into table[9]
  • 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!
  • Engine supported: MySQL
  • Software licenses: Proprietary[10]
  • 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 for Mac 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[11]
  • Software licenses: Proprietary
  • Data type of cell value:
  • Comments:

$ DataGrip: Cross-Platform IDE for Databases & SQL by JetBrains v. 2017.2.3 for Win Os windows.png & Mac 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 (2) "Export as queries" update or insert queries[12] Good!
  • 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[13]
  • Software licenses: Proprietary
  • Data type of cell value:
  • Comments:

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

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

$ SQLPro Studio v. 1.0.127 for Mac 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 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[16]
  • 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:

HeidiSQL Portable v. 9.4.0.5125 for Win Os windows.png

  • Import format: Import CSV/TEXT file into table[17]
  • Export format: Export query result set as CSV, Json, HTML/XML, SQL query, LaTeX, Wiki markup, Markdown or PHP files."[18]
  • Specify Field and Row Terminators:
  • Engine supported:
  • Software licenses: GPL[19] Good!
  • 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!
  • 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]