Database management tools: Difference between revisions

From LemonWiki共筆
Jump to navigation Jump to search
mNo edit summary
No edit summary
Line 43: Line 43:
* Engine supported: MySQL
* Engine supported: MySQL
* Software licenses: Proprietary
* Software licenses: Proprietary
== Further reading ==
* 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}}


== References ==
== References ==

Revision as of 14:28, 15 September 2017

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

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 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".
  • Engine supported: MySQL
  • Software licenses: Proprietary[3]

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

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

$ 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[7] Good.gif
  • Engine supported: MySQL, PostgreSQL, Microsoft SQL Server, Microsoft Azure, Oracle, Amazon Redshift, Sybase, DB2, SQLite, HyperSQL, Apache Derby and H2[8]
  • Software licenses: Proprietary

$ 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

$ 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

Further reading

References