Difference between revisions of "Database management tools"

From LemonWiki共筆
Jump to navigation Jump to search
Line 15: Line 15:
 
* 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
 +
* Comments:
 +
 +
[https://dbeaver.jkiss.org/ DBeaver] Community Edition v. 4.2.1 (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. XLS is available in the paid version <ref>[https://dbeaver.com/faq/ FAQ | DBeaver Enterprise Edition]</ref>.
 +
* 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> {{Gd}}
 
* Comments:
 
* Comments:
  
Line 52: Line 59:
 
* Software licenses: Proprietary
 
* Software licenses: Proprietary
 
* Comments:
 
* Comments:
 
  
 
=== 32 bit OS architecture ===
 
=== 32 bit OS architecture ===

Revision as of 15:11, 26 September 2017

Database management tools

Lists of database tools

64 bit OS architecture

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[1]
  • Export format: Export query result set as TXT, CSV, Excel Spreadsheet (XML), HTML/XML, SQL INSERT statement
  • Engine supported: MySQL
  • Software licenses: Proprietary[2]
  • Comments: Icon_exclaim.gif 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".

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:

DBeaver Community Edition v. 4.2.1 (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 [3]. More formats e.g. XLS is available in the paid version [4].
  • 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[5] Good.gif
  • Comments:

DbVisualizer Free 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.[6]
  • 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:

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

  • Import format: Import Access, Excel, CSV, XML file & ODVC source into table[7]
  • Export format: Export query result set as CSV, Json, HTML/XML, Excel XML file[8][9]
  • Engine supported: MySQL & MariaDB[10]
  • Software licenses: Proprietary
  • Comments: Quick to export Good.gif


$ DataGrip: Cross-Platform IDE for Databases & SQL by JetBrains v. 2017.2.2 for 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/text such as CSV, Json, HTML/XML (2) "Export as queries" update or insert queries[11] Good.gif
  • 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:

$ 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
  • Engine supported: MySQL, MSSQL, Oracle, PostgreSQL
  • Software licenses: Proprietary
  • 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
  • Engine supported: MySQL
  • Software licenses: Proprietary
  • Comments:

32 bit OS architecture

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[13]
  • 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[14]
  • Export format: Export query result set as CSV, Json, HTML/XML, SQL query, LaTeX, Wiki markup, Markdown or PHP files."[15]
  • Engine supported:
  • Software licenses: GPL[16] Good.gif
  • 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.[17]
  • 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

References