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

Feb 25 2014
Navicat Premium (Windows) version 11.0.17 is now available

Improvements:

  1. MySQL Table Viewer is now able to update a row even not all the keys are input for numeric columns.
  2. Always import as NULL value if "Use empty string as NULL" option is checked in Import Wizard.
  3. All records are now able to show under the Fixed Width window in step 3 of Import Wizard.

Bug Fixes:

  1. 'Control 'Dock2Form_1' has no parent window' error occured while docking in and out of windows.
  2. Connection was deleted after renamed to capitalized name.
  3. Foreign key information with two words identifier not able to get correct correctly in MySQL/MariaDB Table Designer.
  4. Foreign key information with NDB cluster storage engine not able to get correctly in MySQL Table Designer.
  5. Parameter list not able to show in MySQL/MariaDB Function Designer when there was CHARACTER type in function parameters.
  6. datetime2 value with fractional seconds not able to import using SQL Server Import Wizard.
  7. Binary Data Encoding option was ignored in Oracle/SQL Server Import Wizard if string data type existed.
  8. 'Table does not exist' error occured while opening an export profile.
  9. DateTime with fractional precision not handling correctly in SQL Server Export Wizard.
  10. Server with unsaved password not able to connect under 'Import from Database' in Data Modeling Tool.

To upgrade, please visit our Customer Center.


Jan 9 2014
Navicat Premium (Windows) version 11.0.16 is now available

Improvements:

  1. Added Dynamic Column Editor for MariaDB in Table Viewer.

Bug Fixes:

  1. Lose focus in Table Viewer.
  2. Function parser error.
  3. Access Violation error occurred when designing MariaDB tables with foreign keys.
  4. Access Violation error occurred when importing invalid connections.
  5. ERegistry Exception error occurred when starting Navicat.
  6. Oracle reconnection problem.
  7. Wrong Date Editor frame size in Table Viewer.
  8. Stack Overflow error when running Query.
  9. Data Synchronization failed when MySQL or MariaDB table has multi-fields Primary Key.
  10. Permissions issue of the Updater.
  11. Cursor was missing in Stored Procedure.
  12. Failed to create MySQL user with special characters password.

To upgrade, please visit our Customer Center.


Nov 13 2013
Navicat Premium (Windows) version 11.0.12 is now available

Bug Fixes:

  1. Wrong handling on MySQL Integer type.
  2. Changed MySQL properties not check properly in Table Designer.

To upgrade, please visit our Customer Center.


Nov 8 2013
Navicat Premium (Windows) version 11.0.11 is now available

Improvements:

  1. Support of MariaDB 5.1 or above.

Bug Fixes:

  1. Missed to mark quotation on keywords in Query Builder.
  2. Process was unable to stop while running query in Essentials version.
  3. Failed to include auto increment column setting for floating point data types in MySQL.
  4. Access Violation occured when executing MySQL query clause with 'GROUP BY _xxx, _yyy'.
  5. Failed to get the accurate fraction part of date time data for SQL Server.

To upgrade, please visit our Customer Center.


Sep 10 2013
Navicat Premium (Windows) version 11.0.10 is now available

Bug Fixes:

  1. Failed to show definition/DDL for MySQL View.
  2. Failed to check/uncheck column fields in Show/Hide Columns using space key in Tabler Viewer.
  3. Failed to scroll horizontally for wide content after applying Filter Wizard in Table Viewer.
  4. Fixed Oracle explain plan for SYSDBA user.
  5. Fixed some issues on Query and Export features under Oracle level.
  6. Failed to identify the correct installed SQL Server Native Client version.

To upgrade, please visit our Customer Center.


Aug 7 2013
Navicat Premium (Windows) version 11.0.9 is now available

Bug Fixes:

  1. Failed to save/load blob data in SQLite Table Viewer.
  2. Access violation occured in 64-bit scintilla (Text Editor) after Navicat used huge memory (>4G).
  3. Access violation occured while copying and pasting field in Table Designer.
  4. No respond from Filter Wizard in Table Viewer after execution error of filter query.
  5. Failed to replace text with an empty string using the Find and Replace feature.
  6. Fixed the scrolling issue in docking window on secondary display.
  7. Failed to display unicode user name and organization in Navicat About box.

To upgrade, please visit our Customer Center.


Jul 3 2013
Navicat Premium (Windows) version 11.0.8 is now available

Bug Fixes:

  1. Fixed SQL Server timeout reconnect issue.
  2. SQL Server PRINT message was not showed.
  3. Column width not able to be reset after showing the hidden column in Table Viewer.
  4. Access violation occured in Table Viewer while reconnecting SSH connection with another port.
  5. MySQL default value could not be kept longer than 255 characters in Table Designer.
  6. Query message in status bar not updated if no result return after Run.
  7. Fixed concat string (with date) in MySQL Query.
  8. Access violation occured when entering MySQL query clause with 'GROUP BY _xxx, _yyy'.
  9. Minimum or Maximum value not saved in PostgreSQL Sequence Designer.
  10. Fixed issues on cross transfer.
  11. Certain SQL Server function not copies over in a Data Transfer profile.
  12. Synchronize to database in Data Modeling Tool generated SQL Server column SQL with multiple identity columns.

To upgrade, please visit our Customer Center.


May 27 2013
Navicat Premium (Windows) version 11.0.7 is now available

Bug Fixes:

  1. Key was rejected for SSH connection.
  2. Crashed occured while establishing PostgreSQL connection with SSL.
  3. Access violation occured while running report in command line.
  4. Losing searched position in Memo editor after first searching or clicked into the Memo editor.
  5. Fixed query parser error.
  6. Invalid relation cardinality not showed in red color in Data Modeling Tool.

To upgrade, please visit our Customer Center.


May 9 2013
Navicat Premium (Windows) version 11.0.6 is now available

Bug Fixes:

  1. Fixed "Keyboard Interactive Failed" error for SSH tunnel connection.
  2. Crashed while using SSH tunnel connection for both source and target servers in Data Transfer.
  3. "Access violation" error occurred while entering query clause with 'ORDER BY _xxx ASC/DESC' in Query.
  4. Notification email not sent with an unsaved batch job.
  5. SQLite query result table not able to update while having zero and padding integer.

To upgrade, please visit our Customer Center.


Apr 30 2013
Navicat Premium (Windows) version 11.0.5 is now available

Major New Features:

Native 64-bit version

Interface

  1. New User Interface
  2. Aero Snap with new docking system

Connection

  1. New SSH Manager
  2. Connection Tree Filter

Table Viewer

  1. Find and Replace data
  2. Box Selection
  3. Multi-Cell Editing
  4. Search Columns
  5. Web Viewer
  6. Memo Editor with syntax highlight
  7. Support Transaction
  8. Support animated gif in Image viewer
  9. Copy data as INSERT/UPDATE statement

Table Designer

  1. Search Columns
  2. Field Type Prediction

Query

  1. Enhanced Query Builder

Import Wizard/Export Wizard

  1. JSON file
  2. CSV file
  3. Improved binary data handling

Backup/Restore

  1. SQL Server Backup
  2. Oracle Data Pump

Report

  1. Enhanced PDF printing

Others

  1. New Registration and Activation System
  2. New Updater

To upgrade, please visit our Customer Center.


Feb 4 2013
Navicat Premium (Windows) version 10.1.8 is now available

Bug Fixes:

  1. Transaction did not work properly in Table Designer while using SQLite HTTP Connection.
  2. Table Viewer could not allow to edit while using SQLite HTTP Connection.
  3. "Access violation" error occurred while applying an existing table name on a new table in Data Modeling Tool.
  4. The current value of PostgreSQL Sequence object was unable to synchronize properly and returned incorrect nextval value in Structure Synchronization.

To upgrade, please visit our Customer Center.


Dec 11 2012
Navicat Premium (Windows) version 10.1.7 is now available

Improvements:

  1. Support fractional seconds precision of time, datetime, timestamp data types for MySQL 5.6.4/MySQL MariaDB 5.3 or above.
  2. Allow max SQL Server datatype (varchar, nvarchar, varbinary) in Data Synchronization.
  3. The Profile tab under MySQL Query is now displayed without sorting.
  4. Support MySQL date time format 2012-12-31T01:02:03.456 in Import Wizard.
  5. Support fractional seconds precision of time, datetime, timestamp data types for MySQL 5.6.4 or above under Synchronize to Database function in Data Modeling Tool.
  6. Support to ignore comparing MySQL DEFINER clause of view, event, trigger, procedure and function in Structure Synchronization.

Bug Fixes:

  1. MySQL Create function statement which was after DELIMITER change statement was unable to be executed in Query.
  2. "List index out of bounds" error occurred when some source fields were removed after import profile were created during Import Wizard.
  3. Synchronize to Database function in Data Modeling Tool genarated incorrect comparison result for equivalent source and target foreign keys.
  4. Synchronize to Database function in Data Modeling Tool failed to synchronize SQLite tables with changed fields.
  5. Dump SQL File function produced inorrect SQL for Oracle CLOB fields.
  6. When "Run multiple queries in each execution" option is checked for SQL Server, character data was unable to import correctly in Import Wizard.
  7. Binary data (from MySQL, PostgreSQL, SQLite Server) from Access/ODBC was imported incorrectly during Import Wizard.
  8. Records were unable to generate for MySQL Federated table in Dump SQL File and Data Transfer.

To upgrade, please visit our Customer Center.


Sep 19 2012
Navicat Premium (Windows) version 10.1.6 is now available

Improvements:

  1. Added data format options for XML file in Export Wizard.

Bug Fixes:

  1. Error message occurred while creating databases/tablespaces in PostgreSQL 9.2.x.
  2. The dump of an Oracle table with CLOB produced an incorrect SQL statement.
  3. SQLite Table Designer was unable to handle NOT NULL ON CONFLICT field property.
  4. Wrong time unit (ms) was shown under Messages tab in Query function.
  5. Table Designer in Data Modeling Tool was unable to save newly added index and foreign key.
  6. Synchronize to Database function in Data Modeling Tool was unable to generate the referencing table schema name in the SQL scripts.
  7. Server Monitor was unable to show the process for PostgreSQL 9.2.x server.

To upgrade, please visit our Customer Center.


Aug 23 2012
Navicat Premium (Windows) version 10.1.5 is now available

Bug Fixes:

  1. "Execute SQL File" was unable to parse a SQL Server query if 'GO' characters contained in a word.
  2. Empty named MySQL relation was unable to load back in Data Modeling Tool.
  3. Unable to generate sync queries for MySQL fields with auto increment and primary key in Data Modeling Tool.
  4. "Synchronize to Database" function in Data Modeling Tool was unable to generate SQL Server SCHEMA property in comment SQL.
  5. "Access violation" error occurred while opening "Import from Database" form in Data Modeling Tool.

To upgrade, please visit our Customer Center.


Jul 27 2012
Navicat Premium (Windows) version 10.1.3 is now available

Bug Fixes:

  1. Minimized docked window could not restore normally.

To upgrade, please visit our Customer Center.


Jul 19 2012
Navicat Premium (Windows) version 10.1.2 is now available

Improvements:

  1. Added font selection in Option for ER Diagram.

Bug Fixes:

  1. 1064 error occured when running MySQL Store Procedure.

To upgrade, please visit our Customer Center.


Jul 6 2012
Navicat Premium (Windows) version 10.1.1 is now available

Bug Fixes:

  1. If the table contained many columns, new column would be inserted to wrong position in Table Designer (Data Modeling Tool).
  2. Error occured in Oracle, SQLite and SQL Server Filter Wizard when the filter criteria contain '.
  3. SQL Server Stored Procedure only showed the final message after multiple PRINT statements.
  4. Empty string was identified as Null in SQLite.
  5. 'GRANT CREATE ....' not being run in Oracle Query.

To upgrade, please visit our Customer Center.


Jun 15 2012
Navicat Premium (Windows) version 10.1.0 is now available

Improvements on Data Modeling Tool:

  1. Support Unsigned for MySQL Numeric Type.
  2. Support Auto Increment for MySQL Integer Type.
  3. Build model with multiple schemas.
  4. New wizard "Import from Database".
  5. New wizard "Synchronize to Database".
  6. Search filter.
  7. Align/Distribute diagram objects.

To upgrade, please visit our Customer Center.


Mar 28 2012
Navicat Premium (Windows) version 10.0.11 is now available

Bug Fixes:

  1. Data truncated when exporting pdf file from Report Builder.
  2. Navicat got hanged while performing a search in Table Viewer.
  3. Incorrect excel file format was exported while having data started with 0 in Export Wizard.
  4. Copy and paste was not working on index in MySQL/PostgreSQL Table Designer.
  5. "80070001: PrectServer2 not connected" error occurred while transfering Oracle data to file.
  6. Execute SQL File function would not run if there was a SQL Server identifier contains "GO" characters.
  7. SQL Server "double" data type was not being handled properly in Export Wizard.
  8. Auto-increment info was missing while preforming cross data transfer.

To upgrade, please visit our Customer Center.


Jan 31 2012
Navicat Premium (Windows) version 10.0.10 is now available

Improvement:

  1. Support editing Money type for SQL Server 2000.
  2. Import speed has been improved in Import Wizard.
  3. Export speed has been improved in Export Wizard.

