15,041
edits
Database management tools: Difference between revisions
Jump to navigation
Jump to search
m
→64 bit OS architecture
| Line 3: | Line 3: | ||
== Lists of database tools == | == Lists of database tools == | ||
=== 64 bit OS architecture === | === 64 bit OS architecture === | ||
[https://dbeaver.jkiss.org/ DBeaver] Community Edition v. 4.2.1 & Enterprise Edition v. 4.2.1 (32bit & 64bit) for {{Win}}, {{Mac}} & {{Linux}} | [https://dbeaver.jkiss.org/ DBeaver] Community Edition v. 4.2.1 & Enterprise Edition v. 4.2.1 (32bit & 64bit) for {{Win}}, {{Mac}} & {{Linux}} | ||
* Import format: Import file into table is not availabe. | * Import format: Import file into table is not availabe. | ||
| Line 37: | Line 23: | ||
* Software licenses: Proprietary | * Software licenses: Proprietary | ||
* Comments: Quick to export large data (rows count exceed 10,000 rows) {{Gd}} | * Comments: Quick to export large data (rows count exceed 10,000 rows) {{Gd}} | ||
[https://www.mysql.com/products/workbench/ MySQL Workbench] v. 6.3 for {{Win}}, {{Mac}} & {{Linux}} | |||
* Import format: Import CSV, Json file into table<ref>[https://dev.mysql.com/doc/workbench/en/wb-admin-export-import.html MySQL :: MySQL Workbench Manual :: 6.5 Data Export and Import]</ref> | |||
* Export format: Export query result set as TXT, CSV, Excel Spreadsheet (XML), HTML/XML, SQL INSERT statement | |||
* 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> | |||
* Comments: {{exclaim}} 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". | |||
[http://fishcodelib.com/Database.htm Database .NET] for {{Win}} 64 bit OS support is available in the paid version. | |||
* 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: | |||
''$'' [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 | ||