Database management tools
Jump to navigation
Jump to search
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
- Comments:
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]
- Comments: 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
- 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
- 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]
- Comments:
$ SQLyog Ultimate v. 12.4.3 for Win
- 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
$ 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[11]
- 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
- 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 & Mac 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
- Rob Gravelle (2016). Top 10 MySQL GUI Tools — DatabaseJournal.com [Last visited: 2017-09-15]
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 External Data - SQLyog Knowledge Base
- ↑ Export Data - SQLyog Knowledge Base
- ↑ Exporting Resultset - SQLyog Knowledge Base
- ↑ What is SQLyog - SQLyog Knowledge Base
- ↑ Import/Export Options From CSV To Database - Features | DataGrip
- ↑ Features - DataGrip