Bug Fixes:

  1. 'column d.datpath does not exist' error occurred while Navicat connecting to PostgreSQL server.
  2. Navicat generated 'Not Implemented' error when running under replacement shell UI.

To upgrade, please visit our Customer Center.


Jan 4 2012
Navicat Premium (Windows) version 10.0.9 is now available

Bug Fixes:

  1. While scrolling MySQL index fields, the scrolled position could not be reflected in Table Designer.
  2. MySQL Table Designer generated incorrect SQL statement in field ordering.
  3. The comparison in MySQL columns ordering were generated incorrectly in Structure Synchronization, and Synchronize to Database in Modeler.
  4. Extra SET FOREIGN_KEY_CHECKS MySQL queries were generated even if the comparison results were identical in Structure Synchronization.
  5. Collation in Database Properties not able to set since wrong SQL generation.
  6. Not able to open schema for databases with non-default database collation in SQL Server 2000.
  7. Oracle long Number could not shown in Table Designer.
  8. Synchronize to Database in Modeler generated redundant TYPE clause (PostgreSQL) while comparing a new column.
  9. Synchronize to Database in Modeler did not generate SQLite index SQL properly.
  10. Crash occurred when closing Synchronize to Database in Modeler during the comparison in progress.
  11. Crash occurred while renaming table failed with server error in ER-diagram view.
  12. Data Transfer would hang in Navicat Scheduler.

To upgrade, please visit our Customer Center.


Nov 24 2011
Navicat Premium (Windows) version 10.0.8 is now available

Improvement:

  1. Enhanced MySQL Model transformation.

Bug Fixes:

  1. "Access violation" error occurred when dragging n dropping a server node in connection tree together with the Model/Schedule object pane were opened.
  2. When created a virtual group in the connection tree, it would be added under Model/Schedule object pane while they were opened.
  3. Failed to execute a SQL Server Stored function with some field types.
  4. "Maintain"->"Vacuum Database..." for PostgewSQL and SQLite server would randomly not shown in the connection tree.

To upgrade, please visit our Customer Center.


Nov 14 2011
Navicat Premium (Windows) version 10.0.7 is now available

Improvement:

  1. Source field order is now kept in target table after running "Synchronize to Database" for MySQL server.
  2. SQLite Columns with undefined data type is now able to be searched in "Find in Database" feature.

Bug Fixes:

  1. Incorrect field type showed in ER Diagram.
  2. Fixed-width and row delimiter were unable to retrieve from a profile in Import Wizard.
  3. Structure Synchronization produced invalid pointer exception error when comparing SQL Server stored procedures.
  4. Non-latin characters with different collation columns in MySQL table were unable to search in "Find in Database" feature.
  5. Print report to PDF file would generate a blank file.

To upgrade, please visit our Customer Center.


Oct 17 2011
Navicat Premium (Windows) version 10.0.6 is now available

Improvement:

  1. Support column comment up to 1024 characters for MySQL 5.5.3.
  2. Support table comment up to 2048 characters for MySQL 5.5.3.

Bug Fixes:

  1. Data Modeling Tool was unable to set the reference field of foreign key.
  2. Data Modeling Tool was unable to print with landscape page setting.
  3. When importing data from an URL, it failed to create a temporary file if the same temporary file was being accessed.
  4. Tables contained MySQL geometric point data was failed in Data Transfer and Data Synchronization.
  5. Restore didn't work with the .pmb file created from Navicat for MySQL version 5.
  6. Failed to implement PostgreSQL LIKE query with date time columns in "Find in Database" function.
  7. Failed to implement PostgreSQL 'name' type columns in "Find in Database" function.
  8. Connection Information could not display properly in large font size.
  9. Default value of bit field was shown incorrectly in MySQL Table Viewer.

To upgrade, please visit our Customer Center.


Sep 19 2011
Navicat Premium (Windows) version 10.0.5 is now available

Improvements:

  1. Improved performance of "Reverse Database to Model" and "Reverse Tables to Model.
  2. Foreign Keys is now able to be imported into Model.
  3. Spacing issue has been improved in Beautify SQL.

Bug Fixes:

  1. Cross transfer to SQL Server would fail when "identity" error occured.
  2. Import from paradox file was unable to get signed short integer values.
  3. User Privileges typo was fixed.

To upgrade, please visit our Customer Center.


Sep 12 2011
Navicat Premium (Windows) version 9.1.12 is now available

Improvements:

  1. MySQL indexes is now included in Create Table during Data Transfer.
  2. PostgreSQL Import Wizard is now able to recognize varchar type with defined length from ODBC database source.

Bug Fixes:

  1. The highlighted items from the previous searching results in Table Designer was failed to clear for the next searching.
  2. MySQL foreign key was unable to be created in Table Designer when referencing a destination field requiring index.
  3. "SET FOREIGN_KEY_CHECKS=1" did not generate while running MySQL Structure Synchronization.
  4. Index method was unable to be saved in PostgreSQL Table Designer.
  5. PostgreSQL Language did not include in Store Procedure.
  6. Restored bytea data in PostgreSQL was failed.
  7. "Access violation" error occurred in Navicat main windows during the debug function in Oracle Debugger.
  8. Default scale of 4 was applied when encountering currency data during the Import of Access file in Navicat MySQL, PstgreSQL and Oracle version.
  9. Field name with over 30 characters long was unacceptable in SQLite Table Designer.
  10. INDEX definitions did not include in SQLite SQL Dump File and Data Transfer feature. And database name referenced was missed in the INSERT commands.
  11. Data with #10 or #13 would be determined as BLOB type during SQLite Export Wizard.
  12. New version of SQL Server Native Client could not be recognized.
  13. Failed to set open status for SQL Server database in Connection Properties.
  14. SQL Server Table Designer did not accept an index name with over 30 characters long.
  15. Parse could not apply on a running SQL in SQL Server Query form.
  16. Failed to match source column data to the corresponding column during SQL Server Import Wizard.

To upgrade, please visit our Customer Center.


Sep 6 2011
Navicat Premium (Windows) version 10.0.3 is now available

Major New Features:

  1. Data Modeling Tools.
  2. ER Diagram view.
  3. SQL Minifier.
  4. Database Wide Search.

Improvements:

  1. Ability to run transaction backup for MySQL database (InnoDB only).
  2. Added object list in Query Editor.
  3. Added DDL tab in Object Information.

To upgrade, please visit our Customer Center.


Jun 1 2011
Navicat Premium (Windows) version 9.1.11 is now available

Improvements:

  1. Added Ctrl+a as shortcut key for "select all" in Form View.

Bug Fixes:

  1. Wrong table would be copied while running "Duplicate Table" function.
  2. MySQL Object Information was unable to be refreshed when under "List" view mode.
  3. Foreign Key Check box under Table Designer was unable to be toggled using space bar.
  4. Searching in Table Viewer would freeze when no record showed on the existing view.

To upgrade, please visit our Customer Center.


Apr 11 2011
Navicat Premium (Windows) version 9.1.10 is now available

Bug Fixes:

  1. Scroll bar in Trigger Definition editor was missing.
  2. Object List frozen.
  3. The size of the width in Run Result columns were too large in Stored Procedure form.
  4. "Grid index out of range" error occured while refreshing in Table Viewer.
  5. Connection combo box showed wrongly in Data Synchronization.
  6. "[Err] Field 'COUNT(1)' not found" error occured when applying Update mode in Import Wizard for SQL Server.
  7. SQL Server permission denied on object 'sysproperties'.
  8. Import Wizard was unable to import SQL Server string data to varchar, varchar(max), text field properly.
  9. Query was unable to execute a SQL containing DROP statement inside MySQL Create Statement.

To upgrade, please visit our Customer Center.


Feb 21 2011
Navicat Premium (Windows) version 9.1.9 is now available

Improvements:

  1. Import from ODBC to PostgreSQL is now automatically mapped character data with length definition > 255 to text data type.
  2. Added "Grant All", "Revoke All" etc in Server Privileges tab of MySQL/Oracle/SQL Server User Designer.

Bug Fixes:

  1. Navicat Main was unable to list huge number of Logins in SQL Server.
  2. Navicat was unable to list function which returning table of PostgreSQL 9.0.
  3. Table with Oracle object array was unable to be opened in Table Viewer.
  4. MySQL Procedure/Function Designer was unable to get the body part correctly.
  5. Imported text-based file with UTF-8 encoded data to blob field incorrectly.
  6. "Use empty string as NULL" option while importing from XLS/XLSX formats is now working correctly.
  7. SQLite Data Transfer with data '-' would cause syntax error in SQL.
  8. SQL Server Procedure names were unable to locate from Data Transfer.
  9. Failed to run multiple Data Synchronization at the same time.
  10. Table with identity fields was not working correctly in Data Synchronization.
  11. Invalid pointer error would occur after editing MySQL procedure/function during Structure Synchronization.

To upgrade, please visit our Customer Center.


Jan 17 2011
Navicat Premium (Windows) version 9.1.8 is now available

New Feature:

  1. Support of SQL Azure.
  2. Added Firewall Rules setting for SQL Azure.
  3. Added Bandwidth Usage in Connection Information for SQL Azure.

Improvements:

  1. Improved sorting order in Connection Tree and Object list.

Bug Fixes:

  1. MySQL Table Designer was unable to handle field insertion.
  2. MySQL Table Designer was unable to insert a field as first since Navicat modifies the second field to reference the not yet inserted field.
  3. MySQL Table Designer now supports primary key fields ordering.
  4. Table Designer was unable to show/edit trigger definition.

To upgrade, please visit our Customer Center.


Jan 12 2011
Navicat Premium (Windows) version 9.1.7 is now available

Improvements:

  1. Improved the compatibility of third party plugin (eg. Ultramon, Hardcopy etc).
  2. Added Identity Insert statement for SQL Server Data Synchronization.

Bug Fixes:

  1. "Failed to parse code near RESTRICT" error occurred when updaing/deleting a foreign key to a field with RESTRICT action in SQL Server Table Designer.
  2. When changing PostgreSQL table structures, improper SQL orders were executed, causing SQL error in some cases.
  3. Function Designer was unable to show definition for MySQL function with certain return types.
  4. SQL Server export view profile did not show in list.
  5. Multiple files with files delimited as '|' were unable to be recognized during Import Wizard.
  6. Date format were fixed in SQL Server Data Transfer.

To upgrade, please visit our Customer Center.


Dec 28 2010
Navicat Premium (Windows) version 9.1.6 is now available

Bug Fixes:

  1. SQLite Table Viewer treated e.g. "2010-12-14" as number format instead of text format.
  2. Limit Records feature did not work in SQL Server Table Viewer.
  3. When altered procedure, SQL would be missing a dot between schema name and object name during Structure Synchronization in SQL Server.
  4. DBF character field length would be set to 254 if table field length is 0 while exporting to DBF file.
  5. Tree node was unable to be highlighted when Connection Coloring feature was applied under Windows XP.

To upgrade, please visit our Customer Center.


Dec 14 2010
Navicat Premium (Windows) version 9.1.5 is now available

Improvements:

  1. Improves performance in SQL Server Table Viewer.
  2. SQLite Table Viewer is now able to handle numeric value in Update/Insert statement.

Bug Fixes:

  1. Any SQLite unique constraints set at a column level were lost if a previously created table was opened.
  2. When adding fields in a table with SQLite foreign key constraint in Table Designer, the reference table field would be renamed.
  3. MySQL Function/Procedure Designer was unable to show object body contents with RETURNS text as CHARSET and RETURNS ENUM/SET data type.
  4. MySQL Function/Procedure Designer was unable to show object body contents with argument of ENUM/SET data type.
  5. MySQL Query Builder was unable to recognize identifier starting with numbers, e.g. 123xyz.
  6. Wrong parenthesis generation in Query Builder when new table was added to FROM clause of query like e.g. select ... from (t1 join t2 on a=b).
  7. Code Completion did not work properly with field name if tables were from different database.
  8. Exported data (string) to Excel file did not work properly, e.g. value of '1E' would being exported as 1.
  9. Data Transfer did not work from MySQL to SQL Server.
  10. Structure Synchronization showed wrong compare option caption after changing connection to different kinds of database.
  11. Fixed no permission returned when getting row count of SQL Server table.

To upgrade, please visit our Customer Center.


Nov 30 2010
Navicat Premium (Windows) version 9.1.3 is now available

Improvements:

  1. Includes "SQL Server 2008 Native Client" x64 version in Navicat installer package.

Bug Fixes:

  1. Data was truncated with VARCHAR as data type.

To upgrade, please visit our Customer Center.


Nov 25 2010
Navicat Premium (Windows) version 9.1.2 is now available

Major New Features:

  1. Support of Microsoft SQL Server (2000 to 2008R2).
  2. Support of MySQL Server 5.5.
  3. Support of PostgreSQL Server 9.
  4. Connection to SQL Server through SSH
  5. Support Keep Connection Alive for Oracle and SQL Server.
  6. Support of geometry data type for MySQL and SQL Server.
  7. Support BTREE and HASH index methods for MySQL Server.
  8. Support of UUID/GUID generator for PostgreSQL/SQL Server.
  9. Support of SQL Server Code Outline.
  10. New Privilege Manager.
  11. Enhanced User/Role Management.
  12. Data Synchronization performance improved with new engine.
  13. Connection Coloring.

To upgrade, please visit our Customer Center.


