Database management tools

From LemonWiki共筆
Revision as of 15:33, 14 September 2017 by Planetoid (talk | contribs) (+Toad for MySQL)
Jump to navigation Jump to search

Database management tools

lists of database tools

$ 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[1] Good.gif
  • 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 Os windows.png

  • 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 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
  1. ↑ Import/Export Options From CSV To Database - Features | DataGrip
  2. ↑ Features - DataGrip
  3. ↑ Export and Import your database data - Toad Extension for Eclipse Blog - Toad Extension for Eclipse - Toad World
Retrieved from "https://wiki.planetoid.info/index.php?title=Database_management_tools&oldid=18586"