If you have purchased our products and want to retrieve the download information of the latest version, please click here

Navicat Premium (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:

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.

Upgrade Procedure : click here to upgrade

---

Navicat Premium (Windows) version 8.2.19 is now available

Bug Fixes:

1. Restore function could not work properly.
2. Insert Field did not work in Table Designer.

Upgrade Procedure : click here to upgrade

---

Navicat Premium (Windows) version 8.2.18 is now available

Improvements:

1. If length does not specify for MySQL char/varchar, 255 value will now be assigned when saving a table.

Bug Fixes:

1. 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.
2. When altered a MySQL data type that contains unsigned/zerofill properties into BIT type, table could not be saved in Table Designer.
3. BIT type default value could not be handled properly in some MySQL server.
4. When set the DEFAULT NULL property in PostgreSQL table, Navicat used "SET DEFAULT NULL" rather than "DROP DEFAULT"
5. "1045 - Access denied" error occured when a target server was not selected during MySQL Data Transfer.
6. "1055" errod occured when running MySQL queries after the SQL mode was set into 'TRADITIONAL,ONLY_FULL_GROUP_BY,NO_AUTO_VALUE_ON_ZERO'.
7. "Append/Update" mode did not work properly in Import Wizard.
8. Sequence checkbox status and counter did not work properly in Oracle and PostgreSQL Data Transfer.
9. PostgreSQL SQL statement - "select * from table" would return result set in unexpected order, so that Data Transfer and Export functions would return incorrect result.
10. Events and Sequences could not shown under Object Selection tab in MySQL and PostgreSQL Restore form.

Upgrade Procedure : click here to upgrade

---

Navicat Premium (Windows) version 8.2.17 is now available

Improvements:

1. 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:

1. 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.
2. Refresh did not work for getting update data.
3. 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

---

Navicat Premium (Windows) version 8.2.16 is now available

Bug Fixes:

1. Primary Key were defined improperly under SQL Preview tab in PostgreSQL/Oacle Table Designer.
2. The cursor position moved to end-of-line after saved the Stored Procesure/Function.
3. "Access Violation" error occured when getting the MySQL Event information from Linux server.
4. "'x,x' is not a valid floating point value" error occured when opening an oracle table that contains floats data type together with the regional settings were set to Dutch environment.
5. Failed to establish SSH connection when the private key path contained unicode.
6. when the server name contain unicode characters, this server name was unreadable in SQL file which created using Data Transfer feature.
7. "Control 'ppParameterEditor' has no parent window" error occured when clicked on the ParametersEditor button which under Generation topic in Report Builder.
8. When a table contained some long field names, those field names were only partialy visible or even invisible in Form View.
9. 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

---

Navicat Premium (Windows) version 8.2.15 is now available

Bug Fixes:

1. "Class TSciMemo not found" error occured when opening PostgreSQL Aggregate Designer.
2. Data could not be updated/added in Table Viewer when using HTTP Tunnel connection to PostgreSQL server.
3. "Truncate Table" function did not work with multiple tables if using HTTP Tunnel connection.

Upgrade Procedure : click here to upgrade

---

Navicat Premium (Windows) version 8.2.14 is now available

Improvements:

1. "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.
2. Report Builder now accepts datetime function for MySQL server.
3. PostgreSQL "bytea" data type will now being exported as E'...' in text-base file.

Bug Fixes:

1. "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.
2. BLOB data in text file was unable to import successfully for MySQL and PostgreSQL servers.
3. SQL statements exported from Export Wizard was exported incorrectly.
4. 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.
5. "List index out of bound" error occured when using an account, which did not have enough privileges, to open MySQL Stored Procedure/Function.
6. Crashed when running "SELECT ctid FROM table" in PostgreSQL server.
7. "Access Violation" error occured when exporting data to Access file if using HTTP Tunnel connection.

Upgrade Procedure : click here to upgrade

---

Navicat Premium (Window) version 8.2.13 is now available

Improvements:

1. The Data Synchronization message log will not show server name rather than Host/IP.

Bug Fixes:

1. When applied comma as decimal seperator, Data Synchronization would cause problem for MySQL and PostgreSQL server.
2. Date field was not converted correctly when exported to DBF file.
3. An empty field would be displayed if employed EUC_JP as database encoding in PostgreSQL server.
4. Undo (Ctrl + z) function did not work properly on memo editor in Table Viewer.
5. Docked windows could not show in task bar under Windows 7.
6. Email attachment in Schedule could not be sent if "Add timestamp" option was enabled in Export Wizard.

Upgrade Procedure : click here to upgrade

---

Navicat Premium (Window) version 8.2.12 is now available

Improvements:

1. Support specify the socket name in Connection for MySQL server.
2. Improve suggestion on target data type and provide a default precision and scale information in Import Wizard.
3. Support export to clipboard.

Bug Fixes:

1. When edited an Oralce user, "ORA-00904: DROPPED: invalid identified" occured.
2. It was slow to open Table Designer for PostgreSQL server.
3. When docking a console window to main window, the wheel of mouse would be no effect.
4. Month calendar Could not fully display in some system.
5. If password did not save in Connection Properties, Dump SQL File would not work propertly.

Upgrade Procedure : click here to upgrade

---

Navicat Premium (Windows) version 8.2.11 is now available

Enhancement:

1. Support of UUID for PostgreSQL server 8.3 or above.

Bug Fixes:

1. "SSH Tunnel:''is not a valid integer value" error occured during SSH connection.
2. When exported data to MS Access, month and day values were mixed up.
3. Slow problem while transfering data from command line.
4. "permission denied for relation pg_authid" error occured when creating table for ProgreSQL server.
5. Access Violation error happened when creating new table with index.
6. Fixed SQL parsing problem for Oracle version.
7. Index, constraint and trigger could not be renamed in Table Designer.

Upgrade Procedure : click here to upgrade

---

Navicat Premium (Windows) version 8.2.9 is now available

Enhancement:

1. Improved connection alive issue for MySQL server.

Bug Fixes:

1. When ran "LOAD DATA LOCAL FILE" in Query Editor to import data to MySQL database, Access violation error occured.
2. If table names stated with number e.g. 1Table, those tables were not displayed on the Query Builder.
3. when using Find (ctrl+f) in Form View, it would jump out of Form View into Grid View.
4. When applied docking feature under Windows 7, "System Error. Code: 87. The parameter is incorrect" occured.
5. Fixed "Select" statement with empty string in Query Editor resulted in Access violation.

Upgrade Procedure : click here to upgrade

---

Navicat Premium (Windows) version 8.2.8 is now available

Enhancement:

1. Support of SSL for PostgreSQL server 8.4.
2. Improved dual monitor system support.
3. Report files are now able to copy to other dataabses.

Bug Fixes:

1. Access Violation error happened on Data Synchronization when the target connection applied HTTP Tunnel.
2. Backup failed when connection applied HTTP Tunnel.
3. When closed the Restore dialog after restored, Access violation occured.
4. User-defined schema would not show in Structure Synchronization.
5. "Not enough timers available" error occured in Structure Synchronization.
6. After saved the query in Query Editor, the cursor returned to the beginning of the script.
7. "Keepalive Interval" did not work for PostgreSQL version.
8. Database/Schema privileges could not be edited for PostgreSQL server.
9. Modified existing Operator Class did not work properly for PostgreSQL server 8.4.
10. Structure Synchronization did not work properly for PostgreSQL server 7.4.
11. When tables contained foreigh key, "Duplicate Table" feature would not worked for Navicat for MySQL version.
12. When deleted multi-cell in Table Viewer, Navicat would hang.

Upgrade Procedure : click here to upgrade

---

Navicat Premium (Windows) version 8.2.7 is now available

Enhancement:

1. Support import/export from/to Access 2007 file.
2. When using "Duplicate Connection" to create a new connection, Settings Save Path won't be copied.

Bug Fixes:

1. Fixed while getting wrong Oracle sequence info during the Data Transfer process.
2. Fixed the column width not saved in Query Result tab.
3. When exporting tables with choosing "None" for Field delimiter into Text file, it now not add #0(null character) as delimiter.
4. Modified the default query limit to 100 for PostgreSQL server to avoid Out of Memory error during the Backup, Data Transfer and Export process.
5. SSH connection did not work properly.
6. Last Character would be chopped when exported data using Export Wizard.

Upgrade Procedure : click here to upgrade

---

Navicat Premium (Windows) version 8.2.6 is now available

Enhancement:

1. Ability to duplicate connection.

Bug Fixes:

1. 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

---

Navicat Premium (Windows) version 8.2.5 is now available

Bug Fixes:

1. Fixed access violation issue while reorganizing Join table for a saved query.
2. Fixed "Duplicate Field" function in Table Designer, given "unknown column..." error message.
3. BFile/CFile not being handled.
4. Fixed access violation issue during backup process.
5. Fixed altering the inheritance table, given "syntax error at or near "INHERITS" at..." error message for Navicat PostgreSQL version.

Upgrade Procedure : click here to upgrade

---

Navicat Premium (Windows) version 8.2.4 is now available

Main features:

Multi-connections Database Administration tool:

Navicat Premium allows you to perform multiple server administration to MySQL, Oracle and PostgreSQL databases from a single interface. It supports most of the features in MySQL, Oracle and PostgreSQL including:

Latest MySQL versions support

1. Compatible with any MySQL server version.
2. Support all MySQL objects: tables, views, stored procedures/functions and events.
3. Support all subobjects: fields, indices, foreign keys and triggers.
4. Support of partitioning.
5. Support of Unicode / Character Set.

Latest Oracle versions support

1. Support Oracle version 8.1, 9i, 10g and 11g.
2. Support all Oracle objects: tables (Normal, External and Index Organized), views, procedures/functions.
3. Support all subobjects: fields, indices, foreign keys, uniques, checks and triggers.
4. Managing directories, tablespaces, public database links and public synonyms.
5. Managing database links, indices, java, materialized views, materialized view logs, packages, sequences, synonyms, triggers, types, XML Schema and Recycle Bin.
6. Support of physical attributes.
7. Support of Unicode/Character Set.

Latest PostgreSQL versions support

1. Support PostgreSQL Server version 7.3 to 8.3.
2. Support all PostgreSQL objects: tables, views and functions.
3. Support all subobjects: fields, indices, foreign keys, uniques, checks, rules and triggers.
4. Managing tablespace, cast and languages.
5. Managing aggregates, conversions, domains, trigger functions, operators and classes, sequences and types.
6. Support of character set and Unicode.

Cross-servers Data Manipulation Tools

1. Support of transferring data across various database systems.
2. Ability to transfer data to a text file with designated SQL format.
3. Setting schedule for profiles from different kind of databases.
4. Support of sending notification e-mail and attachment for schedule task.

Connection options

1. Support of password and public/private key for SSH Tunnel.
2. Support of HTTP Tunnel for MySQL and PostgreSQL Servers.
3. Support of Oracle Basic and TNS Connection.
4. Export Registry Record(.reg) via Navicat Premium.

Well-designed user interface

1. Virtual Grouping for connections and objects.
2. Customize of connection order.
3. Data are well-shown in the tree view.
4. Grid View and Form View support.
5. Well-described Wizard System.
6. Support docking windows.

Powerful data management tool

1. Foreign Key Data Selection.
2. Supports Parameter Query.
3. Import and Export support.
4. Data Synchronization support.
5. Structure Synchronization support.
6. Support of Backup and Restore for MySQL and PostgreSQL Servers.
7. Build in MySQL and PostgreSQL Console and Oracle SQL*Plus.
8. dBaseIII memo support in DBF Import Wizard.

Visual Designer

1. Support Code-Completion in SQL editors.
2. Support Views in Query Builder.
3. Support of Views Builder.
4. Support SQL Previewer.

Additional features

1. Print Schema / Table Structure
2. Support of setting global Row Height and Column Width in table grid.
3. Support of Word Wrap.
4. Provides a short-cut to terminate a running query.
5. Manage Users.
6. Server Monitor.

Download here

---

 

If you have purchased our products and want to retrieve the download information of the latest version, please click here

Navicat Premium (Mac) version 8.1.9 is now available

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.

Upgrade Procedure : click here to upgrade

---

Navicat Premium (Mac) version 8.1.8 is now available

Bug Fixes:

1. Connections were not freed before quitting Navicat.
2. Failed to establish MySQL SSL connection.
3. Form View would crash when editing with no row selected.
4. Timestamp field properties text box was not shown in Oracle Table Designer.
5. Data were uneditable in Oracle Form View.
6. Improper Ctrl-click menu would be displayed in Table Viewer.
7. Wrong linkage was shown for field name with capital letters in Query Builder.

Upgrade Procedure : click here to upgrade

---

Navicat Premium (Mac) version 8.1.7 is now available

Improvements:

1. MySQL Triggers will now include in Dump SQL file.
2. Improved the internal code to avoid some crash that would occur.

Bug Fixes:

1. Error would occur when importing date with 2 digit with "Four Digit Years" checked in Import wizard.
2. Failed to list MySQL Views in Manage User window.
3. MySQL Table Viewer would crash after added a row without changing its value.
4. Crashed when saving views with name in capital letter on MySQL server with lower_case_table_names variable not equal to 0.
5. MySQL syntax error occurred when creating tables with foreign key in Table Designer.
6. Failed to connect to PostgreSQL server on "localhost" but without socket file.

Upgrade Procedure : click here to upgrade

---

Navicat Premium (Mac) version 8.1.6 is now available

Bug Fixes:

1. Failed to change the definition of an existing MySQL Foreign Key in Table Designer.
2. The SQL statement to create foreign key mistakenly included the name of source database in MySQL Structure Synchronization.
3. When launched Oracle Console, Terminal window would popup twice.
4. Some data would be truncated when getting data from Oracle server.
5. When created PostgreSQL database, privileges could not be set at the same time.
6. Data Transfer, Data Synchronization and Structure Synchronization Profiles selection box would display improperly if Toolbar Appearance was set as "Text Only".
7. Navicat Import Wizard was unable to recognize some xml attributes properly.
8. When modified Index in Table Designer, Some changes could not be recognized.
9. Failed to display the referencing table list when editing existing Foreign Key in Table Designer.
10. The first record could not be selected in Table Form View under Mac OS 10.6.
11. Navicat crashed if the network drive could not be found during the Backup process.

Upgrade Procedure : click here to upgrade

---

Navicat Premium (Mac) version 8.1.5 is now available

Improvements:

1. Improved compatibility to some ODBC drivers for Import Wizard.

Bug Fixes:

1. Incorrect use of hexadecimal format in MySQL data types other than BLOB in Data Transfer.
2. Data grid was unable to be opened properly when some kind of text were displayed.
3. Removed some internal SQL run by Navicat in Query Viewer.
4. Unable to change the default value of an existing field from NULL to other values in Table Designer.

Upgrade Procedure : click here to upgrade

---

Navicat Premium (Mac OS X) version 8.1.4 is now available

Improvements:

1. Export Wizard is now able to export data filering result.
2. Text fields are now imported with text data instead of hex to prevent potential encoding problems which may occur for MySQL server.

Bug Fixes:

1. Foreign Key Data Selection window was unable to show Text field data, it showed [TEXT] instead.
2. When set Foreign Keys in MySQL Table Designer, foreign key info could not be displayed properly if the Reference Database field included dot character.
3. Crashed when saving changes to PostgreSQL Triiger Function.
4. SQL*Plus was unable to activate if the paths under Environments tab in Preferences contained spaces.
5. When set criteria using BETWEEN keyword in Filter Wizard, error message would occur.
6. Crashed when running sql in MySQL 4.1.14.

Upgrade Procedure : click here to upgrade

---

Navicat Premium (Mac OS X) version 8.1.3 is now available

Improvements:

1. Compatible with Mac OS X Snow Leopard.
2. Stability improvement on tabbed window.

Bug Fixes:

1. Indexes could not work if user is not superuser.
2. Import Wizard would be launched if the Data format was not properly set.

Upgrade Procedure : click here to upgrade

---

Navicat Premium (Mac OS X) version 8.1.2 is now available

Improvements:

1. Support quitting the Console window by "exit", "quit" or "\q" command for MySQL server.
2. Support quitting the Console window by "\q" command for PostgreSQL server
3. Improved the stability when running a query.
4. Now owners of objects are not compared or transferred in Structure Synchronization and Data Transfer for PostgreSQL server.
5. Improved an internal SQL which run slowly in PostgreSQL server.

Bug Fixes:

1. Some windows size and position were not saved after closed.
2. Recalling multi-line history commands in Console were not displayed properly in MySQL and PostgreSQL server.
3. "Copy to Clipboard" did not show host name for MySQL and PostgreSQL server.
4. Dump SQL File did not dump the primary key definition for PostgreSQL server.
5. Could not recognize the host by host name for PostgreSQL server.
6. User defined type fields were not showing the type properly in Table Design (for PostgreSQL server only).

Upgrade Procedure : click here to upgrade

---

Navicat Premium (Mac OS X) version 8.1.1 is now available

Enhancement:

1. Support of PostgreSQL server version 8.4.
2. Support choosing server version for SQL to be generated in Data Transfer, support more transfer options.
3. Added connection tree to support batch jobs from different databases.
4. Compatibility and speed improvement in exported excel format.
5. Notification email in batch job is now delivered in MIME format.
6. Allow setting fonts in Data Grid, and apply Editor Font to View/Edit Text.
7. Support Profile and Status in Query View for MySQL server.
8. Added DateTime picker in Table View for Oracle server.

Bug Fixes:

1. Navicat could not quit normally in some senarios.
2. View Builder did not display properly.
3. Slow problem when opening Query View.
4. Improper ordering of the generated SQL during Structure Synchronization.
5. Field lengths are not synchronized correctly for PostgreSQL server.

Upgrade Procedure : click here to upgrade

---

Navicat Premium (Mac OS X) version 8.1.0 is now available

Main features:

Multi-connections Database Administration tool:

Navicat Premium allows you to perform multiple server administration to MySQL, Oracle and PostgreSQL databases from a single interface. It supports most of the features in MySQL, Oracle and PostgreSQL including:

Latest MySQL versions support

1. Compatible with any MySQL server version.
2. Support all MySQL objects: tables, views, stored procedures/functions and events.
3. Support all subobjects: fields, indices, foreign keys and triggers.
4. Support of partitioning.
5. Support of Unicode / Character Set.

Latest Oracle versions support

1. Support Oracle version 8.1, 9i, 10g and 11g.
2. Support all Oracle objects: tables (Normal, External and Index Organized), views, procedures/functions.
3. Support all subobjects: fields, indices, foreign keys, uniques, checks and triggers.
4. Managing directories, tablespaces, public database links and public synonyms.
5. Managing database links, indices, java, materialized views, materialized view logs, packages, sequences, synonyms, triggers, types, XML Schema and Recycle Bin.
6. Support of physical attributes.
7. Support of Unicode/Character Set.

Latest PostgreSQL versions support

1. Support PostgreSQL Server version 7.3 to 8.3.
2. Support all PostgreSQL objects: tables, views and functions.
3. Support all subobjects: fields, indices, foreign keys, uniques, checks, rules and triggers.
4. Managing tablespace, cast and languages.
5. Managing aggregates, conversions, domains, trigger functions, operators and classes, sequences and types.
6. Support of character set and Unicode.

Cross-servers Data Manipulation Tools

1. Support of transferring data across various database systems.
2. Ability to transfer data to a text file with designated SQL format.
3. Setting schedule for profiles from different kind of databases.
4. Support of sending notification e-mail and attachment for schedule task.

Connection options

1. Support of password and public/private key for SSH Tunnel.
2. Support of HTTP Tunnel for MySQL and PostgreSQL Servers.
3. Support of Oracle Basic and TNS Connection.
4. Export Registry Record(.reg) via Navicat Premium.

Well-designed user interface

1. Virtual Grouping for connections and objects.
2. Customize of connection order.
3. Data are well-shown in the tree view.
4. Grid View and Form View support.
5. Well-described Wizard System.
6. Support docking windows.

Powerful data management tool

1. Foreign Key Data Selection.
2. Supports Parameter Query.
3. Import and Export support.
4. Data Synchronization support.
5. Structure Synchronization support.
6. Support of Backup and Restore for MySQL and PostgreSQL Servers.
7. Build in MySQL and PostgreSQL Console and Oracle SQL*Plus.

Visual Designer

1. Support Code-Completion in SQL editors.
2. Support Views in Query Builder.
3. Support of Views Builder.
4. Support SQL Previewer.

Additional features

1. Print Schema / Table Structure
2. Support of setting global Row Height and Column Width in table grid.
3. Manage Users.
4. Server Monitor.

Download here

---

 

If you have purchased our products and want to retrieve the download information of the latest version, please click here

Navicat Premium (Linux) 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:

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.

Upgrade Procedure : click here to upgrade

---

Navicat Premium (Linux) version 8.2.19 is now available

Bug Fixes:

1. Restore function could not work properly.
2. Insert Field did not work in Table Designer.

Upgrade Procedure : click here to upgrade

---

Navicat Premium (Linux) version 8.2.18 is now available

Improvements:

1. If length does not specify for MySQL char/varchar, 255 value will now be assigned when saving a table.

Bug Fixes:

1. Connection Name in Connection Properties sometime would show empty value.
2. 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.
3. When altered a MySQL data type that contains unsigned/zerofill properties into BIT type, table could not be saved in Table Designer.
4. BIT type default value could not be handled properly in some MySQL server.
5. When set the DEFAULT NULL property in PostgreSQL table, Navicat used "SET DEFAULT NULL" rather than "DROP DEFAULT"
6. "1045 - Access denied" error occured when a target server was not selected during MySQL Data Transfer.
7. "1055" errod occured when running MySQL queries after the SQL mode was set into 'TRADITIONAL,ONLY_FULL_GROUP_BY,NO_AUTO_VALUE_ON_ZERO'.
8. "Append/Update" mode did not work properly in Import Wizard.
9. Sequence checkbox status and counter did not work properly in Oracle and PostgreSQL Data Transfer.
10. PostgreSQL SQL statement - "select * from table" would return result set in unexpected order, so that Data Transfer and Export functions would return incorrect result.
11. Events and Sequences could not shown under Object Selection tab in MySQL and PostgreSQL Restore form.

Upgrade Procedure : click here to upgrade

---

Navicat Premium (Linux) version 8.2.17 is now available

Improvements:

1. 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:

1. When a schedule is set by a root user, other user which did not contain privileges enough would be unable to modified that schedule profile.
2. 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.
3. Refresh did not work for getting update data.
4. 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

---

Navicat Premium (Linux) version 8.2.16 is now available

Bug Fixes:

1. Primary Key were defined improperly under SQL Preview tab in PostgreSQL/Oacle Table Designer.
2. The cursor position moved to end-of-line after saved the Stored Procesure/Function.
3. "Access Violation" error occured when getting the MySQL Event information from Linux server.
4. "'x,x' is not a valid floating point value" error occured when opening an oracle table that contains floats data type together with the regional settings were set to Dutch environment.
5. Failed to establish SSH connection when the private key path contained unicode.
6. when the server name contain unicode characters, this server name was unreadable in SQL file which created using Data Transfer feature.
7. "Control 'ppParameterEditor' has no parent window" error occured when clicked on the ParametersEditor button which under Generation topic in Report Builder.
8. When a table contained some long field names, those field names were only partialy visible or even invisible in Form View.
9. 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

---

Navicat Premium (Linux) version 8.2.15 is now available

Bug Fixes:

1. "Class TSciMemo not found" error occured when opening PostgreSQL Aggregate Designer.
2. Data could not be updated/added in Table Viewer when using HTTP Tunnel connection to PostgreSQL server.
3. "Truncate Table" function did not work with multiple tables if using HTTP Tunnel connection.

Upgrade Procedure : click here to upgrade

---

Navicat Premium (Linux) version 8.2.14 is now available

Improvements:

1. "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.
2. PostgreSQL "bytea" data type will now being exported as E'...' in text-base file.

Bug Fixes:

1. "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.
2. BLOB data in text file was unable to import successfully for MySQL and PostgreSQLservers.
3. SQL statements exported from Export Wizard was exported incorrectly.
4. 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.
5. "List index out of bound" error occured when using an account, which did not have enough privileges, to open MySQL Stored Procedure/Function.
6. Crashed when running "SELECT ctid FROM table" in PostgreSQL server.
7. "Access Violation" error occured when exporting data to Access file if using HTTP Tunnel connection.

Upgrade Procedure : click here to upgrade

---

Navicat Premium (Linux) version 8.2.13 is now available

Improvements:

1. The Data Synchronization message log will not show server name rather than Host/IP.

Bug Fixes:

1. When applied comma as decimal seperator, Data Synchronization would cause problem for MySQL and PostgreSQL server.
2. Date field was not converted correctly when exported to DBF file.
3. An empty field would be displayed if employed EUC_JP as database encoding in PostgreSQL server.
4. Undo (Ctrl + z) function did not work properly on memo editor in Table Viewer.
5. Email attachment in Schedule could not be sent if "Add timestamp" option was enabled in Export Wizard.

Upgrade Procedure : click here to upgrade

---

Navicat Premium (Linux) version 8.2.12 is now available

Latest MySQL versions support

1. Compatible with any MySQL server version.
2. Support all MySQL objects: tables, views, stored procedures/functions and events.
3. Support all subobjects: fields, indices, foreign keys and triggers.
4. Support of partitioning.
5. Support of Unicode / Character Set.

Latest Oracle versions support:

1. Support Oracle version 8.1, 9i, 10g and 11g.
2. Support all Oracle objects: tables (Normal, External and Index Organized), views, procedures/functions.
3. Support all subobjects: fields, indices, foreign keys, uniques, checks and triggers.
4. Managing directories, tablespaces, public database links and public synonyms.
5. Managing database links, indices, java, materialized views, materialized view logs, packages, sequences, synonyms, triggers, types, XML Schema and Recycle Bin.
6. Support of physical attributes.
7. Support of Unicode/Character Set.

Latest PostgreSQL versions support:

1. Support PostgreSQL Server version 7.3 to 8.3.
2. Support all PostgreSQL objects: tables, views and functions.
3. Support all subobjects: fields, indices, foreign keys, uniques, checks, rules and triggers.
4. Managing tablespace, cast and languages.
5. Managing aggregates, conversions, domains, trigger functions, operators and classes, sequences and types.
6. Support of character set and Unicode.

Connection options:

1. Support of password and public/private key for SSH Tunnel.
2. Support of HTTP Tunnel for MySQL and PostgreSQL Servers.
3. Support SSL secure connection for PostgreSQL 8.4 above.

Well-designed user interface:

1. Grid View and Form View support.
2. Virtual Grouping for connections and objects.

Powerful Data Manipulation Tools:

1. Import and Export tool.
2. Data Transfer tool.
3. Data and Structure synchronization.
4. Backup and Restore.
5. Ability to set schedule on backup, query execution, import/export, data transfer and data synchronization.
6. Ability to attach Export Wizard/Report result files in Batch Job notification email.

SQL Processing:

1. Visual query/view builder to facilitate the process of building complicated queries.
2. Ability to create parameter queries.
3. Multiple SQL editors with syntax highlighted feature.
4. Code completion for SQL editors.
5. Ability to preview SQL before execution.
6. Support to return multi-resultsets.

Upgrade Procedure : click here to upgrade

---