Database management tools: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
|||
Line 7: | Line 7: | ||
* Engine supported: MySQL | * Engine supported: MySQL | ||
* Software licenses: Proprietary | * Software licenses: Proprietary | ||
* Comments: | |||
[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}} | ||
Line 13: | Line 14: | ||
* 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> | ||
* Comments: | |||
[http://fishcodelib.com/Database.htm Database .NET] for {{Win}} | [http://fishcodelib.com/Database.htm Database .NET] for {{Win}} | ||
Line 19: | Line 21: | ||
* 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" | * 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 | * Software licenses: Proprietary | ||
* Comments: | |||
[https://www.heidisql.com/ HeidiSQL] for {{Win}} | [https://www.heidisql.com/ HeidiSQL] for {{Win}} | ||
Line 25: | Line 28: | ||
* Engine supported: | * Engine supported: | ||
* Software licenses: GPL<ref>[https://www.heidisql.com/help.php#license License]</ref> {{Gd}} | * Software licenses: GPL<ref>[https://www.heidisql.com/help.php#license License]</ref> {{Gd}} | ||
* Comments: | |||
''$'' [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> | |||
* 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> | |||
* Engine supported: MySQL & MariaDB<ref>[http://sqlyogkb.webyog.com/article/166-what-is-sqlyog What is SQLyog - SQLyog Knowledge Base]</ref> | |||
* Software licenses: Proprietary | |||
* Comments: Quick to export {{Gd}} | |||
''$'' [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 | ||
Line 31: | Line 42: | ||
* 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> | ||
* Software licenses: Proprietary | * Software licenses: Proprietary | ||
* Comments: | |||
''$'' [https://www.sqlprostudio.com/# SQLPro Studio - macOS database management UI] v. 1.0.127 for {{Mac}} | ''$'' [https://www.sqlprostudio.com/# SQLPro Studio - macOS database management UI] v. 1.0.127 for {{Mac}} | ||
Line 37: | Line 49: | ||
* Engine supported: MySQL, MSSQL, Oracle, PostgreSQL | * Engine supported: MySQL, MSSQL, Oracle, PostgreSQL | ||
* Software licenses: Proprietary | * Software licenses: Proprietary | ||
* Comments: | |||
''$'' [https://www.toadworld.com/products/toad-edge Toad Edge] v. 1.1 for {{Win}} & {{Mac}} 30 days trial | ''$'' [https://www.toadworld.com/products/toad-edge Toad Edge] v. 1.1 for {{Win}} & {{Mac}} 30 days trial | ||
Line 43: | Line 56: | ||
* Engine supported: MySQL | * Engine supported: MySQL | ||
* Software licenses: Proprietary | * Software licenses: Proprietary | ||
* Comments: | |||
(left blank intentionally) | (left blank intentionally) | ||
Line 50: | Line 64: | ||
* Engine supported: | * Engine supported: | ||
* Software licenses: | * Software licenses: | ||
* Comments: | |||
</pre> | </pre> | ||