Oct 4 2010
Navicat Premium (Windows) version 9.0.15 is now available

Bug Fixes:

  1. "700 - Invalid response: 403" error occured when using HTTP tunnel connection for MySQL, PostgreSQL and SQLite server.
  2. Index/Trigger was unable to be renamed in SQLite Table Designer.
  3. SQLite Foreign Key did not work properly.
  4. "Out of memory" error occured when running a long SQL in Query function.
  5. "Access violation" error occurred when running an invalid SQL syntax in Query function e.g. SELECT DBMS_OBFUSCATION_TOOLKIT.MD5(input_string=>'1') FROM DUAL.
  6. Result form showed in Query Editor would be closed after a new query was run.
  7. Beautify SQL returned an invalid SQL syntax, e.g. formatted xxx@yyy into xxx @ yyy.
  8. "Cannot call Start on a running or suspended thread" error occured when exporting tables with mutli resultsets.
  9. SQLite "Check For Updates" did not work properly.

Upgrade Procedure : click here to upgrade


Sep 15 2010
Navicat Premium (Windows) version 9.0.14 is now available

Improvements:

  1. Allow to save Function in Oracle Procedure/Function Designer if user selected Procedure in first step of Function Wizard

Bug Fixes:

  1. SQLite Table Designer did not allow to create data type TEXT, BLOB, REAL, etc with length, precision and scale.
  2. SQLite indexes were unable to be removed in Table Designer.
  3. When pasting an enum type value using CTRL+V in Tabler Viewer, the drop down list box would be shown in wrong position.
  4. "Access violation" error occurred when running an invalid SQL syntax in Query Builder, e.g. select ... from ,table01.
  5. Imported string data as blob data incorrectly to MySQL, PostgreSQL and SQLite database using Import Wizard.
  6. Failed to import characters data as NVARCHAR2, NCHAR, CLOB, NCLOB to Oracle server using Import Wizard.
  7. In Structure Synchronization, when the queries generated in the "Queries for Modification" list were too long (e.g. 8000 characters), the whole line would become blank.
  8. Error occurred for Oracle and PostgreSQL server when primary key constraint name in source table conflicted with the unique index which was created as the same name as the primary key in Structure Synchronization.
  9. Field names for some tables with special names were unable to be listed in Report Builder.

Upgrade Procedure : click here to upgrade


Aug 30 2010
Navicat Premium (Windows) version 9.0.13 is now available

Improvements:

  1. Horizontal scrollbar is now reset to the left position after applying Beautify SQL feature.

Bug Fixes:

  1. SQLite index/trigger was unable to be removed from the Navicat main window.
  2. "Access violation" error sometimes occurred when running an invalid syntax in Query Editor.
  3. Data Transfer profiles were unable to be opened for PostgreSQL server.
  4. "Access violation" error occurred when opening a Oracle search report in Report Viewer.

Upgrade Procedure : click here to upgrade


Aug 2 2010
Navicat Premium (Windows) version 9.0.12 is now available

Bug Fixes:

  1. PostgreSQL Foreign Key Data Selection did not work properly.
  2. Brackets in FROM clause could not be parsed between Query Editor and Query Builder.
  3. When exporting numeric data with comma as decimal seperator to access file, the numbers were displayed without the comma.
  4. Failed to transfer database objects to different server type when transfering to sql file in Data Transfer.
  5. When exporting numeric data to excel file, it would be exported as string type.
  6. Sort by time could not work properly in MySQL and Oracle Server Monitor.
  7. Process ID became negative value in MySQL, Oracle and PostgreSQL Server Monitor.

Upgrade Procedure : click here to upgrade


Jul 15 2010
Navicat Premium (Windows) version 9.0.11 is now available

Improvements:

  1. Added highlight keywords - ELSIF for PostgreSQL and Oracle, and ELSEIF for PostgreSQL in SQL Beautifier.

Bug Fixes:

  1. "Access Violation" error occured when printing database/table structure to PDF, HTML etc.
  2. "Open Table (Quick)" feature for MySQL and Oracle could not work properly in some machines issues.
  3. Fixed "mysql.proc" error occured in Table Designer.
  4. Privileges tab in PostgreSQL and Oracle Table Designer was unable to toggle check box using keyboard.
  5. "List Index our of bounds (58)" error occured when trying to enter/edit SQL in query Definition tab.
  6. Foreign Key link position in Visual Builder were not accurate enough.
  7. Fixed bug when parsing FROM clause with brackets in Visual Builder, e.g. select ... from ((...)).
  8. MySQL codepage problem in Data Transfer feature.
  9. Server Monitor would crash if being opened for a while.
  10. The info column in Server Monitor only showed (WIDEMEMO).
  11. Object Selection in SQLite Restore window wrongly displayed items "Indexes" and "Triggers".
  12. MySQL database/table Privileges were unable to show with uppercase names.

Upgrade Procedure : click here to upgrade


Jun 23 2010
Navicat Premium (Windows) version 9.0.10 is now available

Improvements:

  1. Structure Synchronization will now not compare MySQL table comment.

Bug Fixes:

  1. Auto-reconnection did not work on SSH tunnel connection to MySQL server.
  2. Fixed the unicode display problem on Text field with MySQL 4.0 or below.
  3. Beautify SQL would cause error if extra spaces existed in aggregate function.
  4. Fixed error when importig XML files from the Interent.
  5. When exported data to Excel spreadsheet, string start with zero (e.g. 009123) would be changed to integer (9123).
  6. "Access Violation" error occured in Manage User when MySQL user did not have enough privilege.
  7. "Ask to save new queries" in Options would be reset to unchecked after Navicat restarted.

Upgrade Procedure : click here to upgrade


Jun 8 2010
Navicat Premium (Windows) version 9.0.9 is now available

Bug Fixes:

  1. "700 - Invalid response: 417" error occured when connecting to server over HTTP Tunnel.
  2. Each SQLite field was limited to 65536 bytes.
  3. "Duplicate name 'Field11' in TFieldDefs" error occured if a table contained more than 11 fields in which the first ten field names include "Field1".
  4. Tab order in Import Wizard was set up incorrectly.

Upgrade Procedure : click here to upgrade


May 31 2010
Navicat Premium (Windows) version 9.0.8 is now available

Improvements:

  1. Added more popup option for Where and Having clauses in Query Builder.

Bug Fixes:

  1. In Navicat main, View -> Sort did not work properly.
  2. In Navicat main, copying action would not work properly after certain user actions.
  3. In Navicat main, Window -> Next Window did not work properly.
  4. When adding new field and tabbing across cloumns in Table Designer, bule hash would appear at the end of the columns.
  5. When tabbing betweem columns in Table Deisgner, some columns would be skipped.
  6. Beautify SQL feature did not compatible with Navicat Query Parameter syntax, so that error would occur when running the parameter query.

Upgrade Procedure : click here to upgrade


May 17 2010
Navicat Premium (Windows) version 9.0.7 is now available

Improvements:

  1. Support encrypted SQLite file (wxSQLite3).
  2. Improved smart quote identifier for SQLite.
  3. Improved virtual grouping rename issue - e.g. group like "ITem" and it didn't allow to change into "Item".
  4. Changed to use Ctrl+MouseWheel instead of LeftClick+MouseWheel for zoom in/out function in Query Editor.
  5. Query Builder is now able to handle incomplete SQL statement when switching between Query Editor and Query Builder.
  6. SELECT clause is now able to be generated when dragging a table to Query Builder without selecting any columns, and switching to Query Editor.
  7. Improved export data to excel spreadsheet - number/float data is now being export to number format instead of string format.
  8. Widen the width of the saved profiles list under Data Transfer and Data/Structure Synchronization windows.
  9. Added shortcuts for Structure Synchronization - [ctrl+a] to select all scripts, [ctrl+c] to copy selected scripts, right click the popup menu to copy the selected scripts.

Bug Fixes:

  1. Access Violation error occured when exporting chart report to excel file.
  2. "1054 unknown column error" occured when updating or inserting a record in MySQL View that has Alias names in the Select statement.
  3. The automatic word wrap in TEXT fields not working properly in Form View.
  4. "Navicat is not able to prase SQL" error occured in Query Editor.
  5. Navicat freezed when applying "Beautify SQL" on some SQL statements.

Upgrade Procedure : click here to upgrade


May 10 2010
Navicat Premium (Windows) version 9.0.6 is now available

Improvements:

  1. Added Java and XML syntax highlighting for Oracle.
  2. Support Cancel action in copying SQLite objects, table and query.

Bug Fixes:

  1. When unchecked MySQL "Include other table options" in Data Transfer, engine/table type, character set, auto increment settings were not transferred properly.
  2. The font size used in Query grid was smaller than in View grid.
  3. "Set Display Format" option in Table Viewer did not work in numerical field.
  4. Fixed the wrong positioning issue of main menu items.
  5. MySQL character set/collation type issue in Query Builder or View Builder.

Upgrade Procedure : click here to upgrade


May 3 2010
Navicat Premium (Windows) version 9.0.5 is now available

Improvements:

  1. Improved the performance for opening Table Viewer with huge amount of columns.

Bug Fixes:

  1. When selecting a particular entry in an enum select box by typing the first letters of the item, the wrong value would be saved if confirmed the changes using the check mark.
  2. When applied "Auto save" function, recover window would not launched if multiple Navicat instances started.
  3. "Access violation" error occured when creating function using Function wizard.
  4. "Access violation" error occured in Foreign Key Data Selection feature if SQLite reference table did not exist.
  5. Fixed the column width of SQLite Foreign Key Data Selection window.
  6. "Not enough storage is available to complete this operation" error occured when exporting field values start with "=" to Excel file.
  7. Fixed the drag & drop problem on Select, Where, Group By, Having, Order By, Limit regions in Query Builder.
  8. When trying to determine if the dataset were editable in Query, error would occur if user contained privilege on View, but did not have select privilege for Table.
  9. Error would occur when switching between Query Editor and Query Builder with MySQL INTERVAL clause included.
  10. Fixed GUI problem when opened Edit -> Options in SQLite Table Designer.
  11. "Access violation" error occured for code/word completion feature.

Upgrade Procedure : click here to upgrade


Apr 26 2010
Navicat Premium (Windows) version 9.0.4 is now available

Improvements:

  1. Better handle case sensitive of object identifier for Query Builder.
  2. Support "select ... from ... group by left(..., ...)" when switching from Query Editor to Query Builder.
  3. Reviewed default Keyword/Function for Oracle.
  4. Improved keywords list for Code/Word Completion.
  5. Attached hot keys to the navigation bar in Table Viewer.
  6. In Oracle Code Outline, supports parameter as node for simple view.
  7. In Oracle Code Outline, supports sort by position, sort by type/name.

Bug Fixes:

  1. Toolbar buttons did not refresh after maximized/minimized and changed size of panes.
  2. Toolbar would blink when toggling taskbar auto hide option.
  3. Oracle debugger window could not be closed when debug running error occured.
  4. Incompleted MySQL Stored Procedure SQL statement showed in Stored Procedure Designer.
  5. When sweithed between Query Builder ad Query Editor, ";" would be inserted into the middle of the statement.
  6. MySQL auto-increment and character set would not be transtered during Data Transfer function.
  7. "Select All" and "UnSelect All" buttons missing in Data Synchronization window.

Upgrade Procedure : click here to upgrade


Apr 12 2010
Navicat for Premium (Windows) version 9.0.3 is now available

Main New Features:

  1. Support of SQLite.
  2. Import/Export connection.
  3. PL/SQL Code Debugger.
  4. Code outline for Oracle functions/procedures/packages/types.
  5. Significant Improvements made in code/word completion.
  6. Code Folding.
  7. Matched Brace/Bracket Highlighting.
  8. Parameter Tips.
  9. Zoom In/Out for SQL editors.
  10. SQL Beautifier.
  11. Favorites.
  12. Object Filter.
  13. Individual database objects backup.
  14. Unicode Character Report.
  15. Auto save in Query, Function etc.
  16. Custom sort in Tabler Viewer.
  17. Significant Improvements made in editor and data grid searching.
  18. Notification email supports SSL/TLS in Schedule.
  19. History Log Viewer.

Upgrade Procedure : click here to upgrade


Feb 24 2010
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


Jan 19 2010
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


Jan 12 2010
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


Nov 18 2009
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


Oct 28 2009
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


Oct 5 2009
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


Sep 25 2009
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


Sep 3 2009
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


Aug 11 2009
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


Jul 22 2009
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


Jul 13 2009
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


Jul 9 2009
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


Jul 2 2009
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


Jun 26 2009
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


Jun 25 2009
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


Jun 22 2009
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

Mar 5 2014
Navicat Premium (Mac) version 11.0.16 is now available

Improvements:

  1. Update SQLite to 3.8.2.
  2. Support unicode61 in SQLite.
  3. Now only column titles of the first result included when exporting multi dataset to the same file using Export Wizard.

