Database management tools: Difference between revisions
Jump to navigation
Jump to search
(+Toad for MySQL) |
mNo edit summary |
||
| Line 1: | Line 1: | ||
Database management tools | Database management tools | ||
== | == Lists of database tools == | ||
''$'' [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 | ||
* Import format: Import CSV file into table | * Import format: Import CSV file into table | ||
| Line 19: | Line 19: | ||
* Engine supported: MySQL, MSSQL, Oracle, PostgreSQL | * Engine supported: MySQL, MSSQL, Oracle, PostgreSQL | ||
* Software licenses: Proprietary | * Software licenses: Proprietary | ||
== References == | |||
<references /> | |||
[[Category:Data Science]] [[Category:Excel]] [[Category:MySQL]] | [[Category:Data Science]] [[Category:Excel]] [[Category:MySQL]] | ||
Revision as of 15:39, 14 September 2017
Database management tools
Lists of database tools
$ DataGrip: Cross-Platform IDE for Databases & SQL by JetBrains v. 2017.2.2 for macOS 
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[1]
- Engine supported: MySQL, PostgreSQL, Microsoft SQL Server, Microsoft Azure, Oracle, Amazon Redshift, Sybase, DB2, SQLite, HyperSQL, Apache Derby and H2[2]
- Software licenses: Proprietary
Toad for MySQL v. 8.0.0.296 for Win 
- Import format: Import CSV, XLS/XLSX/XLSM, FIL, TXT, XML file into table[3]
- Export format: Export query result set as CSV, Excel, HTML/XML, SQL script
- Engine supported: MySQL
- Software licenses: Proprietary
$ SQLPro Studio - macOS database management UI v. 1.0.127 for macOS
- 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