15,041
edits
Database management tools: Difference between revisions
Jump to navigation
Jump to search
→64 bit OS architecture: + Navicat
(→64 bit OS architecture: + Navicat) |
|||
| Line 37: | Line 37: | ||
* Software licenses: Proprietary | * Software licenses: Proprietary | ||
* Comments: Quick to export {{Gd}} | * 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 43: | Line 42: | ||
* 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<ref>[https://www.jetbrains.com/datagrip/features/importexport.html Import/Export Options From CSV To Database - Features | DataGrip]</ref> {{Gd}} | * 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<ref>[https://www.jetbrains.com/datagrip/features/importexport.html Import/Export Options From CSV To Database - Features | DataGrip]</ref> {{Gd}} | ||
* 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 | |||
* Comments: | |||
''$'' [https://www.navicat.com/cht/products/navicat-premium Navicat Premium] v. 12 for {{Win}} & {{Mac}} 14 days trial | |||
* Import format: Import TXT, CSV, HTML/XML, EXCEL, JSON, Access & DBF file into table <ref>[https://www.navicat.com/cht/products/navicat-premium-feature-matrix Navicat Premium 功能列表 | Navicat]</ref>. | |||
* Export format: Export query result set as TXT, CSV, HTML/XML, '''EXCEL''', JSON, Access & DBF file | |||
* Engine supported: MySQL, MariaDB, SQL Server, Oracle, PostgreSQL, SQLite, Amazon RDS, Amazon Aurora, Amazon Redshift, SQL Azure, Oracle Cloud & Google Cloud<ref>[https://www.navicat.com/cht/products/navicat-premium Navicat Premium | 以單一的 GUI 同時連線到不同類型的資料庫]</ref> | |||
* Software licenses: Proprietary | * Software licenses: Proprietary | ||
* Comments: | * Comments: | ||