Bug Fixes:

  1. Tab was unable to be dragged and reordered in full screen mode.
  2. View of storage tab not able to show in SQL Server Table/Index Designer.
  3. Crashed when using Find function in Table Viewer.
  4. Copy and Paste did not work on tables with auto-incremented columns while saving a record by clicking "tick" icon in the Table Viewer.
  5. Crashed after changed the "Use advanced connections" and press "ok" button in MySQL/MariaDB/PostgreSQL Table Viewer.
  6. Parameter list not able to show while including CHARACTER type in function parameters in MySQL/MariaDB Function Designer.
  7. Crashed when selecting a suggested word that required quoting in Scintilla auto completion.
  8. Crashed while scrolling table in Query Builder and exited Navicat.
  9. int with "." as Thousand Separator did not import correctly in Import Wizard.
  10. The datetime format showed in the export profile did not match the format used in the original table.
  11. Date and time were exported incorrectly while using a EDT time zone.
  12. Message Log was unable to save correctly for the Preview function in Data Synchronization.
  13. SQL Server 2005 and prior (if any) did not support the multi insert query used in Data Synchronization.
  14. Foreign key for a composite key was broken into 2 SQL in SQL Server Structure Synchronization.
  15. Table dataset and collation info on CREATE TABLE queries not able to synchronize in MySQL/MariaDB Structure Synchronization.
  16. When changing a relation's referencing schema, the relation remained in the table but the relation line in diagram was removed under Table Designer in Data Modeling Tool.
  17. Crashed when double-clicking the connection tree under Synchronize to Database in Data Modeling Tool.
  18. Schedele helper did not work although jobs still run in old version.
  19. Website version: Typed in the export queries filepath directly would cause file creation error in Data Synchronization.
  20. App Store version: Removed Oracle SQL*Plus option.
  21. App Store Essentials version: Crashed when purchasing Code Completion feature without SQL Builder in View Designer.

To upgrade, please visit our Customer Center.


Jan 7 2014
Navicat Premium (Mac) version 11.0.15 is now available

Improvements:

  1. Improved connection tree behavior in main window.

Bug Fixes:

  1. Identifier name quoting for SQLite database object name.
  2. Wrongly showed "Manage Group" menu item in Oracle materialized view and datapump export profile menu.
  3. Database name was changed if failed to open it.
  4. Popup menu was shown far away when clicking on Diagram View or Model Design in retina display.
  5. Crashed when deleting active connection.
  6. Crashed when typing single digit in hour/minute/second field and press OK in table viewer.
  7. Unable to show error when getting database on open connection.
  8. Wrongly transformed MySQL date value in exported file.
  9. Crashed when closing the Export Wizard for exporting selected row in Table Viewer.
  10. Limited the number of rows in the exported file when exporting SQL Server table.

To upgrade, please visit our Customer Center.


Dec 20 2013
Navicat Premium (Mac) version 11.0.14 is now available

Improvements:

  1. Disabled zooming by magic mouse in Query Editor.

Bug Fixes:

  1. Failed to open table on Mac OS X 10.6.
  2. View's virtual group was created in Table object list.
  3. Unable to add view's profile to the virtual group.
  4. Identifier name quoting problem in SQLite.
  5. Unable to duplicate profiles.

To upgrade, please visit our Customer Center.


Dec 18 2013
Navicat Premium (Mac) version 11.0.13 is now available

Improvements:

  1. Added shortcut keys for "Save" and "Save As" in Data Synchronization.
  2. Enhanced Data Synchronization.
  3. Allow to select tag to identify data when exporting table to JSON format.
  4. Improved the update statement when editing SQLite table with rowid primary key in Table Viewer.
  5. Saved field selection window size in Table Designer.

Bug Fixes:

  1. Failed to duplicate MariaDB tables with virtual columns.
  2. Failed to copy Binary value in Table Viewer for MySQL 4.1.
  3. Crashed when running Explain on Mac OS X 10.6.
  4. After transferred tables with sequences, popup error when insert record in Table Viewer.
  5. Unable to close Server Monitor's popup dialog in Mac OS X 10.9.
  6. Enabled Open button and Restore Backup menu item when no backup profile is selected.
  7. Wrongly quoted the value in Export output file.
  8. PostgreSQL function "DEFAULT VALUE" was applied to other parameters.
  9. Failed to show SQL when editing PostgreSQL primary key indexes.
  10. Failed to save connection order in main window.
  11. Editor failed to show when first open the Table/View Viewer.
  12. Unable to save the resultset's column width after re-run the query.
  13. App Store version: Failed to list tables after connected.
  14. Website version: Unable to send attachments in Schedule.

To upgrade, please visit our Customer Center.


Nov 8 2013
Navicat Premium (Mac) version 11.0.12 is now available

Improvements:

  1. Support of MariaDB 5.1 or above.

Bug Fixes:

  1. Command-F unable to close the search function in main window.
  2. Export Wizard wrongly to get Time Delimiter as Decimal Delimiter.
  3. Crashed while printing diagram in Data Modeling Tool.
  4. Data Synchronization dialog window stayed opened.

To upgrade, please visit our Customer Center.


Oct 31 2013
Navicat Premium (Mac) version 11.0.11 is now available

Improvements:

  1. Compatible with Mac OS X 10.9 Mavericks.

Bug Fixes:

  1. Crashed on tabbed window.
  2. Failed to import JSON file.
  3. App Store version: Error on export path during Export Wizard in Mac OS X 10.9.
  4. Wrongly displayed for the time fraction part of datetime type in SQL Server Table Viewer.
  5. Crashed when paring "DECLARE myCursor CURSOR FOR" in SQL Server Query Viewer.
  6. SQL Server fields did not compare in Structure Synchronization.
  7. Crashed when opened a linked SQL Server and removed it in main window.
  8. App Store version: Failed to open SQLite database file.

To upgrade, please visit our Customer Center.


Sep 30 2013
Navicat Premium (Mac) version 11.0.10 is now available

Improvements:

  1. Support of SQLite load_extension by setting sqliteLoadExtension boolean to YES in plist file.
  2. Suppport larger row limit for xlsx version, 1048576 rows in Export Wizard.

Bug Fixes:

  1. No popup error showed in Table Viewer.
  2. Failed to find the next match in Find Next action after selecting a cell in Table Viewer.
  3. Crash occured in Query Editor.
  4. Fixed the MySQL auto increment value while altering table in Structure Synchronization.
  5. Duplicated quote occired in PostgreSQL Stored Procedure parameter name.

To upgrade, please visit our Customer Center.


Sep 9 2013
Navicat Premium (Mac) version 11.0.9 is now available

Improvements:

  1. Update SQLite to 3.8.0.2.
  2. New tab window control.

Bug Fixes:

  1. Crash occured while deleting tables with foreign keys on ER diagram.
  2. Options missing in Export profile.
  3. Fixed support "," in schedule time setup.
  4. The text colour in Text Editor did not follow the "Common" colour in Preferences.
  5. Corrupt occured after updating and showing binary type text in Table Viewer.
  6. After selected a cell in Table Viewer, cmd + F not able to focus on the search field if search bar was already shown.
  7. Failed to update setting controls immediately after guessing the field type from newly added field name in Table Designer.
  8. Website version: Failed to show Navicat 10 Import file entries in Navicat 11.

To upgrade, please visit our Customer Center.


Aug 7 2013
Navicat Premium (Mac) version 11.0.8 is now available

Bug Fixes:

  1. Default value of date, time, datetime, timestamp type was not quoted for Create SQL in MySQL Table Designer and Data Transfer.
  2. Failed to get table privilege for non-dba user in Oracle Privilege Manager.
  3. Error not log during fetching rows in Data Transfer.

To upgrade, please visit our Customer Center.


Jul 25 2013
Navicat Premium (Mac) version 11.0.7 is now available

Bug Fixes:

  1. Crashed when set objects as auto-save.
  2. Failed to save position and size when closing windows.
  3. Default value was double quoted for Create SQL in MySQL Table Designer and Data Transfer.

To upgrade, please visit our Customer Center.


Jul 23 2013
Navicat Premium (Mac) version 11.0.6 is now available

Improvements:

  1. Added Crontab Format: range, list, step to date settings in Schedule.

Bug Fixes:

  1. Crashed while created and saved foreign key in main window with HTTP connection in MySQL/PostgreSQL server.
  2. Wrong SQL was generated when setting default value to empty string and not able to select "(EMPTY STRING)" after saved in MySQL Table Designer.
  3. Crashed while parsing Create PostgreSQL function statement for 64 bit version.
  4. Crashed when opening server/catalog level export profiles.
  5. Failed to set the string in Export Wizard's export file path text field.
  6. Failed to open export profile as file in veriosn 11.0.5.
  7. Failed to import number from Excel in Import Wizard.

To upgrade, please visit our Customer Center.


Jul 10 2013
Navicat Premium (Mac) version 11.0.5 is now available

Improvements:

  1. Updated SQLite to 3.7.17.
  2. Updated libxl to 3.5.3.
  3. Adjusted caret color same in Scintilla.
  4. Support sorting items by name inside a virtual group.
  5. App Store version: Added "Oracle" tab in Preference.

Bug Fixes:

  1. SSH connection random crashed.
  2. Fixed number of virtual grouping issues.
  3. Crashed in Query Viewer.
  4. Select/Paste function did not work on the newly added rows in Table Viewer/Query Viewer.
  5. Text/Blob Editor in Table Viewer was reallocated the data in selected cell after refreshed.
  6. Values did not always change in Table Viewer if modified in Query Viewer.
  7. Query not found error occured in Query Favorites feature.
  8. Fixed scrolling issue in MySQL Store Procedure.
  9. Duplicated foreign keys were showed on ER diagram of PostgreSQL databases upon refresh.
  10. Export failed in query result.
  11. When generating create table queries for SQL Server, all numeric fields came with IDENTITY in Data Modeling Tool.
  12. Crashed in Structure Synchronization.
  13. Create table for MySQL/Oracle did not work on different source and target version in Structure Synchronization.
  14. Fixed MySQL auto increment value for create and alter SQL in Structure Synchronization.
  15. "Commands out of sync; you can't run this command now" error occured while creating MySQL new user with table privileges.
  16. App Store version: "Database file path not correct" error occured for new SQLite database file connection.
  17. App Store version: Created SQLite database file got removed upon clicking "OK" on connection panel.
  18. App Store version: Adjusted the DYLD_LIBRARY_PATH and fixed the bundled OCI library loading path for 32 bit for Oracle.
  19. App Store version: Error occured when adding images in Data Modeling Tool.

To upgrade, please visit our Customer Center.


Jun 10 2013
Navicat Premium (Mac) version 11.0.4 is now available

Bug Fixes:

  1. MySQL HTTP connection did not work properly.
  2. Oracle Explain Plan did not get refreshed for new run.
  3. Junk data inserted into SQLite Table and Query viewer while having columns of unknown data type in Find and replace feature.

To upgrade, please visit our Customer Center.


Jun 7 2013
Navicat Premium (Mac) version 11.0.3 is now available

Bug Fixes:

  1. Crashed occured when MySQL connection opened for a long time.
  2. SSH Public key settings was unable to be saved in duplicate connection.
  3. Crashed occured when deleting objects from ER Diagram view.
  4. Oracle Transactions could not roll back after press the "Begin Transactions" button.
  5. Random junk inserted into SQLite field.
  6. Crashed occured when applying filter during the data loading process.
  7. Crashed occured in Query Editor when running an empty query.
  8. Progress indicator in Query viewer result kept spinning after rows inserted.
  9. MySQL View definers was unable to be saved.
  10. Infinite looping in Export Wizard while exporting selected rows.
  11. Crashed occured in Server Monitor while getting the process list.
  12. Data model files not opened while they were not saved in default folder.

To upgrade, please visit our Customer Center.


May 26 2013
Navicat Premium (Mac) version 11.0.2 is now available

Bug Fixes:

  1. SSH connection would keep asking for public key passphrase even the save passphrase/password was checked.
  2. Crashed in ER Diagram when loading and showing diagrams simultaneously.
  3. When exported dataset from and unsaved query, the export file name is now marked as "Untitled".
  4. Duplicated queries were run when exporting result set in Query Viewer.
  5. Crashed occured when closing the Export Wizard after exported the result set in Query Viewer.

To upgrade, please visit our Customer Center.


May 22 2013
Navicat Premium (Mac) version 11.0.1 is now available

Improvements:

  1. Improved tab behavior in Navicat main.
  2. Reduced memory usage when opening Table Viewer.
  3. Support to print and export PDF files with paper size that not available for the printer in Data Modeling Tool.

Bug Fixes:

  1. Crashed in Table Designer with HTTP connection established.
  2. Sorting function did not work properly.
  3. Find Next/Previous in Find and Replace function went wrong after drag and drop column.
  4. The result range not highlighted in Find function.
  5. Blank page appeared in Table Viewer while scrollling down to the end of the page and switching to the last page, when the table contained more than 1000 rows.
  6. Failed to insert record and receive update error, or crashed when clicked on a cell in Table Viewer while uuid type existed in the PostgreSQL and SQL Server table.
  7. Links between join tables would lost in Query/View Builder.
  8. Query was unable to parse the delimiter properly.
  9. Duplicated queries were run when exporting result set in Query Viewer.
  10. Failed to load owner list for PostgreSQL.

To upgrade, please visit our Customer Center.


Apr 30 2013
Navicat Premium (Mac) version 11.0.0 is now available

Major New Features:

Native 64-bit version

Interface

  1. New User Interface
  2. New docking system

Connection

  1. New SSH Manager
  2. Connection Tree Filter

Table Viewer

  1. Find and Replace data
  2. Search Columns
  3. Support Transaction

