Database management tools: Difference between revisions

From LemonWiki共筆
Jump to navigation Jump to search
No edit summary
Line 7: Line 7:
* Engine supported: MySQL
* Engine supported: MySQL
* Software licenses: Proprietary
* Software licenses: Proprietary
* Comments:


[https://www.mysql.com/products/workbench/ MySQL Workbench] v. 6.3 for {{Win}}, {{Mac}} & {{Linux}}
[https://www.mysql.com/products/workbench/ MySQL Workbench] v. 6.3 for {{Win}}, {{Mac}} & {{Linux}}
Line 13: Line 14:
* Engine supported: MySQL
* Engine supported: MySQL
* Software licenses: Proprietary<ref>[https://dev.mysql.com/doc/workbench/en/wb-preface.html MySQL :: MySQL Workbench Manual :: Preface and Legal Notices]</ref>
* Software licenses: Proprietary<ref>[https://dev.mysql.com/doc/workbench/en/wb-preface.html MySQL :: MySQL Workbench Manual :: Preface and Legal Notices]</ref>
* Comments:


[http://fishcodelib.com/Database.htm Database .NET] for {{Win}}
[http://fishcodelib.com/Database.htm Database .NET] for {{Win}}
Line 19: Line 21:
* 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://www.heidisql.com/ HeidiSQL] for {{Win}}
[https://www.heidisql.com/ HeidiSQL] for {{Win}}
Line 25: Line 28:
* Engine supported:
* Engine supported:
* Software licenses: GPL<ref>[https://www.heidisql.com/help.php#license License]</ref> {{Gd}}
* Software licenses: GPL<ref>[https://www.heidisql.com/help.php#license License]</ref> {{Gd}}
* Comments:
''$'' [https://www.webyog.com/product/sqlyog SQLyog] Ultimate v. 12.4.3 for {{Win}}
* Import format: Import Access, Excel, CSV, XML file & ODVC source into table<ref>[http://sqlyogkb.webyog.com/article/271-import-external-data Import External Data - SQLyog Knowledge Base]</ref>
* Export format: Export query result set as CSV, Json, HTML/XML, '''Excel XML''' file<ref>[http://sqlyogkb.webyog.com/article/215-export-data Export Data - SQLyog Knowledge Base]</ref><ref>[http://sqlyogkb.webyog.com/article/199-exporting-resultset Exporting Resultset - SQLyog Knowledge Base]</ref>
* Engine supported: MySQL & MariaDB<ref>[http://sqlyogkb.webyog.com/article/166-what-is-sqlyog What is SQLyog - SQLyog Knowledge Base]</ref>
* Software licenses: Proprietary
* Comments: Quick to export {{Gd}}


''$'' [https://www.jetbrains.com/datagrip/ DataGrip: Cross-Platform IDE for Databases & SQL by JetBrains] v. 2017.2.2 for {{Mac}} 30 days trial
''$'' [https://www.jetbrains.com/datagrip/ DataGrip: Cross-Platform IDE for Databases & SQL by JetBrains] v. 2017.2.2 for {{Mac}} 30 days trial
Line 31: Line 42:
* Engine supported: MySQL, PostgreSQL, Microsoft SQL Server, Microsoft Azure, Oracle, Amazon Redshift, Sybase, DB2, SQLite, HyperSQL, Apache Derby and H2<ref>[https://www.jetbrains.com/datagrip/features/ Features - DataGrip]</ref>  
* Engine supported: MySQL, PostgreSQL, Microsoft SQL Server, Microsoft Azure, Oracle, Amazon Redshift, Sybase, DB2, SQLite, HyperSQL, Apache Derby and H2<ref>[https://www.jetbrains.com/datagrip/features/ Features - DataGrip]</ref>  
* Software licenses: Proprietary
* Software licenses: Proprietary
* Comments:


''$'' [https://www.sqlprostudio.com/# SQLPro Studio - macOS database management UI]  v. 1.0.127 for {{Mac}}
''$'' [https://www.sqlprostudio.com/# SQLPro Studio - macOS database management UI]  v. 1.0.127 for {{Mac}}
Line 37: Line 49:
* Engine supported: MySQL, MSSQL, Oracle, PostgreSQL
* Engine supported: MySQL, MSSQL, Oracle, PostgreSQL
* Software licenses: Proprietary
* Software licenses: Proprietary
* Comments:


''$'' [https://www.toadworld.com/products/toad-edge Toad Edge] v. 1.1 for {{Win}} & {{Mac}} 30 days trial
''$'' [https://www.toadworld.com/products/toad-edge Toad Edge] v. 1.1 for {{Win}} & {{Mac}} 30 days trial
Line 43: Line 56:
* Engine supported: MySQL
* Engine supported: MySQL
* Software licenses: Proprietary
* Software licenses: Proprietary
* Comments:


(left blank intentionally)
(left blank intentionally)
Line 50: Line 64:
* Engine supported:
* Engine supported:
* Software licenses:
* Software licenses:
* Comments:
</pre>
</pre>


Revision as of 15:49, 25 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
  • Comments:

MySQL Workbench v. 6.3 for Win Os windows.png , macOS 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]
  • Comments:

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 macOS 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 macOS 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 & macOS 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

  1. ↑ Export and Import your database data - Toad Extension for Eclipse Blog - Toad Extension for Eclipse - Toad World
  2. ↑ MySQL :: MySQL Workbench Manual :: 6.5 Data Export and Import
  3. ↑ MySQL :: MySQL Workbench Manual :: Preface and Legal Notices
  4. ↑ Screenshot: Import Textfile
  5. ↑ Screenshot: Export Textfile
  6. ↑ License
  7. ↑ Import External Data - SQLyog Knowledge Base
  8. ↑ Export Data - SQLyog Knowledge Base
  9. ↑ Exporting Resultset - SQLyog Knowledge Base
  10. ↑ What is SQLyog - SQLyog Knowledge Base
  11. ↑ Import/Export Options From CSV To Database - Features | DataGrip
  12. ↑ Features - DataGrip
Retrieved from "https://wiki.planetoid.info/index.php?title=Database_management_tools&oldid=18618"