Database management tools: Difference between revisions
Jump to navigation
Jump to search
| Line 4: | Line 4: | ||
[https://www.toadworld.com/products/toad-for-mysql Toad for MySQL] v. 8.0.0.296 for {{Win}} | [https://www.toadworld.com/products/toad-for-mysql Toad for MySQL] v. 8.0.0.296 for {{Win}} | ||
* Import format: Import CSV, XLS/XLSX/XLSM, FIL, TXT, XML file into table<ref>[https://www.toadworld.com/products/toad-extension-for-eclipse/b/weblog/archive/2014/08/15/export-and-import-your-database-data Export and Import your database data - Toad Extension for Eclipse Blog - Toad Extension for Eclipse - Toad World]</ref> | * Import format: Import CSV, XLS/XLSX/XLSM, FIL, TXT, XML file into table<ref>[https://www.toadworld.com/products/toad-extension-for-eclipse/b/weblog/archive/2014/08/15/export-and-import-your-database-data Export and Import your database data - Toad Extension for Eclipse Blog - Toad Extension for Eclipse - Toad World]</ref> | ||
* Export format: Export query result set as CSV, Excel, HTML/XML, SQL script | * Export format: Export query result set as CSV, '''Excel''', HTML/XML, SQL script | ||
* Engine supported: MySQL | * Engine supported: MySQL | ||
* Software licenses: Proprietary | * Software licenses: Proprietary | ||
| Line 10: | Line 10: | ||
[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}} | ||
* Import format: Import CSV, Json file into table<ref>[https://dev.mysql.com/doc/workbench/en/wb-admin-export-import.html MySQL :: MySQL Workbench Manual :: 6.5 Data Export and Import]</ref> | * Import format: Import CSV, Json file into table<ref>[https://dev.mysql.com/doc/workbench/en/wb-admin-export-import.html MySQL :: MySQL Workbench Manual :: 6.5 Data Export and Import]</ref> | ||
* Export format: Export query result set as TXT, CSV, Excel Spreadsheet (XML), HTML/XML, SQL INSERT statement | * Export format: Export query result set as TXT, CSV, '''Excel''' Spreadsheet (XML), HTML/XML, SQL INSERT statement | ||
* 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> | ||
Revision as of 17:54, 14 September 2017
Database management tools
Lists of database tools
Toad for MySQL v. 8.0.0.296 for Win 
- 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 , Mac 
& Linux 
- 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]
Database .NET for Win
- Import format:
- Export format:
- Engine supported:
- Software licenses: Proprietary
HeidiSQL for Win
- 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]
$ DataGrip: Cross-Platform IDE for Databases & SQL by JetBrains v. 2017.2.2 for Mac 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]
- 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
- 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
References
- ↑ Export and Import your database data - Toad Extension for Eclipse Blog - Toad Extension for Eclipse - Toad World
- ↑ MySQL :: MySQL Workbench Manual :: 6.5 Data Export and Import
- ↑ MySQL :: MySQL Workbench Manual :: Preface and Legal Notices
- ↑ Screenshot: Import Textfile
- ↑ Screenshot: Export Textfile
- ↑ License
- ↑ Import/Export Options From CSV To Database - Features | DataGrip
- ↑ Features - DataGrip