Table Designer

  1. Search Columns
  2. Field Type Prediction

Query

  1. Support showing multiple results

Import Wizard

  1. JSON file
  2. Excel file 2007 (*.xlsx, *.xlsm)
  3. MS Acess database (*.mdb, *.accdb)

Export Wizard

  1. JSON file
  2. Excel file 2007 (*.xlsx)

Backup/Restore

  1. SQL Server Backup
  2. Oracle Data Pump

Others

  1. New Registration and Activation System
  2. New Updater

To upgrade, please visit our Customer Center.


Feb 7 2013
Navicat Premium (Mac) version 10.1.3 is now available

Bug Fixes:

  1. Connection kept opening even the form was closed.
  2. Table names in ER Disgram view could not be renamed.
  3. Font size in SQL Editors were too large in retina display.
  4. Crashed while opening DBF import profile with Field Delimiter = "" in Import Wizard.
  5. "Disable foreign key checks" option in Data Synchronization was ignored in Schedule.
  6. MySQL Stored Procedure failed to catch the returned error message when saving an illegal statements.
  7. Definition in MySQL Function Designer was unable to return correctly with COLLATE attribute.
  8. Failed to convert PostgreSQL uuid type to target server in Data Transfer.
  9. "Disable foreign key checks" option in Data Synchronization was ignored in Schedule.
  10. Error messages occurred in SQLite's SQL Editor/Builder while field/index name contained 'space'.

To upgrade, please visit our Customer Center.


Nov 15 2012
Navicat Premium (Mac) version 10.1.2 is now available

Improvements:

  1. Support to show SQLite View column name and types.
  2. Support Turkish char input in scintilla.
  3. Allowed to save a export profile for a running query.

Bug Fixes:

  1. Slow performance experienced when editing on grid due to allocation of field editor menu on demand.
  2. Export file name with date format was excluded in the saved export profile.
  3. Incorrect orientation and size were set while printing model in Data Modeling Tool.
  4. SQLite tables with changed fields were unable to synchronize in Synchronize to Database function under Data Modeling Tool.
  5. Error messages occurred when adding a MySQL pkey auto-increment column in Synchronize to Database function under Data Modeling Tool.
  6. Sorting columns with numeric values was not working properly in Server Monitor.
  7. The MySQL Explain tab in Query did not return error message when query contained a non-existent column.
  8. Cross data transfer did not success when transfering table comment to target MySQL or PostgreSQL server.
  9. When scheduling an export job (MySQL, PostgreSQL and SQLite)with sending mail attachment, the attachment failed when the exported file name contained datetime.
  10. Close bracket problem in SQLite XML export file.
  11. Numeric type fields did not accept non-BLOB values in SQLite Table Viewer.
  12. When the column set to PostgreSQL datetime field having second decimal in timestamp, zeros would be exported in Export Wizard.
  13. PostgreSQL Table rows could not shown correctly when the number of rows were too large.
  14. Crashed if Stored Procedure contained syntax error while connecting to SQL Server.

To upgrade, please visit our Customer Center.


Aug 8 2012
Navicat Premium (Mac) version 10.1.1 is now available

Improvements:

  1. The full queries are now shown in Tooltips in "Synchronize to Database" under Data Modeling Tool.

Bug Fixes:

  1. SQLite remote connection failed.
  2. PostgreSQL Function returned incorrect table type.
  3. Time zone string returned by PostgreSQL unable to be transferred to SQL Server.
  4. Scintilla font size doubled in Apple retina display.
  5. Popup window did not show while clicking on Delete item button with no rows being selected in Table Designer.
  6. Datetime value was not obtained correctly from ODBC in Import Wizard.
  7. Index and unique were missing under Data Modeling Tool Table Designer.

To upgrade, please visit our Customer Center.


Jun 15 2012
Navicat Premium (Mac) version 10.1.0 is now available

Improvements on Data Modeling Tool:

  1. Support Unsigned for MySQL Numeric Type.
  2. Support Auto Increment for MySQL Integer Type.
  3. Build model with multiple schemas.
  4. New wizard "Import from Database".
  5. New wizard "Synchronize to Database".
  6. Align/Distribute diagram objects.

To upgrade, please visit our Customer Center.


Mar 15 2012
Navicat Premium (Mac) version 10.0.7 is now available

Improvements:

  1. Increased the limit of number of joins allowed in Query Builder.
  2. Improved the working area on Query Builder.

Bug Fixes:

  1. Fixed the error when running Explain plan for Oracle 9i.
  2. Fixed the error when importing LOB field in Import Wizard.
  3. Fixed a crash issue when re-running a query in Query Viewer.
  4. Fixed the failure of sending email in Schedule.
  5. Fixed the bug of disabled definition box in PostgreSQL function.
  6. Fixed the bug on running functions in PostgreSQL function window.

To upgrade, please visit our Customer Center.


Jan 19 2012
Navicat Premium (Mac) version 10.0.6 is now available

Improvements:

  1. Embedded Oracle Full Client instead of Light Client.
  2. Update the SQLite version to 3.7.10.

Bug Fixes:

  1. Fixed the failure of printing PDF in Model Designer.
  2. Fixed the bug of DISTINCT clause disappeared in Query Editor after using Query Builder.
  3. Fixed the slow response issue when opening Execute SQL File window.
  4. Fixed a crash issue when using Beautify SQL.
  5. Fixed the crash issue when quitting MySQL/PostgreSQL/Oracle/SQL Server process in Server Monitor.

To upgrade, please visit our Customer Center.


Dec 9 2011
Navicat Premium (Mac) version 10.0.5 is now available

Bug Fixes:

  1. Fixed the crash issue when clicking on an object inside a virtual group, having "Click to refresh object list" option was enabled in Preferences.
  2. Fixed the SQL error when using Custom Filter in Filter Wizard.
  3. Fixed the bug in Query Builder where functions were not displayed properly.
  4. Fixed the problem of launching Oracle SQL*Plus.
  5. Fixed the crash issue in Structure Synchronization when comparing SQL Server tables and views.
  6. Fixed the SQL Server connection problem when login using Windows Authentication.
  7. Fixed the bug in schema selection in Execute SQL File on SQL Server connection.

To upgrade, please visit our Customer Center.


Nov 24 2011
Navicat Premium (Mac) version 10.0.4 is now available

Improvements:

  1. SQL scripts copy from Structure and Model Synchronization comparison results are now formatted properly.
  2. MySQL field orders are now properly synchronized in Structure Synchronization.

Bug Fixes:

  1. Fixed the connection issues on some SQL Servers.
  2. Fixed the crash issue when importing tab-delimited file on Mac OS X 10.5.
  3. Fixed the problem of importing null values into newly created fields in Import Wizard.

To upgrade, please visit our Customer Center.


Nov 4 2011
Navicat Premium (Mac) version 10.0.3 is now available

Improvements:

  1. Added hidden option to disable transaction in Stored Procedure in MySQL connection.

Bug Fixes:

  1. Fixed Data Transfer encoding issue when MySQL charset was disabled.
  2. Fixed the bug on the comparison of MySQL field character set.
  3. Fixed the refresh problem after reordered the fields in ER diagram view.
  4. Fixed the reload time issue after saving table.
  5. Fixed the wrong listing for target tables in SQL Server Data Synchronization.
  6. Fixed the bug occurred when selecting weekday in Schedule setup panel.

To upgrade, please visit our Customer Center.


Sep 30 2011
Navicat Premium (Mac) version 10.0.2 is now available

New Feature:

  1. Support connection coloring.

Improvements:

  1. Settings are now stored in ~/Application Support/PremiumSoft CyberTech folder instead of ~/Application Support/Navicat.
  2. Support of setting MySQL socket timeout in Connection Properties.
  3. Support of dumping SQL file with selected tables.
  4. Added option to enable/disable comparing MySQL character set in Structure Synchronization.

Bug Fixes:

  1. Fixed the MySQL/PostgreSQL Structure Synchronization index and default problem.
  2. Fixed the missing Foreign Keys when reversing tables to model.
  3. Fixed the issue of selecting wrong database type when reversing tables to model.

To upgrade, please visit our Customer Center.


Sep 12 2011
Navicat Premium (Mac) version 9.1.8 is now available

Bug Fixes:

  1. Fixed the problem of wrong encoding used when loading queries.
  2. Fixed the issue of not saving a Data Synchronization advanced setting as profile.
  3. Fixed the crash problem when started with the main toolbar hidden.
  4. Fixed the issue of not quoting keyword when creating MySQL table.
  5. Fixed the problem of returning wrong value for FOUND_ROWS() MySQL function.
  6. Fixed the syntax error when transferring index in PostgreSQL.

To upgrade, please visit our Customer Center.


Sep 6 2011
Navicat Premium (Mac) version 10.0.1 is now available

Major New Features:

  1. Data Modeling Tools.
  2. ER Diagram view.
  3. SQL Minifier.
  4. Database Wide Search.

Improvements:

  1. Ability to run transaction backup for MySQL database (InnoDB only).
  2. Added object list in Query Editor.
  3. Added DDL tab in Object Information.

To upgrade, please visit our Customer Center.


Jun 2 2011
Navicat Premium (Mac) version 9.1.7 is now available

Improvements:

  1. SQLite library is updated to version 3.7.6.3
  2. Improved the situation of losing connection in MySQL connection.

Bug Fixes:

  1. Fixed the occasionally hang problem in Query Builder.
  2. Fixed the problem of failing to run Data Synchronization batch job.
  3. Fixed the problem of improperly quoted index expressions in Backup and Table Designer.
  4. Fixed the problem of occasionally displaying blank cell in Table Viewer.
  5. Fixed the problem of continuously adding row when pressing Down Arrow button in Table Viewer.

To upgrade, please visit our Customer Center.


Apr 14 2011
Navicat Premium (Mac) version 9.1.6 is now available

Improvements:

  1. Shorten the timeout when attempting to reconnect to MySQL server.

Bug Fixes:

  1. Append/Update option did not work in Import Wizard.
  2. Unable to list MSSQL 2000 objects for some users.
  3. Unable to open SQL files with some encodings.
  4. Fixed the data sync problem on SQLite attached database.
  5. Fixed the error when inserting empty string to SQLite table.

To upgrade, please visit our Customer Center.


Feb 21 2011
Navicat Premium (Mac) version 9.1.5 is now available

Improvements:

  1. SQLite version 3.7.5 is now used.

Bug Fixes:

  1. Failed to create new MSSQL connection using Windows Authentication.
  2. Crashed when opening table with VARRAY fields in Oracle Table Viewer.
  3. Failed to insert value 0 into numeric fields in MSSQL servers.
  4. Failed to drop existing objects before creating the objects in PostgreSQL connections during the restore process.
  5. High CPU usage when pausing the process of Data Transfer/Data Sync/Structure Sync/Execute SQL File.
  6. Cmd-Shift + Arrow Key shortcut keys were improperly overwritten by the shortcut keys of the tabbed windows.

To upgrade, please visit our Customer Center.


Jan 18 2011
Navicat Premium (Mac) version 9.1.4 is now available

New Feature:

  1. Support of SQL Azure.

Improvements:

  1. More accurately to determine the PostgreSQL system objects.
  2. Elapsed time is now shown for each query in Query Viewer.
  3. The first level tag in XML file is now recognized as the record indicator during Import Wizard.

Bug Fixes:

  1. Queries list in main window was not refreshed after transferring queries.
  2. Crashed when refreshing tables after Record per Page setting had changed in Table Viewer.
  3. After deleting a record, the next record is now selected instead of the final record in Table Viewer.
  4. Improper quoting of values in SQLite Table Viewer when inserting or updating records.
  5. Some value could not be displayed when switching from Grid View to Form View in SQL Server Table Viewer.
  6. Improper MySQL ENUM fields default values were listed for selection in Table Designer.
  7. When changing PostgreSQL table structures, improper SQL orders were executed, causing SQL error in some cases.
  8. Updating SQL Server records improperly used extra fields as update criteria.
  9. SQL results were unable to shown when some kinds of SQL statements were run in SQL Server Query Viewer.
  10. Mode selections were ignored under "Advanced Settings" tab in Data Synchronization.

To upgrade, please visit our Customer Center.


Dec 14 2010
Navicat Premium (Mac) version 9.1.3 is now available

Improvements:

  1. SQLite version 3.7.4 is now used.

Bug Fixes:

  1. Crashed when synchronizing data between MySQL 4 to MySQL 5.
  2. Failed to add MySQL object privileges in User Designer form.
  3. Column level constraints was not recognized in SQLite.
  4. Foreign keys were referencing to wrong tables after altering tables in SQLite.

To upgrade, please visit our Customer Center.


Dec 1 2010
Navicat Premium (Mac) version 9.1.2 is now available

Bug Fixes:

  1. MySQL Data Synchronization did not working properly
  2. Crashed when trying to add row in Form Viewer.

To upgrade, please visit our Customer Center.


Nov 25 2010
Navicat Premium (Mac) version 9.1.0 is now available

Major New Features:

  1. Support of Microsoft SQL Server (2000 to 2008R2).
  2. Support of MySQL Server 5.5.
  3. Support of PostgreSQL Server 9.
  4. Connection to SQL Server through SSH
  5. Support Keep Connection Alive for Oracle and SQL Server.
  6. Support of geometry data type for MySQL and SQL Server.
  7. Support BTREE and HASH index methods for MySQL Server.
  8. Support of UUID/GUID generator for PostgreSQL/SQL Server.
  9. Support of SQL Server Code Outline.
  10. New Privilege Manager.
  11. Enhanced User/Role Management.
  12. Data Synchronization performance improved with new engine.

