Database management tools

From LemonWiki共筆
Jump to: navigation, search

Database management tools

Lists of database tools[edit]

64 bit OS architecture[edit]

DBeaver Community Edition v. 4.2.1 & Enterprise Edition v. 4.2.1 (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].
  • 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!
  • 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]
  • 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
  • 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]
  • Engine supported: MySQL & MariaDB[8]
  • Software licenses: Proprietary
  • 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
  • Engine supported: MySQL
  • Software licenses: Proprietary[10]
  • 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"
  • 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
  • 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 ...
  • Engine supported: MySQL ...
  • Software licenses: GNU General Public License version 2.0 (GPLv2)
  • Comments: Icon exclaim.gif When I tried to export the query result set as XLS file but no file was generated!

$ DataGrip: Cross-Platform IDE for Databases & SQL by JetBrains v. 2017.2.2 for 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[11] Good!
  • Engine supported: MySQL, PostgreSQL, Microsoft SQL Server, Microsoft Azure, Oracle, Amazon Redshift, Sybase, DB2, SQLite, HyperSQL, Apache Derby and H2[12]
  • Software licenses: Proprietary
  • 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 [13].
  • Export format: Export query result set as TXT, CSV, HTML/XML, EXCEL, JSON, Access & DBF file
  • Engine supported: MySQL, MariaDB, SQL Server, Oracle, PostgreSQL, SQLite, Amazon RDS, Amazon Aurora, Amazon Redshift, SQL Azure, Oracle Cloud & Google Cloud[14]
  • Software licenses: Proprietary
  • 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
  • Engine supported: MySQL, MSSQL, Oracle, PostgreSQL
  • Software licenses: Proprietary
  • 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
  • Engine supported: MySQL
  • Software licenses: Proprietary
  • 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[15]
  • Export format: Export query result set as CSV, Excel, HTML/XML, SQL script
  • Engine supported: MySQL
  • Software licenses: Proprietary
  • Comments:

HeidiSQL Portable v. 9.4.0.5125 for Win Os windows.png

  • Import format: Import CSV/TEXT file into table[16]
  • Export format: Export query result set as CSV, Json, HTML/XML, SQL query, LaTeX, Wiki markup, Markdown or PHP files."[17]
  • Engine supported:
  • Software licenses: GPL[18] Good!
  • 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.[19]
  • Engine supported: "Microsoft SQL Server, Oracle, MySQL, MS Access, MS Excel, PostgreSQL, InterBase, Firebird, IBM DB2, Informix, Sybase, Advantage DB, SQLite"
  • Software licenses: Proprietary
  • 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
  • Engine supported: MySQL
  • Software licenses: Proprietary
  • 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
  • Engine supported: MySQL
  • Software licenses: Proprietary
  • 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
  • Engine supported: MySQL
  • Software licenses: Proprietary
  • Comments: Icon exclaim.gif I met the message "Error 1300: Invalid utf8 character string: '\xA5D\xA4\xC0' " after query.

(left blank intentionally)

* Import format: Import ... file into table
* Export format: Export query result set as ...
* Engine supported:
* Software licenses:
* Comments:

Further reading[edit]

References[edit]

  1. Features | DBeaver
  2. FAQ | DBeaver Enterprise Edition
  3. About | DBeaver
  4. Data Visualization & DB Management Features - DbVisualizer
  5. Import External Data - SQLyog Knowledge Base
  6. Export Data - SQLyog Knowledge Base
  7. Exporting Resultset - SQLyog Knowledge Base
  8. What is SQLyog - SQLyog Knowledge Base
  9. MySQL :: MySQL Workbench Manual :: 6.5 Data Export and Import
  10. MySQL :: MySQL Workbench Manual :: Preface and Legal Notices
  11. Import/Export Options From CSV To Database - Features | DataGrip
  12. Features - DataGrip
  13. Navicat Premium 功能列表 | Navicat
  14. Navicat Premium | 以單一的 GUI 同時連線到不同類型的資料庫
  15. Export and Import your database data - Toad Extension for Eclipse Blog - Toad Extension for Eclipse - Toad World
  16. Screenshot: Import Textfile
  17. Screenshot: Export Textfile
  18. License
  19. FlySpeed SQL Query - all essential tools to work with data