LemonWiki共筆

Database management tools: Difference between revisions

← Older edit
No edit summary
 
(7 intermediate revisions by the same user not shown)
Line 1: Line 1:
Comparison of database management tools
Comparison of database management tools e.g. import Excel data into a MySQL database


== Lists of database tools ==
== Lists of database tools ==
Line 21: Line 21:
* Data type of cell value:
* Data type of cell value:
* Comments: Quick to export large data (rows count exceed 10,000 rows) {{Gd}}
* Comments: Quick to export large data (rows count exceed 10,000 rows) {{Gd}}
[https://www.heidisql.com/ HeidiSQL] Portable v. 9.5.0.5196  for {{Win}}
* Import format: Import CSV/TEXT file into table<ref>[https://www.heidisql.com/screenshots.php?which=import_textfile Screenshot: Import Textfile]</ref>
* Export format: Export query result set as CSV, Json, HTML/XML, SQL query, LaTeX, Wiki markup, Markdown or PHP files."<ref>[https://www.heidisql.com/screenshots.php?which=export_textfile Screenshot: Export Textfile]</ref>
* Specify Field and Row Terminators:
* Engine supported:
* Software licenses: GPL<ref>[https://www.heidisql.com/help.php#license License]</ref> {{Gd}}
* Data type of cell value:
* Comments:


''$'' [https://www.webyog.com/product/sqlyog SQLyog] Ultimate v. 12.4.3 for {{Win}}
''$'' [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>
* 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>
* 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> (You may convert '''Excel XML''' to Excel .XLSX file by using Microsoft Excel on {{Win}} or [https://zh-tw.libreoffice.org/discover/calc/ LibreOffice Calc])
* Specify Field and Row Terminators: available
* Specify Field and Row Terminators: available
* Engine supported: MySQL & MariaDB<ref>[http://sqlyogkb.webyog.com/article/166-what-is-sqlyog What is SQLyog - 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>
Line 59: Line 68:
* Comments: {{exclaim}} When I tried to export the query result set as XLS file but no file was generated!
* Comments: {{exclaim}} When I tried to export the query result set as XLS file but no file was generated!


[https://www.sequelpro.com/ Sequel Pro] for {{Mac}}
[https://www.sequelpro.com/ Sequel Pro] v. 1.1.2 for {{Mac}}
* Import format: CSV, SQL
* Import format: CSV, SQL
* Export format: (1) Export query result set as CSV/XML file. (2) Export table as SQL/CSV/XML and DOT (ERD Database Structure) file.
* Export format: (1) Export query result set as CSV/XML file. (2) Export table as SQL/CSV/XML and DOT (ERD Database Structure) file.
Line 65: Line 74:
* SQL syntax checker:  
* SQL syntax checker:  
* Engine supported: MySQL<ref>[https://sequelpro.com/docs/get-started/get-connected Getting Connected]</ref>
* Engine supported: MySQL<ref>[https://sequelpro.com/docs/get-started/get-connected Getting Connected]</ref>
* Software licenses: Proprietary
* Software licenses: [https://github.com/sequelpro/sequelpro/blob/master/LICENSE MIT LICENSE]. Source code available on [https://github.com/sequelpro/sequelpro github].
* Data type of cell value:
* Data type of cell value:
* Comments:
* Comments:


''$'' [https://www.jetbrains.com/datagrip/ DataGrip: Cross-Platform IDE for Databases & SQL by JetBrains] v. 2017.2.3 for {{Win}} & {{Mac}} 30 days trial
''$'' [https://www.jetbrains.com/datagrip/ DataGrip: Cross-Platform IDE for Databases & SQL by JetBrains] v. 2020. for {{Win}} & {{Mac}} 30 days trial
* Import format: Import CSV file into table
* Import format: Import CSV, TSV or Pipe-separated 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<ref>[https://www.jetbrains.com/datagrip/features/importexport.html Import/Export Options From CSV To Database - Features | DataGrip]</ref> {{Gd}}
* Export format: Export query result set in two ways (1) Export as file such as CSV, Json, HTML/XML, Excel (2) "Export as queries" update or insert queries<ref>[https://www.jetbrains.com/datagrip/features/importexport.html Import/Export Options From CSV To Database - Features | DataGrip]</ref> {{Gd}}
* Specify Field and Row Terminators:
* Specify Field and Row Terminators:
* 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>  
Line 112: Line 121:
* Engine supported: MySQL
* Engine supported: MySQL
* Software licenses: Proprietary
* Software licenses: Proprietary
* Data type of cell value:
* Comments:
[https://www.heidisql.com/ HeidiSQL] Portable v. 9.4.0.5125  for {{Win}}
* Import format: Import CSV/TEXT file into table<ref>[https://www.heidisql.com/screenshots.php?which=import_textfile Screenshot: Import Textfile]</ref>
* Export format: Export query result set as CSV, Json, HTML/XML, SQL query, LaTeX, Wiki markup, Markdown or PHP files."<ref>[https://www.heidisql.com/screenshots.php?which=export_textfile Screenshot: Export Textfile]</ref>
* Specify Field and Row Terminators:
* Engine supported:
* Software licenses: GPL<ref>[https://www.heidisql.com/help.php#license License]</ref> {{Gd}}
* Data type of cell value:
* Data type of cell value:
* Comments:
* Comments:
Line 201: Line 201:
* [[Export MySQL query to Excel file]]
* [[Export MySQL query to Excel file]]
* [[SQL syntax debug]]
* [[SQL syntax debug]]
* [[NoSQL management tools]]]
* [[NoSQL management tools]]


== References ==
== References ==
<references />
<references />


[[Category:Data Science]] [[Category:Excel]] [[Category:MySQL]] [[Category:Tool]]
[[Category:Data Science]] [[Category:Database]] [[Category:Excel]] [[Category:MySQL]] [[Category:Tool]]
Retrieved from "https://wiki.planetoid.info/index.php/Database_management_tools"