To upgrade, please visit our Customer Center.


Oct 27 2010
Navicat Premium (Mac) version 9.0.12 is now available

Improvements:

  1. SQLite version 3.7.3 is now used.
  2. $user and public are now included in the search path in PostgreSQL connections.
  3. "Explain Selected" is now added to context menu in Query Viewer.

Bug Fixes:

  1. Foreign key is now enabled for SQLite connections.
  2. Failed to save the status of "Save Passphrase" in SSH panel in Connection properties.
  3. Create time and update time were not displayed properly in MySQL Information View.
  4. Crashed when applied searching on some columns which were hidden under Show/Hide Columns panel in Table Viewer.
  5. Crashed when switching from Query Editor to Query Builder with a specific SQL statement.
  6. Crashed if failed to open view in View Designer.
  7. Failed to backup binary/varbinary in MySQL server.

Upgrade Procedure : click here to upgrade


Sep 21 2010
Navicat Premium (Mac) version 9.0.11 is now available

Improvements:

  1. Shortcut keys are now added back in Query Viewer.
  2. Text Qualifier can now be manually set during Export Wizard.

Bug Fixes:

  1. Rename PostgreSQL databases did not work properly.
  2. Duplicated checks were displayed sometimes in Oracle Table Designer.
  3. Crashed if the returned error messages contain specific character in PostgreSQL/MySQL Query Viewer.
  4. Long column names were truncated in Query Builder.
  5. Incorrect time values were sometimes imported during Import Wizard.
  6. Crashed when importing to SQLite together with Append/Update mode during Import Wizard.
  7. The running order of the Oracle SQL were re-organized to prevent foreign key constraints failed during Data Transfer and Structure Synchronization.

Upgrade Procedure : click here to upgrade


Aug 30 2010
Navicat Premium (Mac) version 9.0.10 is now available

Improvements:

  1. "Test Connection" action can now be canceled in Connection Properties.
  2. Text Qualifier can now be freely set to any characters during Import Wizard.

Bug Fixes:

  1. If a group contained more than two connections, error would occur when trying to delete the group.
  2. Null values were inserted on non-edited timestamp field in PostgreSQL Table Viewer may cause errors.
  3. Updated rows in Query Viewer were reverted back to their previous value after highlighting another rows.
  4. Navicat hanged when importing multiple files using Import Wizard.
  5. Error message could not be displayed if "Continue on Error" was not checked in Data Transfer.
  6. Oracle Foreign keys transferred from one schema to another were mistakenly referring to the source schema during Data Transfer.
  7. Memory allocation problem when the manual was opened.

Upgrade Procedure : click here to upgrade


Jul 29 2010
Navicat Premium (Mac) version 9.0.9 is now available

Bug Fixes:

  1. Changes on SSH settings in Connection Properties would only be applied after Navicat restarted.
  2. In Mac OS X 10.4, Navicat would crash when opening tables with foreign keys.
  3. PostgreSQL default value button was disabled when switching from NULL to "" in Table Designer.
  4. PostgreSQL Sequence is now created before creating table during Structure synchronization.
  5. Menu bar did not display properly when running in Mac OS X 10.4.
  6. Navicat hanged when switching to some object pages in main window when running in Mac OS X 10.4.
  7. Some buttons and text were not displayed properly in Mac OS X 10.4.

Upgrade Procedure : click here to upgrade


Jul 5 2010
Navicat Premium (Mac) version 9.0.8 is now available

Improvements:

  1. Connection name is now shown in the title bar of Console window.
  2. Oracle keyword "elsif" can now be recognized.

Bug Fixes:

  1. Query results were unable to be edited under MySQL HTTP Tunnel connection.
  2. Failed to display MySQL unsigned bigint values properly.
  3. The referencing database of MySQL/PostgreSQL foreign keys were not properly transferred to files.
  4. If the decimal symbol was not set as period (.), incorrect decimal values may be imported for excel files.

Upgrade Procedure : click here to upgrade


Jun 23 2010
Navicat Premium (Mac) version 9.0.7 is now available

Bug Fixes:

  1. HTTP Tunnel did not work properly when some specific characters appeared in username or password.
  2. Failed to prompt for entering HTTP authentication password even password was not saved.
  3. MySQL Bit fields were not displayed properly in Console.
  4. Newline characters were imported improperly into PostgreSQL text fields.
  5. Data Synchronization did not work for SQLite databases.

Upgrade Procedure : click here to upgrade


Jun 9 2010
Navicat Premium (Mac) version 9.0.6 is now available

Improvements:

  1. Show the host information under Connection Information view.

Bug Fixes:

  1. Failed to transfer MySQL Foreign Key to target server if the target database name was different to the source database name.
  2. Memory allocation problem which may cause Navicat to crash when transferring data using Data Transfer.
  3. Incorrect values were synchronized during Data Synchronization.
  4. Crashed easily when running queries in Query Viewer.

Upgrade Procedure : click here to upgrade


May 20 2010
Navicat Premium (Mac) version 9.0.5 is now available

Improvements:

  1. Support encrypted SQLite file (wxSQLite3).
  2. Support to browse SQLite library path.
  3. SQLite Console now uses Navicat's console instead of using the SQLite binary.
  4. SQLite Transaction is now used when changing some existing object, preventing accidental dropping of objects.
  5. If the row is selected, Filter Wizard will now display the words in white color.
  6. Query Builder supports to show diagram for some incomplete statement.

Bug Fixes:

  1. Crashed when getting server Information on Information View if connection failed.
  2. Improper join lines were displayed when joining multiple tables in Query Builder.
  3. Crashed when parsing some improper SQL statements.
  4. Wrong bit field default values were displayed in Table Designer for MySQL version 5.1.31 or above.

Upgrade Procedure : click here to upgrade


May 11 2010
Navicat Premium (Mac) version 8.1.12 is now available

Bug Fixes:

  1. Wrong Bit field default value got from MySQL Server 5.1.30 or below.
  2. Crashed when importing to Oracle Server with comma as decimal separator during Import Wizard.

Upgrade Procedure : click here to upgrade


May 6 2010
Navicat Premium (Mac) version 9.0.4 is now available

Improvements:

  1. Added a section in Query View Result tab so that it can now show the sql and the query time.
  2. Query result data can now be exported even if the sql is not saved.

Bug Fixes:

  1. Failed to edit table data under HTTP Tunnel connection.
  2. Failed to edit data in Views.
  3. View Builder could not generate the corresponding GUI component from the query in View Editor.
  4. Crashed when running SQL query under HTTP tunnel connections.
  5. Failed to delete data inside the cells in Table Viewer by pressing Delete button.
  6. SSH Password box disappeared in Connection Properties windows for Oracle connections.

Upgrade Procedure : click here to upgrade


Apr 30 2010
Navicat Premium (Mac) version 9.0.3 is now available

Improvements:

  1. Added shortcut keys for bottom bar buttons in Table Viewer.
  2. Adjusted the cell editable only when those data is allowed to update in Query Viewer.
  3. Improved the dynamic width for Code/Word completion window.
  4. New lines are now not exported as \n during Export Wizard.
  5. Added Java and XML syntax highlighting for Oracle version.
  6. In Oracle Code Outline, included parameters in the list under proc/func in simple view.
  7. In Oracle Code Outline, showed parameters in the label of proc/func in detail view.
  8. Added button to choose sorting option in Oracle Code Outline.

Bug Fixes:

  1. Dragging images into Image Editor were converted to tiff format.
  2. "Format" menu flashed frequently on Mac 10.5.
  3. SQLite table could not be duplicated if the table name was quoted by `` or [] in the ddl of that table.
  4. Some SQL statements would cause Navicat crashed when switching to Query Builder.

Upgrade Procedure : click here to upgrade


Apr 16 2010
Navicat Premium (Mac) version 8.1.11 is now available

Bug Fixes:

  1. Crashed when comparing non-ascii table name during Structure Synchronization.
  2. MySQL Event status shown incorrectly in Detail View/Information View.
  3. Failed to support the case that second is omitted in Oracle Import Wizard (e.g. "YYYY-MM-DD HH:MM").
  4. Failed to handle Oracle Environmental Path with spaces.
  5. Hangged when executing some SQL file using Execute SQL File function in Mac 10.6.

Upgrade Procedure : click here to upgrade


Apr 12 2010
Navicat for Premium (Mac) version 9.0.2 is now available

Main New Features:

  1. Support of SQLite.
  2. Import/Export connection.
  3. PL/SQL Code Debugger.
  4. Code outline for Oracle functions/procedures/packages/types.
  5. Significant Improvements made in code/word completion.
  6. Code Folding.
  7. Matched Brace/Bracket Highlighting.
  8. Parameter Tips.
  9. Zoom In/Out for SQL editors.
  10. SQL Beautifier.
  11. Favorites.
  12. Object Filter.
  13. Individual database objects backup.
  14. Unicode Character Report.
  15. Auto save in Query, Function etc.
  16. Custom sort in Tabler Viewer.
  17. Significant Improvements made in editor and data grid searching.
  18. Notification email supports SSL/TLS in Schedule.
  19. History Log Viewer.

Upgrade Procedure : click here to upgrade


Mar 26 2010
Navicat Premium (Mac) version 8.1.10 is now available

Improvements:

  1. Maintain Table will now show the full message reported by the server after operation.

Bug Fixes:

  1. Failed to import xml file with values inside xml attributes during Import Wizard.
  2. Failed to backup the server in schedules.
  3. Wrong File menu would be shown sometimes in main window.
  4. Failed to create PostgreSQL index on fields using names with reserved word in Table Designer.

Upgrade Procedure : click here to upgrade


Feb 11 2010
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


Jan 21 2010
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


Dec 21 2009
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


Nov 19 2009
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


Oct 16 2009
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


Sep 21 2009
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


Sep 1 2009
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


Jul 29 2009
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


Jul 15 2009
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


Jun 22 2009
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

Feb 25 2014
Navicat Premium (Linux) version 11.0.17 is now available

Improvements:

  1. MySQL Table Viewer is now able to update a row even not all the keys are input for numeric columns.
  2. Always import as NULL value if "Use empty string as NULL" option is checked in Import Wizard.
  3. All records are now able to show under the Fixed Width window in step 3 of Import Wizard.

Bug Fixes:

  1. 'Control 'Dock2Form_1' has no parent window' error occured while docking in and out of windows.
  2. Connection was deleted after renamed to capitalized name.
  3. Foreign key information with two words identifier not able to get correct correctly in MySQL/MariaDB Table Designer.
  4. Foreign key information with NDB cluster storage engine not able to get correctly in MySQL Table Designer.
  5. Parameter list not able to show in MySQL/MariaDB Function Designer when there was CHARACTER type in function parameters.
  6. datetime2 value with fractional seconds not able to import using SQL Server Import Wizard.
  7. Binary Data Encoding option was ignored in Oracle/SQL Server Import Wizard if string data type existed.
  8. 'Table does not exist' error occured while opening an export profile.
  9. DateTime with fractional precision not handling correctly in SQL Server Export Wizard.
  10. Server with unsaved password not able to connect under 'Import from Database' in Data Modeling Tool.

To upgrade, please visit our Customer Center.


Jan 9 2014
Navicat Premium (Linux) version 11.0.16 is now available

Improvements:

  1. Added Dynamic Column Editor for MariaDB in Table Viewer.

Bug Fixes:

  1. Lose focus in Table Viewer.
  2. Function parser error.
  3. Access Violation error occurred when designing MariaDB tables with foreign keys.
  4. Access Violation error occurred when importing invalid connections.
  5. ERegistry Exception error occurred when starting Navicat.
  6. Oracle reconnection problem.
  7. Wrong Date Editor frame size in Table Viewer.
  8. Stack Overflow error when running Query.
  9. Data Synchronization failed when MySQL or MariaDB table has multi-fields Primary Key.
  10. Permissions issue of the Updater.
  11. Cursor was missing in Stored Procedure.
  12. Failed to create MySQL user with special characters password.

To upgrade, please visit our Customer Center.


Nov 13 2013
Navicat Premium (Linux) version 11.0.12 is now available

Bug Fixes:

  1. Wrong handling on MySQL Integer type.
  2. Changed MySQL properties not check properly in Table Designer.

To upgrade, please visit our Customer Center.


Nov 8 2013
Navicat Premium (Linux) version 11.0.11 is now available

Improvements:

  1. Support of MariaDB 5.1 or above.

Bug Fixes:

  1. Missed to mark quotation on keywords in Query Builder.
  2. Process was unable to stop while running query in Essentials version.
  3. Failed to include auto increment column setting for floating point data types in MySQL.
  4. Access Violation occured when executing MySQL query clause with 'GROUP BY _xxx, _yyy'.
  5. Failed to get the accurate fraction part of date time data for SQL Server.

To upgrade, please visit our Customer Center.


Sep 10 2013
Navicat Premium (Linux) version 11.0.10 is now available

