15,043
edits
Database management tools: Difference between revisions
Jump to navigation
Jump to search
→Lists of database tools
(→Lists of database tools: +FlySpeed SQL Query) |
|||
| Line 2: | Line 2: | ||
== Lists of database tools == | == Lists of database tools == | ||
=== 64 bit OS architecture support === | |||
[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}} | ||
* 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> | * 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> | ||
| Line 16: | Line 10: | ||
* 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". | * 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}} | [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" | * 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" | * 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" | * 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: | * Comments: | ||
| Line 36: | Line 23: | ||
* Software licenses: Proprietary | * Software licenses: Proprietary | ||
* Comments: | * Comments: | ||
''$'' [https://www.webyog.com/product/sqlyog SQLyog] Ultimate v. 12.4.3 for {{Win}} | ''$'' [https://www.webyog.com/product/sqlyog SQLyog] Ultimate v. 12.4.3 for {{Win}} | ||
| Line 57: | Line 30: | ||
* 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 78: | Line 52: | ||
* Software licenses: Proprietary | * Software licenses: Proprietary | ||
* Comments: | * Comments: | ||
=== 32 bit OS architecture support === | |||
[https://www.toadworld.com/products/toad-for-mysql Toad for MySQL] v. 8.0.0.296 for {{Win}} | |||
* Import format: Import CSV, XLS/XLSX/XLSM, FIL, TXT, XML file into table<ref>[https://www.toadworld.com/products/toad-extension-for-eclipse/b/weblog/archive/2014/08/15/export-and-import-your-database-data Export and Import your database data - Toad Extension for Eclipse Blog - Toad Extension for Eclipse - Toad World]</ref> | |||
* Export format: Export query result set as CSV, '''Excel''', HTML/XML, SQL script | |||
* Engine supported: MySQL | |||
* Software licenses: Proprietary | |||
* Comments: | |||
[https://www.heidisql.com/ HeidiSQL] Portable v. 9.4.0.5125 for {{Win}} | |||
* Import format: Import CSV/TEXT file into table<ref>[https://www.heidisql.com/screenshots.php?which=import_textfile Screenshot: Import Textfile]</ref> | |||
* Export format: Export query result set as CSV, Json, HTML/XML, SQL query, LaTeX, Wiki markup, Markdown or PHP files."<ref>[https://www.heidisql.com/screenshots.php?which=export_textfile Screenshot: Export Textfile]</ref> | |||
* Engine supported: | |||
* Software licenses: GPL<ref>[https://www.heidisql.com/help.php#license License]</ref> {{Gd}} | |||
* Comments: | |||
[http://www.activedbsoft.com/features-querytool.html FlySpeed SQL Query] Free v. 3.5.6.3 (32bit) for {{Win}} | |||
* Import format: N/A | |||
* Export format: N/A. Export query result set as Text, CSV, Excel & XML file is available in the paid version.<ref>[http://www.activedbsoft.com/features-querytool.html FlySpeed SQL Query - all essential tools to work with data]</ref> | |||
* Engine supported: "Microsoft SQL Server, Oracle, MySQL, MS Access, MS Excel, PostgreSQL, InterBase, Firebird, IBM DB2, Informix, Sybase, Advantage DB, SQLite" | |||
* Software licenses: Proprietary | |||
* Comments: | |||
[http://www.mysqlfront.de/ MySQL-Front] v. 6.0 (Build 2.20) (32bit) for {{Win}} | |||
* Import format: Import CSV, Excel file (XLS), MS Access file & ODBC data source into table | |||
* Export format: Export query result set as CSV, Excel file (XLS), XML, HTML, PDF file | |||
* Engine supported: MySQL | |||
* Software licenses: Proprietary | |||
* Comments: {{exclaim}} Excel file (XLS) has 65,536 rows limit! | |||
''$'' [https://www.sqlwave.com/ SQLWave] v. 6.12.2 (32 bit) for {{Win}} 15 days trial | ''$'' [https://www.sqlwave.com/ SQLWave] v. 6.12.2 (32 bit) for {{Win}} 15 days trial | ||