If you have purchased our products and want to retrieve the download information of the latest version, please click here
Feb 24 2010
Navicat for MySQL (Windows) version 8.2.20 is now available
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.
- 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.
Upgrade Procedure : click here to upgrade
Jan 19 2010
Navicat for MySQL (Windows) version 8.2.19 is now available
Bug Fixes:
- Restore function could not work properly.
- Insert Field did not work in Table Designer.
Upgrade Procedure : click here to upgrade
Jan 12 2010
Navicat for MySQL (Windows) version 8.2.18 is now available
Improvements:
- If length does not specify for MySQL char/varchar, 255 value will now be assigned when saving a table.
Bug Fixes:
- When using MySQL HTTP Tunnel connection and user tried to add/duplicate an user. After pressing OK to close the user form, Navicat would sometimes causes "Access Violation" error.
- When altered a MySQL data type that contains unsigned/zerofill properties into BIT type, table could not be saved in Table Designer.
- BIT type default value could not be handled properly in some MySQL server.
- "1055" errod occured when running MySQL queries after the SQL mode was set into 'TRADITIONAL,ONLY_FULL_GROUP_BY,NO_AUTO_VALUE_ON_ZERO'.
- "1045 - Access denied" error occured when a target server was not selected during MySQL Data Transfer.
- Events and Sequences could not shown under Object Selection tab in Restore form.
Upgrade Procedure : click here to upgrade
Nov 18 2009
Navicat for MySQL (Windows) version 8.2.17 is now available
Improvements:
- In step 6 of Import Wizard, Source field name would be truncated if longer than 255 characters. Now, Navicat supports up to 5000 field name characters.
Bug Fixes:
- MySQL Auto increment value could not be altered if "Use DDL from SHOW CREATE TABLE" option was disabled with "Include Auto Increment" option being checked in Data Transfer.
- Refresh did not work for getting update data.
- When import text-based file using Import Wizard, Navicat was unable to get the number of columns correctly if the file did not contain field name row or there were empty lines existed before first data row.
Upgrade Procedure : click here to upgrade
Oct 28 2009
Navicat for MySQL (Windows) version 8.2.16 is now available
Bug Fixes:
- The cursor position moved to end-of-line after saved the Stored Procesure/Function.
- "Access Violation" error occured when getting the Event information from Linux server.
- Failed to establish SSH connection when the private key path contained unicode.
- when the server name contain unicode characters, this server name was unreadable in SQL file which created using Data Transfer feature.
- "Control 'ppParameterEditor' has no parent window" error occured when clicked on the ParametersEditor button which under Generation topic in Report Builder.
- When a table contained some long field names, those field names were only partialy visible or even invisible in Form View.
- When resizing the Data Transfer/Data Synchronization/Structure Synchronization window, all data fields expanded to display longer content except the "profile" drop down list.
Upgrade Procedure : click here to upgrade
Oct 5 2009
Navicat for MySQL (Windows) version 8.2.15 is now available
Bug Fixes:
- "Truncate Table" function did not work with multiple tables if using HTTP Tunnel connection.
Upgrade Procedure : click here to upgrade
Sep 25 2009
Navicat for MySQL (Windows) version 8.2.14 is now available
Improvements:
- "Exceed package size..." error will now occur to remind you to enlarge the max_allowed_packet variable if the records larger than the maximum packet size setting when running Data Synchronisation for MySQl server.
- Report Builder now accepts datetime function for MySQL server.
Bug Fixes:
- "Property cannot be found" error occured when importing Access file with datatype that may involve decimal places info, e.g.currecy, number, floating point value.
- BLOB data in text file was unable to import successfully.
- When added a new field (without labelling its name) in MySQL server usng Table Designer, then click the Move Up button. The last field in the table would be disappeared.
- "List index out of bound" error occured when using an account, which did not have enough privileges, to open MySQL Stored Procedure/Function.
- "Access Violation" error occured when exporting data to Access file if using HTTP Tunnel connection.
Upgrade Procedure : click here to upgrade
Sep 3 2009
Navicat for MySQL (Window) version 8.2.13 is now available
Improvements:
- The Data Synchronization message log will not show server name rather than Host/IP.
Bug Fixes:
- When applied comma as decimal seperator, Data Synchronization would cause problem.
- Date field was not converted correctly when exported to DBF file.
- Undo (Ctrl + z) function did not work properly on memo editor in Table Viewer.
- Docked windows could not show in task bar under Windows 7.
- Email attachment in Schedule could not be sent if "Add timestamp" option was enabled in Export Wizard.
Upgrade Procedure : click here to upgrade
Aug 11 2009
Navicat for MySQL (Window) version 8.2.12 is now available
Improvements:
- Support specify the socket name in Connection for MySQL server.
- Improve suggestion on target data type and provide a default precision and scale information in Import Wizard.
- Support export to clipboard.
Bug Fixes:
- When docking a console window to main window, the wheel of mouse would be no effect.
- Month calendar Could not fully display in some system.
- If password did not save in Connection Properties, Dump SQL File would not work propertly.
Upgrade Procedure : click here to upgrade
Jul 22 2009
Navicat for MySQL (Windows) version 8.2.11 is now available
Bug Fixes:
- "SSH Tunnel:''is not a valid integer value" error occured during SSH connection.
- When exported data to MS Access, month and day values were mixed up.
- Slow problem while transfering data from command line.
- Access Violation error happened when creating new table with index.
- Index, constraint and trigger could not be renamed in Table Designer.
Upgrade Procedure : click here to upgrade
Jul 13 2009
Navicat for MySQL (Windows) version 8.2.9 is now available
Enhancement:
- Improved connection alive issue for MySQL server.
Bug Fixes:
- When ran "LOAD DATA LOCAL FILE" in Query Editor to import data to MySQL database, Access violation error occured.
- If table names stated with number e.g. 1Table, those tables were not displayed on the Query Builder.
- when using Find (ctrl+f) in Form View, it would jump out of Form View into Grid View.
- When applied docking feature under Windows 7, "System Error. Code: 87. The parameter is incorrect" occured.
- Fixed "Select" statement with empty string in Query Editor resulted in Access violation.
Upgrade Procedure : click here to upgrade
Jul 9 2009
Navicat for MySQL (Windows) version 8.2.8 is now available
Enhancement:
- Improved dual monitor system support.
- Report files are now able to copy to other dataabses.
Bug Fixes:
- Access Violation error happened on Data Synchronization when the target connection applied HTTP Tunnel.
- Backup failed when connection applied HTTP Tunnel.
- When closed the Restore dialog after restored, Access violation occured.
- "Not enough timers available" error occured in Structure Synchronization.
- After saved the query in Query Editor, the cursor returned to the beginning of the script.
- When tables contained foreigh key, "Duplicate Table" feature would not worked for Navicat for MySQL version.
- When deleted multi-cell in Table Viewer, Navicat would hang.
Upgrade Procedure : click here to upgrade
Jul 2 2009
Navicat for MySQL (Windows) version 8.2.7 is now available
Enhancement:
- Support import/export from/to Access 2007 file.
- When using "Duplicate Connection" to create a new connection, Settings Save Path won't be copied.
Bug Fixes:
- Fixed the column width not saved in Query Result tab.
- When exporting tables with choosing "None" for Field delimiter into Text file, it now not add #0(null character) as delimiter.
Upgrade Procedure : click here to upgrade
Jun 26 2009
Navicat for MySQL (Windows) version 8.2.6 is now available
Enhancement:
- Ability to duplicate connection.
Bug Fixes:
- Fixed while changing value in table grid view given "1054 - Unknown column '' in 'field list'" error message using MySQL server version 4.0.x.
Upgrade Procedure : click here to upgrade
Jun 25 2009
Navicat for MySQL (Windows) version 8.2.5 is now available
Bug Fixes:
- Fixed access violation issue while reorganizing Join table for a saved query.
- Fixed "Duplicate Field" function in Table Designer, given "unknown column..." error message.
- Fixed access violation issue during backup process.
Upgrade Procedure : click here to upgrade
Jun 22 2009
Navicat for MySQL (Windows) version 8.2.4 is now available
Enhancement:
- Added execute time for Explain action under Message tab in Query.
Bug Fixes:
- Navicat will now end to run the routine for Profile/Status if the Query has stopped by user.
- Fixed access violation issue when deleted table in Query Builder after running the query.
Upgrade Procedure : click here to upgrade
Jun 19 2009
Navicat for MySQL (Windows) version 8.2.3 is now available
Bug Fixes:
- Fixed file association for Windows Vista and Windows 7.
- Fixed BINARY and VARBINARY displayed issue in Grid View.
- When importing dbf/excel file floating values '.' or ',' as decimal separator, Navicat will now try both in order to recognize its proper floating values.
- Fixed password prompt issue while connecting to server in Data Transfer, Data/Structure Synchronization, Console and Server monitor.
- Fixed field alias update/insert issue in Query.
Upgrade Procedure : click here to upgrade
Jun 17 2009
Navicat for MySQL (Windows) version 8.2.2 is now available
Enhancement:
- Improved stability in Query.
- Ability to stop while establishing connection to server.
- Adjusted the default Settings Save Path to "My Documents".
- Detail View (object attributes) will now being adjusted under View menu.
- Improved Stored Procedures/Functions Wizard as non-modal form.
- Adjusted the file size behavior of "Use extended insert statements" when transfering to file.
- Support Ctrl+Del shortcut to delete records.
Bug Fixes:
- Fixed SSH Tunnel: BigInteger Overflow issue.
- Fixed the crash issue while doing the seach action in Query results.
- Fixed VARBINARY and BINARY columns were exported incorrectly.
- Date became 0 while exporting to Excel.
- Fixed "show database" privilege problem - avoid to have alert box pop out when user using Navicat.
- Fixed columns missing while printing reports using schedule in command line.
- Fixed GUI font size issue in Connection form.
- Fixed parse set/enum value in Table Designer.
- Fixed password prompt for Data Transfer, Data/Structure Synchronization.
- Fixed Virtual Grouping was unable to load.
Upgrade Procedure : click here to upgrade
May 18 2009
Navicat for MySQL (Windows) version 8.1.20 is now available
Navicat new logo design has been launched.
Upgrade Procedure : click here to upgrade
May 12 2009
Navicat for MySQL (Windows) version 8.1.19 is now available
Enhancement:
- Added keyboard interactive authentication for SSH.
- Adjusted the AutoFill from picklist behavior for Grid View.
- Supported to import Visual Foxpro memo fields to tinytext/blob.
Bug Fixes:
- Fixed export excel spreadsheet with datetime was set to 0.
- Fixed Move up/Move Down issue in Table Designer.
- Fixed ampersand not show in Memo view.
- Employed the last dataset for report when multi-dataset.
- No need validate the expiry date while using SSL.
Upgrade Procedure : click here to upgrade
May 6 2009
Navicat for MySQL (Windows) version 8.1.18 is now available
Enhancement:
- Added keyboard interactive authentication for SSH.
- Adjusted the AutoFill from picklist behavior for Grid View.
Bug Fixes:
- Fixed export excel spreadsheet with datetime was set to 0.
- Fixed wrongly treat empty string as null.
- Fixed access violation when select BLOB/TEXT issue.
- Disable KeepAliveTimer before executing SQL.
Upgrade Procedure : click here to upgrade
Apr 30 2009
Navicat for MySQL (Windows) version 8.1.17 is now available
Bug Fixes:
- Fixed the save problem while pasting field from clipbosrd in Table Designer.
- Password was wrongly trimmed while using SSH connection.
Upgrade Procedure : click here to upgrade
Apr 27 2009
Navicat for MySQL (Windows) version 8.1.16 is now available
Major new features:
- Enhanced support of new MySQL server versions.
- Partitioning support for MySQL 5.1.
- Support of Show Profile and Status in Query.
- Support of multi-resultset in Query, Stored Procedure.
- Ability to attach Export Wizard/Report result files in Batch Job notification email.
- Support of SQL Preview for all object design forms.
- More table properties can be adjusted in Table design form.
- Support Preview and Explain in View Design form.
Other enhancements:
User Interface
- Object information is now shown in pane inside Navicat main form rather than pop-up modal dialog.
- Support of drag and drop files (e.g. csv, excel....) to connection tree/table pane, Import Wizard will be launched.
- Support of drag and drop SQL files to connection tree - Excute SQL Batch Wizard will be launched.
- Added confirm checkbox when delete system object (e.g. databse mysql, information schema, current user in Manage User).
- Changed to use "Delete" instead of "OK" in delete confirm dialog.
- Added "Go to setting save path" in connection tree popup menu.
- Support shortcut key(Ctrl+Q) to quick launch Query form.
- Support shortcut key(Ctrl+H) to open history log file.
Stored Procedure
- Added Stored Procedure Wizard to generate procedure template.
Connection
- Ability to copy Connection Information into Clipboard.
Import Wizard
- Improved support of Unique, Index, Foreign Key in Access/ODBC.
- Improved support of auto-increment.
Backup/Restore
- Added "Compress Backup" and "Decompress Backup".
Structure Synchronization
- More options to choose which objects to compare.
- Improved support of synchronizing auto-increment column.
Data Transfer
- More options to choose for creating table.
Navicat Release
Notes.
Upgrade Procedure : click here to upgrade
Jan 6 2009
Navicat for MySQL (Windows) version 8.0.29 is now available
Bug Fixes:
- Fixed timeout problem during the Backup run in Command Line.
- Fixed Data Transfer (without target database name) access violation in Command Line.
- Fixed system color shows in grid.
Upgrade Procedure : click
here to upgrade
Sep 18 2008
Navicat for MySQL (Windows) version 8.0.28 is now available
Bug Fixes:
- Fixed e-mail sending with authentication setting in Schedule.
- Fixed Print Database/Table issue, while printing non-english field name, table name etc.
- Fixed dbf import,while importing Float type with NULL value.
- Fixed Open Table shortcut issue.
- Fixed Command Line crash.
Upgrade Procedure : click
here to upgrade
Apr 30 2008
Navicat for MySQL (Windows) version 8.0.27 is now available
Bug Fix:
- Fixed the backup problem while establishing connection
using HTTP tunnel. (please feel save that all your
data have already been backup in your backup files.
No data are lost. If you are encountering problem
during the restore process, please provide us your
backup file.)
Navicat
Release
Notes.
Upgrade Procedure : click
here to upgrade
Apr 16 2008
Navicat for MySQL (Windows) version 8.0.26 is now available
Improvements:
- Provide better error log system for Data Synchronization.
Bug Fixes:
- Fixed "Invalid class typecast" error in
Server Monitor.
- Closed the docking windows using Alt+F4 would give
Access Violation error.
- Structure Synchronization will not synchronize field
comments.
Navicat
Release
Notes.
Upgrade Procedure : click
here to upgrade
Apr 7 2008
Navicat for MySQL (Windows) version 8.0.25 is now available
Improvements:
- The outcome from Navicat "Dump SQL File" feature
(both database and table) includes "drop table if
exists" statement.
- Ability to remember size and position for "New Query"
window.
- Set focus on Query Editor when opening a new query.
Bug Fixes:
- Fixed the backup problem which would generate error
if object name contains apostrophe(').
- No need to save the query before export to excel
file.
- Scheduled Job does not populate "from" field in
email.
- Restore window position problem.
- Export dbf with or without memo issue.
- Fixed uppercase StoredProc in Manage users.
- Overflow in Server Monitor.
- Unicode problem in StoredProc designer.
- Comment are not shown in StoredProc designer after
save.
- Fixed import dbf float/double issue.
- Fixed Import xml issue - while xml file contains
ampersands(&).
- Fixed popup position with dual monitor.
- File association problem between MYSQL and PGSQL
version.
- Fixed number of crashes from query.
Navicat
Release
Notes.
Upgrade Procedure : click
here to upgrade
Jan 28 2008
Navicat for MySQL (Windows) version 8.0.23 is now available
Major new features:
- Event Scheduler - new MySQL feature as of MySQL
5.1.
- Virtual Grouping - provides better categorization
for objects.
- Form View - enjoy a clear display of field name
and its value with focus on current record.
- Code Completion - speedup your sql writing.
- New Profile System - open profile on your desktop
directly.
- Print Report to Files - export report to pdf, html
and more.
- E-mail Notification - send notification e-mail for
schedule task.
Other enhancements:
- Compatible with any MySQL server version up to 5.1.x.
- Incremental Search and more supports in Table View.
- Usability enhancement in Table Design.
- Many other improvements on features and user-friendliness.
Navicat
Release Notes.
Upgrade Procedure : click
here to upgrade
Mar 17 2006
Navicat for MySQL (Windows) version 7.1.15 is now available
New features:
Lastest MySQL versions support:
- Compatible with any MySQL server version up to 5.0.x.
- Support of Triggers.
- VARCHAR Data Type support. Length from 0 to 65,535
in 5.0.3 and later versions.
- BIT Data Type support from MySQL 5.0.3.
Significantly improved user interface:
- Customize of connection order.
- Support of larger font in Filter Wizard.
- Auto-adjustment of row height setting.
New powerful data management tools:
- Support of Views/Stored Procedures Backup and Restore.
- Support of Views/Stored Procedures Data Transfer.
- Support of Delimiter in Query, Console and Execute Batch Job.
- Support of Views in Query Builder.
- Enhancement of Manage Users for supporting MySQL 5.x.
- Support of Views in Manage Users.
Ehancements :
- Support of importing Oracle to MySQL.
- Support of importing MS SQL to MySQL.
- Bug fixes of Timestamp creation problem.
- Bug fixes of adding a left join to existing View.
- Bug fixes of data transfer problem.
Upgrade Procedure : click
here to upgrade
Nov 9 2005
Navicat for MySQL (Windows) version 7.0.9 is now available
New features:
- Data Synchronization.
- Structure Synchronization.
- Build in SQL Console.
- View Builder.
Some features enhancements:
- Further data are shown in the tree view.
- Three colors are employed within the table grid to provide a better vision for users.
- Supports Query Parameter. For example: Select * from table_A where id = [$id].
- Provides a short-cut to terminate a running query.
- Raw mode setting allows user to view the actual data
value which stored in the MySQL database.
- Export Profile -the existing Navicat setting can
be exported into a .reg file. You can also reload the
Navicat setting from a new machine.
- Query Builder supports to create a query from different
databases which are within the same connection.
- View Builder is an easy-way to create view.
- Run Selected - Query Statments can be executed partly
in the Query Editor.
- Stored Procedure - new editor window provides an
easy-way to create stored procedure or stored function.
- Timeout reconnection - Auto-reconnection will be
made to the SQL server.
- Support Private Key feature for SSH Tunnel.
- WordWrap built for Query and View Editor.
- Supports Stored Procedure for MySQL 5.0.13 or above.
Bug Fixes:
- Closing Navicat without prompt to save changed.
- Invisibility of Foreign Key constraint settings.
- Inconsistency of importing Access file.
- Time-Consuming for creating new query with numerous
tables.
- Prevention of modifying TIMESTAMP column type.
- DBF Import error.
- Excel Export error as Text fields.
Jan 12 2005
Navicat for MySQL (Windows) version 6.1.10 is now availableMajor new features:
- Support View in MySQL 5.0
- Enhanced Import and Export Wizard
- supports to import multiple tables, primary
keys and foreign keys from Access.
- supports to import multiple spreadsheet from
Excel.
- customizable row identifier in import of XML
file.
- more options available in Exporting MySQL table.
- Support Character Set (new function in MySQL 4.1
or above)
- Enhance Docking
- Options: Detail View/List View in mainwindow
- AutoFill for enum in grid
- Change display font in Navicat
- TableHint on mouse rollover
- Help in each window
- HistoryLog of executed process in Navicat.
Jul 6 2004
Navicat 2004 for Windows version 6.0.7 is now availableThis new version includes a new feature - SSH Tunnel. For more information, please visit at
ssh_tunnel.php
.
Apr 20 2004
Navicat 2004 for Windows version 6.0 is now available Over 100 enhancements and new features:
Navicat 2004 supports to import data from ODBC, create
Batch Job Scheduling (schedule of Import/Export, Data
Transfer and saved queries) and print table structure
of their designed database. Furthermore, it now supports
MySQL 5.0 Alpha (support stored procedure).
Navicat Standalone Report Viewer will be avaliable for
Enterprise Edition (will be released in Mid-May).
Upgrade Procedure : click
here to upgrade
Dec 2 2003
Navicat for MySQL (Windows) version 5.3.12 is now available
Bug fixes on SSL connection. SSL Connection setup tutorial is now available.
Nov 10 2003
PremiumSoft Navicat (Windows) version 5.3.1 is now available
Create schedule for Import/Export is now possible in
Navicat 5.3.11.
New features:
- Execute saved queries from command line.
- Save Import or Export wizard setting in a profile.
You can execute saved profile from command line.
- Support importing multiple MS Access tables at once.
- MySQL Server v4.1 support.
- Duplicate Tables.
- Empty Tables.
- Bug Fixes on importing dbf file and Access file.
- Bug Fixes on using multiple monitors.
- Load SQL function fully supports Unicode.
- More user friendliness improvement.
Oct 1 2003
Survey for New Features: In order for us to further enhance our Navicat, please tell us your comment through [
Navicat Survey]
Sep 29 2003
PremiumSoft Navicat (Windows) version 5.3 is now available
New features:
- Execute saved queries from command line.
- Save Import or Export wizard setting in a profile.
You can execute saved profile from command line.
- Support importing multiple MS Access tables at once.
- MySQL Server v4.1 support.
- Duplicate Tables.
- Empty Tables.
- more user friendliness improvement.
Aug 20 2003
PremiumSoft Navicat (Windows) version 5.2.4 is now available
New features:
- foreign keys
- unicode support
- bugfix on displaying hidden popup windows.
- bugfix on sql editor.
- bugfix on Set Privileges.
- more useful features, minor bugfixes and performance
improvement.
Aug 5 2003
PremiumSoft Navicat (Windows) version 5.2 is now available
New features:
- Foreign Keys - support to configure Foreign Keys.
- Unicode support.
- and more useful features, minor bugfixes and performance
improvement.
Apr 6 2003
Version 5.1 of
Navicat for MySQL (Windows) and New Upgrade Procedure are released today!
New features:
- Process priority - loading table can be faster if priority is set to High.
- Improve the user-friendliness of Data Transfer feature.
- There will be numerous performance and manageability improvements.
Jan 27 2003
Navicat for MySQL (Windows) version 5.0 is released
New features:
- improve performance on multiple simultaneous jobs.
The performance of running large queries will be greatly
improved..
- support SSL.
- support custom display formats for Numeric , Date
and Time Type.
- support Mysql function in edit data.
- improve the user-friendliness.
- there will be numerous performance and manageability
improvements.
Jun 13 2002
Lastest version of
Navicat for MySQL (Windows) is released
New features:
- Import/Export Wizard
The Import and Export Wizard would help you to import/export
data. It supports up to 18 most popular formats including
MS Access, MS Excel, XML, PDF and TXT.
- Visual Query Builder
The Visual Query Builder would help you to create
SQL queries much easier.
May 21 2002
The newest version of
Navicat for MySQL (Windows) is now available
- creating Primary Key and Indexes would be much easier.
- a lot of small improvements on user friendliness.
- bugfix on Manage Users.
- some minor bugfixes.
Mar 31 2002
Navicat for MySQL (Windows), fixes of all minor bugs reported by our users since version 3.0 ...