Bug Fixes:

  1. Failed to show definition/DDL for MySQL View.
  2. Failed to check/uncheck column fields in Show/Hide Columns using space key in Tabler Viewer.
  3. Failed to scroll horizontally for wide content after applying Filter Wizard in Table Viewer.
  4. Fixed Oracle explain plan for SYSDBA user.
  5. Fixed some issues on Query and Export features under Oracle level.

To upgrade, please visit our Customer Center.


Aug 7 2013
Navicat Premium (Linux) version 11.0.9 is now available

Bug Fixes:

  1. Failed to save/load blob data in SQLite Table Viewer.
  2. Access violation occured in 64-bit scintilla (Text Editor) after Navicat used huge memory (>4G).
  3. Access violation occured while copying and pasting field in Table Designer.
  4. No respond from Filter Wizard in Table Viewer after execution error of filter query.
  5. Failed to replace text with an empty string using the Find and Replace feature.
  6. Fixed the scrolling issue in docking window on secondary display.
  7. Failed to display unicode user name and organization in Navicat About box.

To upgrade, please visit our Customer Center.


Jul 3 2013
Navicat Premium (Linux) version 11.0.8 is now available

Bug Fixes:

  1. Fixed SQL Server timeout reconnect issue.
  2. SQL Server PRINT message was not showed.
  3. Column width not able to be reset after showing the hidden column in Table Viewer.
  4. Access violation occured in Table Viewer while reconnecting SSH connection with another port.
  5. MySQL default value could not be kept longer than 255 characters in Table Designer.
  6. Query message in status bar not updated if no result return after Run.
  7. Fixed concat string (with date) in MySQL Query.
  8. Access violation occured when entering MySQL query clause with 'GROUP BY _xxx, _yyy'.
  9. Minimum or Maximum value not saved in PostgreSQL Sequence Designer.
  10. Fixed issues on cross transfer.
  11. Certain SQL Server function not copies over in a Data Transfer profile.
  12. Synchronize to database in Data Modeling Tool generated SQL Server column SQL with multiple identity columns.

To upgrade, please visit our Customer Center.


May 27 2013
Navicat Premium (Linux) version 11.0.7 is now available

Bug Fixes:

  1. Key was rejected for SSH connection.
  2. Crashed occured while establishing PostgreSQL connection with SSL.
  3. Access violation occured while running report in command line.
  4. Losing searched position in Memo editor after first searching or clicked into the Memo editor.
  5. Fixed query parser error.
  6. Invalid relation cardinality not showed in red color in Data Modeling Tool.

To upgrade, please visit our Customer Center.


May 9 2013
Navicat Premium (Linux) version 11.0.6 is now available

Bug Fixes:

  1. Fixed "Keyboard Interactive Failed" error for SSH tunnel connection.
  2. Crashed while using SSH tunnel connection for both source and target servers in Data Transfer.
  3. "Access violation" error occurred while entering query clause with 'ORDER BY _xxx ASC/DESC' in Query.
  4. Notification email not sent with an unsaved batch job.
  5. SQLite query result table not able to update while having zero and padding integer.

To upgrade, please visit our Customer Center.


Apr 30 2013
Navicat Premium (Linux) version 11.0.5 is now available

Major New Features:

Interface

  1. New User Interface
  2. New docking system

Connection

  1. New SSH Manager
  2. Connection Tree Filter

Table Viewer

  1. Find and Replace data
  2. Box Selection
  3. Multi-Cell Editing
  4. Search Columns
  5. Web Viewer
  6. Memo Editor with syntax highlight
  7. Support Transaction
  8. Support animated gif in Image viewer
  9. Copy data as INSERT/UPDATE statement

Table Designer

  1. Search Columns
  2. Field Type Prediction

Query

  1. Enhanced Query Builder

Import Wizard/Export Wizard

  1. JSON file
  2. CSV file
  3. Improved binary data handling

Backup/Restore

  1. Oracle Data Pump

Others

  1. New Registration and Activation System
  2. New Updater

To upgrade, please visit our Customer Center.


Feb 4 2013
Navicat Premium (Linux) version 10.1.8 is now available

Bug Fixes:

  1. Transaction did not work properly in Table Designer while using SQLite HTTP Connection.
  2. Table Viewer could not allow to edit while using SQLite HTTP Connection.
  3. "Access violation" error occurred while applying an existing table name on a new table in Data Modeling Tool.
  4. The current value of PostgreSQL Sequence object was unable to synchronize properly and returned incorrect nextval value in Structure Synchronization.

To upgrade, please visit our Customer Center.


Dec 11 2012
Navicat Premium (Linux) version 10.1.7 is now available

Improvements:

  1. Support fractional seconds precision of time, datetime, timestamp data types for MySQL 5.6.4/MySQL MariaDB 5.3 or above.
  2. Allow max SQL Server datatype (varchar, nvarchar, varbinary) in Data Synchronization.
  3. The Profile tab under MySQL Query is now displayed without sorting.
  4. Support MySQL date time format 2012-12-31T01:02:03.456 in Import Wizard.
  5. Support fractional seconds precision of time, datetime, timestamp data types for MySQL 5.6.4 or above under Synchronize to Database function in Data Modeling Tool.
  6. Support to ignore comparing MySQL DEFINER clause of view, event, trigger, procedure and function in Structure Synchronization.

Bug Fixes:

  1. MySQL Create function statement which was after DELIMITER change statement was unable to be executed in Query.
  2. "List index out of bounds" error occurred when some source fields were removed after import profile were created during Import Wizard.
  3. Synchronize to Database function in Data Modeling Tool genarated incorrect comparison result for equivalent source and target foreign keys.
  4. Synchronize to Database function in Data Modeling Tool failed to synchronize SQLite tables with changed fields.
  5. Dump SQL File function produced inorrect SQL for Oracle CLOB fields.
  6. When "Run multiple queries in each execution" option is checked for SQL Server, character data was unable to import correctly in Import Wizard.
  7. Binary data (from MySQL, PostgreSQL, SQLite Server) from Access/ODBC was imported incorrectly during Import Wizard.
  8. Records were unable to generate for MySQL Federated table in Dump SQL File and Data Transfer.

To upgrade, please visit our Customer Center.


Sep 19 2012
Navicat Premium (Linux) version 10.1.6 is now available

Improvements:

  1. Added data format options for XML file in Export Wizard.

Bug Fixes:

  1. Error message occurred while creating databases/tablespaces in PostgreSQL 9.2.x.
  2. The dump of an Oracle table with CLOB produced an incorrect SQL statement.
  3. SQLite Table Designer was unable to handle NOT NULL ON CONFLICT field property.
  4. Wrong time unit (ms) was shown under Messages tab in Query function.
  5. Table Designer in Data Modeling Tool was unable to save newly added index and foreign key.
  6. Synchronize to Database function in Data Modeling Tool was unable to generate the referencing table schema name in the SQL scripts.
  7. Server Monitor was unable to show the process for PostgreSQL 9.2.x server.

To upgrade, please visit our Customer Center.


Aug 23 2012
Navicat Premium (Linux) version 10.1.5 is now available

Bug Fixes:

  1. "Execute SQL File" was unable to parse a SQL Server query if 'GO' characters contained in a word.
  2. Empty named MySQL relation was unable to load back in Data Modeling Tool.
  3. Unable to generate sync queries for MySQL fields with auto increment and primary key in Data Modeling Tool.
  4. "Synchronize to Database" function in Data Modeling Tool was unable to generate SQL Server SCHEMA property in comment SQL.
  5. "Access violation" error occurred while opening "Import from Database" form in Data Modeling Tool.

To upgrade, please visit our Customer Center.


Jul 27 2012
Navicat Premium (Linux) version 10.1.3 is now available

Bug Fixes:

  1. Minimized docked window could not restore normally.

To upgrade, please visit our Customer Center.


Jul 19 2012
Navicat Premium (Linux) version 10.1.2 is now available

Improvements:

  1. Added font selection in Option for ER Diagram.

Bug Fixes:

  1. 1064 error occured when running MySQL Store Procedure.

To upgrade, please visit our Customer Center.


Jul 6 2012
Navicat Premium (Linux) version 10.1.1 is now available

Bug Fixes:

  1. If the table contained many columns, new column would be inserted to wrong position in Table Designer (Data Modeling Tool).
  2. Error occured in Oracle, SQLite and SQL Server Filter Wizard when the filter criteria contain '.
  3. SQL Server Stored Procedure only showed the final message after multiple PRINT statements.
  4. Empty string was identified as Null in SQLite.
  5. 'GRANT CREATE ....' not being run in Oracle Query.

To upgrade, please visit our Customer Center.


Jun 15 2012
Navicat Premium (Linux) version 10.1.0 is now available

Improvements on Data Modeling Tool:

  1. Support Unsigned for MySQL Numeric Type.
  2. Support Auto Increment for MySQL Integer Type.
  3. Build model with multiple schemas.
  4. New wizard "Import from Database".
  5. New wizard "Synchronize to Database".
  6. Search filter.
  7. Align/Distribute diagram objects.

To upgrade, please visit our Customer Center.


Mar 28 2012
Navicat Premium (Linux) version 10.0.11 is now available

Bug Fixes:

  1. Navicat got hanged while performing a search in Table Viewer.
  2. Incorrect excel file format was exported while having data started with 0 in Export Wizard.
  3. Copy and paste was not working on index in MySQL/PostgreSQL Table Designer.
  4. "80070001: PrectServer2 not connected" error occurred while transfering Oracle data to file.
  5. Execute SQL File function would not run if there was a SQL Server identifier contains "GO" characters.
  6. SQL Server "double" data type was not being handled properly in Export Wizard.
  7. Auto-increment info was missing while preforming cross data transfer.

To upgrade, please visit our Customer Center.


Jan 31 2012
Navicat Premium (Linux) version 10.0.10 is now available

Improvement:

  1. Support editing Money type for SQL Server 2000.
  2. Import speed has been improved in Import Wizard.
  3. Export speed has been improved in Export Wizard.

Bug Fixes:

  1. 'column d.datpath does not exist' error occurred while Navicat connecting to PostgreSQL server.
  2. Navicat generated 'Not Implemented' error when running under replacement shell UI.

To upgrade, please visit our Customer Center.


Jan 4 2012
Navicat Premium (Linux) version 10.0.9 is now available

Bug Fixes:

  1. While scrolling MySQL index fields, the scrolled position could not be reflected in Table Designer.
  2. MySQL Table Designer generated incorrect SQL statement in field ordering.
  3. The comparison in MySQL columns ordering were generated incorrectly in Structure Synchronization, and Synchronize to Database in Modeler.
  4. Extra SET FOREIGN_KEY_CHECKS MySQL queries were generated even if the comparison results were identical in Structure Synchronization.
  5. Collation in Database Properties not able to set since wrong SQL generation.
  6. Not able to open schema for databases with non-default database collation in SQL Server 2000.
  7. Oracle long Number could not shown in Table Designer.
  8. Synchronize to Database in Modeler generated redundant TYPE clause (PostgreSQL) while comparing a new column.
  9. Synchronize to Database in Modeler did not generate SQLite index SQL properly.
  10. Crash occurred when closing Synchronize to Database in Modeler during the comparison in progress.
  11. Crash occurred while renaming table failed with server error in ER-diagram view.
  12. Data Transfer would hang in Navicat Scheduler.

To upgrade, please visit our Customer Center.


Nov 24 2011
Navicat Premium (Linux) version 10.0.8 is now available

Improvement:

  1. Enhanced MySQL Model transformation.

Bug Fixes:

  1. "Access violation" error occurred when dragging n dropping a server node in connection tree together with the Model/Schedule object pane were opened.
  2. When created a virtual group in the connection tree, it would be added under Model/Schedule object pane while they were opened.
  3. Failed to execute a SQL Server Stored function with some field types.
  4. "Maintain"->"Vacuum Database..." for PostgewSQL and SQLite server would randomly not shown in the connection tree.

To upgrade, please visit our Customer Center.


Nov 14 2011
Navicat Premium (Linux) version 10.0.7 is now available

Improvement:

  1. Source field order is now kept in target table after running "Synchronize to Database" for MySQL server.
  2. SQLite Columns with undefined data type is now able to be searched in "Find in Database" feature.

Bug Fixes:

  1. Incorrect field type showed in ER Diagram.
  2. Fixed-width and row delimiter were unable to retrieve from a profile in Import Wizard.
  3. Structure Synchronization produced invalid pointer exception error when comparing SQL Server stored procedures.
  4. Non-latin characters with different collation columns in MySQL table were unable to search in "Find in Database" feature.
  5. Print report to PDF file would generate a blank file.

To upgrade, please visit our Customer Center.


Oct 17 2011
Navicat Premium (Linux) version 10.0.6 is now available

Improvement:

  1. Support column comment up to 1024 characters for MySQL 5.5.3.
  2. Support table comment up to 2048 characters for MySQL 5.5.3.

Bug Fixes:

  1. Data Modeling Tool was unable to set the reference field of foreign key.
  2. Data Modeling Tool was unable to print with landscape page setting.
  3. When importing data from an URL, it failed to create a temporary file if the same temporary file was being accessed.
  4. Tables contained MySQL geometric point data was failed in Data Transfer and Data Synchronization.
  5. Restore didn't work with the .pmb file created from Navicat for MySQL version 5.
  6. Failed to implement PostgreSQL LIKE query with date time columns in "Find in Database" function.
  7. Failed to implement PostgreSQL 'name' type columns in "Find in Database" function.
  8. Connection Information could not display properly in large font size.
  9. Default value of bit field was shown incorrectly in MySQL Table Viewer.

