Database management tools

From LemonWiki共筆
Jump to navigation Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

Database management tools

Lists of database tools

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[1]
  • Export format: Export query result set as CSV, Excel, HTML/XML, SQL script
  • Engine supported: MySQL
  • Software licenses: Proprietary
  • Comments:

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

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

HeidiSQL for Win Os windows.png

  • Import format: Import CSV/TEXT file into table[4]
  • Export format: Export query result set as CSV, Json, HTML/XML, SQL query, LaTeX, Wiki markup, Markdown or PHP files."[5]
  • Engine supported:
  • Software licenses: GPL[6] Good.gif
  • 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 - macOS database management UI 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:

(left blank intentionally)

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

Further reading

References