Navicat 8.2.20

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:

1. Collations could not be changed for MySQL 4.1.
2. When altered MySQL View definer, wrong quoting applied.
3. When altered Function (PostgreSQL 8.0 or before), all its parameters
   would be lost after saved.
4. When running backup for PostgreSQL database, duplicate/missing
   records would happen.
5. "ORA-00932" error occured when opening Oracle 9i table, which
   contained FLOAT type, in Table Viewer.
6. Word Wrap status did not save in the Query Editor.
7. "Access violation" error occured when adding "Order By" or selecting
   any fields after "Select * from table" being run several times in Query
   Builder.
8. When import from ODBC with empty tables, "BOF/EOF access" error
   would occur.
9. Error dialog occured when selecting target connection in Data
   Transfer.

Mac

Improvements:

1. Improved the compatibility in MySQL SSL connection.
2. Improved the support of bigger data in each cell of Excel file
   during Export Wizard.
3. It now has no restriction on jointing the data type fields in Query
   Builder.

Bug Fixes:

1. Deadlock occured when opening new windows using SSH Connection.
2. Fixed crash problem during Import Wizard.
3. 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:

1. Collations could not be changed for MySQL 4.1.
2. When altered MySQL View definer, wrong quoting applied.
3. When altered Function (PostgreSQL 8.0 or before), all its parameters
   would be lost after saved.
4. When running backup for PostgreSQL database, duplicate/missing
   records would happen.
5. "ORA-00932" error occured when opening Oracle 9i table, which
   contained FLOAT type, in Table Viewer.
6. Word Wrap status did not save in the Query Editor.
7. "Access violation" error occured when adding "Order By" or selecting
   any fields after "Select * from table" being run several times in Query
   Builder.
8. When import from ODBC with empty tables, "BOF/EOF access" error
   would occur.
9. Error dialog occured when selecting target connection in Data
   Transfer.