To upgrade, please visit our Customer Center.


Sep 19 2011
Navicat Premium (Linux) version 10.0.5 is now available

Improvements:

  1. Improved performance of "Reverse Database to Model" and "Reverse Tables to Model.
  2. Foreign Keys is now able to be imported into Model.
  3. Spacing issue has been improved in Beautify SQL.

Bug Fixes:

  1. Cross transfer to SQL Server would fail when "identity" error occured.
  2. Import from paradox file was unable to get signed short integer values.
  3. User Privileges typo was fixed.

To upgrade, please visit our Customer Center.


Sep 12 2011
Navicat Premium (Linux) version 9.1.12 is now available

Improvements:

  1. MySQL indexes is now included in Create Table during Data Transfer.
  2. PostgreSQL Import Wizard is now able to recognize varchar type with defined length from ODBC database source.

Bug Fixes:

  1. The highlighted items from the previous searching results in Table Designer was failed to clear for the next searching.
  2. MySQL foreign key was unable to be created in Table Designer when referencing a destination field requiring index.
  3. "SET FOREIGN_KEY_CHECKS=1" did not generate while running MySQL Structure Synchronization.
  4. Index method was unable to be saved in PostgreSQL Table Designer.
  5. PostgreSQL Language did not include in Store Procedure.
  6. Restored bytea data in PostgreSQL was failed.
  7. "Access violation" error occurred in Navicat main windows during the debug function in Oracle Debugger.
  8. Default scale of 4 was applied when encountering currency data during the Import of Access file in Navicat MySQL, PstgreSQL and Oracle version.
  9. Field name with over 30 characters long was unacceptable in SQLite Table Designer.
  10. INDEX definitions did not include in SQLite SQL Dump File and Data Transfer feature. And database name referenced was missed in the INSERT commands.
  11. Data with #10 or #13 would be determined as BLOB type during SQLite Export Wizard.
  12. New version of SQL Server Native Client could not be recognized.
  13. Failed to set open status for SQL Server database in Connection Properties.
  14. SQL Server Table Designer did not accept an index name with over 30 characters long.
  15. Parse could not apply on a running SQL in SQL Server Query form.
  16. Failed to match source column data to the corresponding column during SQL Server Import Wizard.

To upgrade, please visit our Customer Center.


Sep 6 2011
Navicat Premium (Linux) version 10.0.3 is now available

Major New Features:

  1. Data Modeling Tools.
  2. ER Diagram view.
  3. SQL Minifier.
  4. Database Wide Search.

Improvements:

  1. Ability to run transaction backup for MySQL database (InnoDB only).
  2. Added object list in Query Editor.
  3. Added DDL tab in Object Information.

To upgrade, please visit our Customer Center.


Jun 1 2011
Navicat Premium (Linux) version 9.1.11 is now available

Improvements:

  1. Added Ctrl+a as shortcut key for "select all" in Form View.

Bug Fixes:

  1. './start_navicat: 10: arithmetic expression: expecting EOF: "2*100+13 2"' error would occur when starting up Navicat.
  2. Wrong table would be copied while running "Duplicate Table" function.
  3. MySQL Object Information was unable to be refreshed when under "List" view mode.
  4. Foreign Key Check box under Table Designer was unable to be toggled using space bar.
  5. Searching in Table Viewer would freeze when no record showed on the existing view.

To upgrade, please visit our Customer Center.


Apr 11 2011
Navicat Premium (Linux) version 9.1.10 is now available

Bug Fixes:

  1. Scroll bar in Trigger Definition editor was missing.
  2. Object List frozen.
  3. The size of the width in Run Result columns were too large in Stored Procedure form.
  4. "Grid index out of range" error occured while refreshing in Table Viewer.
  5. Connection combo box showed wrongly in Data Synchronization.
  6. "[Err] Field 'COUNT(1)' not found" error occured when applying Update mode in Import Wizard for SQL Server.
  7. SQL Server permission denied on object 'sysproperties'.
  8. Import Wizard was unable to import SQL Server string data to varchar, varchar(max), text field properly.
  9. Query was unable to execute a SQL containing DROP statement inside MySQL Create Statement.

To upgrade, please visit our Customer Center.


Feb 21 2011
Navicat Premium (Linux) version 9.1.9 is now available

Improvements:

  1. Import from ODBC to PostgreSQL is now automatically mapped character data with length definition > 255 to text data type.
  2. Added "Grant All", "Revoke All" etc in Server Privileges tab of MySQL/Oracle User Designer.

Bug Fixes:

  1. "Missing required library odbc32.dll" error occured while starting Navicat.
  2. Navicat was unable to list function which returning table of PostgreSQL 9.0.
  3. Table with Oracle object array was unable to be opened in Table Viewer.
  4. MySQL Procedure/Function Designer was unable to get the body part correctly.
  5. Imported text-based file with UTF-8 encoded data to blob field incorrectly.
  6. "Use empty string as NULL" option while importing from XLS/XLSX formats is now working correctly.
  7. SQLite Data Transfer with data '-' would cause syntax error in SQL.
  8. Failed to run multiple Data Synchronization at the same time.
  9. Table with identity fields was not working correctly in Data Synchronization.
  10. Invalid pointer error would occur after editing MySQL procedure/function during Structure Synchronization.

To upgrade, please visit our Customer Center.


Jan 17 2011
Navicat Premium (Linux) version 9.1.8 is now available

Improvements:

  1. Improved sorting order in Connection Tree and Object list.

Bug Fixes:

  1. MySQL Table Designer was unable to handle field insertion.
  2. MySQL Table Designer was unable to insert a field as first since Navicat modifies the second field to reference the not yet inserted field.
  3. MySQL Table Designer now supports primary key fields ordering.
  4. Table Designer was unable to show/edit trigger definition.

To upgrade, please visit our Customer Center.


Jan 12 2011
Navicat Premium (Linux) version 9.1.7 is now available

Major New Features:

  1. Support of MySQL Server 5.5.
  2. Support of PostgreSQL Server 9.
  3. Support Keep Connection Alive for Oracle Server.
  4. Support of geometry data type for MySQL Server.
  5. Support BTREE and HASH index methods for MySQL Server.
  6. Support of UUID/GUID generator for PostgreSQL Server.
  7. New Privilege Manager.
  8. Enhanced User/Role Management.
  9. Data Synchronization performance improved with new engine.
  10. Connection Coloring.

To upgrade, please visit our Customer Center.


Oct 4 2010
Navicat Premium (Linux) version 9.0.15 is now available

Bug Fixes:

  1. "700 - Invalid response: 403" error occured when using HTTP tunnel connection for MySQL, PostgreSQL and SQLite server.
  2. Index/Trigger was unable to be renamed in SQLite Table Designer.
  3. SQLite Foreign Key did not work properly.
  4. "Out of memory" error occured when running a long SQL in Query function.
  5. "Access violation" error occurred when running an invalid SQL syntax in Query function e.g. SELECT DBMS_OBFUSCATION_TOOLKIT.MD5(input_string=>'1') FROM DUAL.
  6. Result form showed in Query Editor would be closed after a new query was run.
  7. Beautify SQL returned an invalid SQL syntax, e.g. formatted xxx@yyy into xxx @ yyy.
  8. "Cannot call Start on a running or suspended thread" error occured when exporting tables with mutli resultsets.
  9. SQLite "Check For Updates" did not work properly.

Upgrade Procedure : click here to upgrade


Sep 15 2010
Navicat Premium (Linux) version 9.0.14 is now available

Improvements:

  1. Allow to save Function in Oracle Procedure/Function Designer if user selected Procedure in first step of Function Wizard

Bug Fixes:

  1. SQLite Table Designer did not allow to create data type TEXT, BLOB, REAL, etc with length, precision and scale.
  2. SQLite indexes were unable to be removed in Table Designer.
  3. When pasting an enum type value using CTRL+V in Tabler Viewer, the drop down list box would be shown in wrong position.
  4. "Access violation" error occurred when running an invalid SQL syntax in Query Builder, e.g. select ... from ,table01.
  5. Imported string data as blob data incorrectly to MySQL, PostgreSQL and SQLite database using Import Wizard.
  6. Failed to import characters data as NVARCHAR2, NCHAR, CLOB, NCLOB to Oracle server using Import Wizard.
  7. In Structure Synchronization, when the queries generated in the "Queries for Modification" list were too long (e.g. 8000 characters), the whole line would become blank.
  8. Error occurred for Oracle and PostgreSQL server when primary key constraint name in source table conflicted with the unique index which was created as the same name as the primary key in Structure Synchronization.

Upgrade Procedure : click here to upgrade


Aug 30 2010
Navicat Premium (Linux) version 9.0.13 is now available

Improvements:

  1. Horizontal scrollbar is now reset to the left position after applying Beautify SQL feature.

Bug Fixes:

  1. SQLite index/trigger was unable to be removed from the Navicat main window.
  2. "Access violation" error sometimes occurred when running an invalid syntax in Query Editor.
  3. Data Transfer profiles were unable to be opened for PostgreSQL server.
  4. "Error in updating task" error occurred when saving a scheduled task.
  5. Error occurred when schedule name and path contained unicode string.

Upgrade Procedure : click here to upgrade


Aug 2 2010
Navicat Premium (Linux) version 9.0.12 is now available

Bug Fixes:

  1. PostgreSQL Foreign Key Data Selection did not work properly.
  2. Brackets in FROM clause could not be parsed between Query Editor and Query Builder.
  3. When exporting numeric data with comma as decimal seperator to access file, the numbers were displayed without the comma.
  4. Failed to transfer database objects to different server type when transfering to sql file in Data Transfer.
  5. When exporting numeric data to excel file, it would be exported as string type.
  6. Sort by time could not work properly in MySQL and Oracle Server Monitor.
  7. Process ID became negative value in MySQL, Oracle and PostgreSQL Server Monitor.

Upgrade Procedure : click here to upgrade


Jul 15 2010
Navicat Premium (Linux) version 9.0.11 is now available

Improvements:

  1. Added highlight keywords - ELSIF for PostgreSQL and Oracle, and ELSEIF for PostgreSQL in SQL Beautifier.

Bug Fixes:

  1. "Access Violation" error occured when printing database/table structure to PDF, HTML etc.
  2. "Open Table (Quick)" feature for MySQL and Oracle could not work properly in some machines issues.
  3. Fixed "mysql.proc" error occured in Table Designer.
  4. Privileges tab in PostgreSQL and Oracle Table Designer was unable to toggle check box using keyboard.
  5. "List Index our of bounds (58)" error occured when trying to enter/edit SQL in query Definition tab.
  6. Foreign Key link position in Visual Builder were not accurate enough.
  7. Fixed bug when parsing FROM clause with brackets in Visual Builder, e.g. select ... from ((...)).
  8. MySQL codepage problem in Data Transfer feature.
  9. Server Monitor would crash if being opened for a while.
  10. The info column in Server Monitor only showed (WIDEMEMO).
  11. Object Selection in SQLite Restore window wrongly displayed items "Indexes" and "Triggers".
  12. MySQL database/table Privileges were unable to show with uppercase names.

Upgrade Procedure : click here to upgrade


Jun 23 2010
Navicat Premium (Linux) version 9.0.10 is now available

Improvements:

  1. libcurl.dll library updated.
  2. Structure Synchronization will now not compare MySQL table comment.

Bug Fixes:

  1. Auto-reconnection did not work on SSH tunnel connection to MySQL server.
  2. Fixed the unicode display problem on Text field with MySQL 4.0 or below.
  3. Beautify SQL would cause error if extra spaces existed in aggregate function.
  4. Fixed error when importig XML files from the Interent.
  5. When exported data to Excel spreadsheet, string start with zero (e.g. 009123) would be changed to integer (9123).
  6. "Access Violation" error occured in Manage User when MySQL user did not have enough privilege.
  7. "Ask to save new queries" in Options would be reset to unchecked after Navicat restarted.

Upgrade Procedure : click here to upgrade


Jun 8 2010
Navicat Premium (Linux) version 9.0.9 is now available

Main New Features:

  1. Support of SQLite.
  2. Import/Export connection.
  3. PL/SQL Code Debugger.
  4. Code outline for Oracle functions/procedures/packages/types.
  5. Significant Improvements made in code/word completion.
  6. Code Folding.
  7. Matched Brace/Bracket Highlighting.
  8. Parameter Tips.
  9. Zoom In/Out for SQL editors.
  10. SQL Beautifier.
  11. Favorites.
  12. Object Filter.
  13. Individual database objects backup.
  14. Auto save in Query, Function etc.
  15. Custom sort in Tabler Viewer.
  16. Significant Improvements made in editor and data grid searching.
  17. Notification email supports SSL/TLS in Schedule.
  18. History Log Viewer.

Upgrade Procedure : click here to upgrade


Feb 24 2010
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


Jan 19 2010
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


Jan 12 2010
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


Nov 18 2009
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


Oct 28 2009
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


Oct 5 2009
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


Sep 25 2009
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


Sep 3 2009
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


Aug 11 2009
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


Added to Cart
Product was added to your cart. Review selected items here,

or click the "Cart" button on the right top corner.