Navicat (Database administration – MySQL Client) is a powerful MySQL database administration tool which can convert your DBF, CSV, text, or XML files to MySQL databases, eliminating time-consuming data entry and the errors that accompany it.
It is more than just a simple MySQL admin client, other useful major features include back-up/restore databases, data transfer, import/export wizard, visual query builder, batch job scheduling, data synchronization, and SSH tunnel.
New in this Version:
- Navicat version 8 for Mac OS X is a major version release and is available with significant improvements and compatibility with Mac OS X Leopard.
- Enhanced support of new MySQL server versions
- Support of Form View
- Support of Code Completion in all SQL Editor
- Support of ODBC Import
- Support of exporting Excel file
- Many more enhancements.
What's New
Windows
Improvements:
-
In Table Viewer, MySQL Limit clause will now exclude from the
Update/Delete statement if primary key does not exist.
Bug Fixes:
- Collations could not be changed for MySQL 4.1.
- When altered MySQL View definer, wrong quoting applied.
- When altered Function (PostgreSQL 8.0 or before), all its parameters
would be lost after saved. - When running backup for PostgreSQL database, duplicate/missing
records would happen. - "ORA-00932" error occured when opening Oracle 9i table, which
contained FLOAT type, in Table Viewer. - Word Wrap status did not save in the Query Editor.
- "Access violation" error occured when adding "Order By" or selecting
any fields after "Select * from table" being run several times in Query
Builder. - When import from ODBC with empty tables, "BOF/EOF access" error
would occur. - Error dialog occured when selecting target connection in Data
Transfer.
Mac
Improvements:
- Improved the compatibility in MySQL SSL connection.
- Improved the support of bigger data in each cell of Excel file
during Export Wizard. - It now has no restriction on jointing the data type fields in Query
Builder.
Bug Fixes:
- Deadlock occured when opening new windows using SSH Connection.
- Fixed crash problem during Import Wizard.
- The "Run" button would be disabled in some cases even the SQL
stopped running in Query Editor.
Linux
Improvements:
-
In Table Viewer, MySQL Limit clause will now exclude from the
Update/Delete statement if primary key does not exist.
Bug Fixes:
- Collations could not be changed for MySQL 4.1.
- When altered MySQL View definer, wrong quoting applied.
- When altered Function (PostgreSQL 8.0 or before), all its parameters
would be lost after saved. - When running backup for PostgreSQL database, duplicate/missing
records would happen. - "ORA-00932" error occured when opening Oracle 9i table, which
contained FLOAT type, in Table Viewer. - Word Wrap status did not save in the Query Editor.
- "Access violation" error occured when adding "Order By" or selecting
any fields after "Select * from table" being run several times in Query
Builder. - When import from ODBC with empty tables, "BOF/EOF access" error
would occur. - Error dialog occured when selecting target connection in Data
Transfer.