Bug-fixes:

1. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Main New Features:

1. All-New Model Workspace
2. Data Profiling
3. Data Dictionary
4. Query Pinned Result
5. Visual Query Explain
6. Table/Collection Profile
7. Navicat URI
8. Manage Connection
9. Enhanced BI Feature
10. Visual Aggregation Pipeline
11. Focus Mode
12. Support Redis Sentinel
13. Many other new features and improvements

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Column headers were not aligned in the data grid.
2. Cannot open PostgreSQL tables in some cases.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Print Output was not updated after running SQL Server stored procedure.
2. Crashed when transferring PostgreSQL data in some cases.
3. "Could not change database" error occurred when working with Azure SQL Database.
4. The screen scrolled to the left after refreshing the data in Data Viewer.
5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Crashed when PostgreSQL connection was lost.
2. Modified data types were not retained when switching to other tables in Import Wizard.
3. "Invalid cursor state" error occurred after computer was idle.
4. Incorrect json array index syntax was generated when transferring MySQL tables.
5. Unable to connect using ssh agent in some cases.
6. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Crashed when presenting dashboard in some cases.
2. Unable to change data types when creating tables.
3. Focus moved to the upper level after deleting an object in Navigation Pane.
4. Some labels disappeared after adding the chart to the dashboard.
5. Unable to display proportion percentages in the chart axis.
6. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to load indexes in MariaDB Table Designer.
2. Crashed when closing Server Monitor.
3. Crashed when switching tabs on Information Pane.
4. Unable to access users in MongoDB.
5. The percentage values shown in the chart were incorrect.
6. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Crashed when opening Navicat on older macOS versions.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Column widths were not retained when opening tables/views.
2. Crashed when scheduling batch jobs in some cases.
3. Primary keys were not displayed for PostgreSQL partitioned tables.
4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. COMMAND-F shortcut did not work in the main window.
2. Refresh button did not work in Server Monitor.
3. Text in the Search box was hidden in some cases.
4. Advanced options in Structure Synchronization cannot be displayed.
5. Crashed when typing commands in Redis Query.
6. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Crashed when opening Redis connection.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Improvements:

1. Support Redis Cluster.
2. Support MongoDB Time-Series Collection.
3. Support setting MySQL descending primary key.

Bug-fixes:

1. Crashed when transferring large tables using SSH connection.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. "The number of row value expressions in the INSERT statement exceeds the maximum allowed number of 1000 row values." error occurred when importing data to SQL Server.
2. Crashed on macOS 14.
3. MariaDB Triggers were transferred multiple times during Data Transfer.
4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Beautify SQL incorrectly added spaces between the function name and parentheses.
2. Dump SQL File did not correctly generate DEFAULT PARTITION.
3. "Parameters supplied for object 'xxx' which is not a function" error occurred when adding record in some cases.
4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Improvements:

1. Support JSON key type for Redis.

Bug-fixes:

1. Syntax error occurred when creating SQL Server database.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Field mapping lost after saving MongoDB import wizard profile.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Copy and paste shortcuts did not work in Navigation pane.
2. The focus jumped to the top level after renaming an object in Navigation pane.
3. Table tree loading issue in Navigation Pane.
4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Main New Features:

1. Support Redis connections.
2. View, edit, search and sort Redis keys and data with Data View.
3. Capture and analyze Redis Pub/Sub messages in real-time.
4. Support local backup and restore of Redis databases.
5. Intuitive interface for editing Redis users and ACLs.
6. Redis Console with syntax highlight and code completion.
7. Well-formatted Redis query results.
8. Automate Redis backup and query execution.
9. Command Monitor and Server Monitor for real-time monitoring of Redis.
10. Support sequence design for MariaDB.
11. Show fields, indexes and more under tables in Navigation Pane.
12. Minor bug fixes and improvements.
13. Navicat for Redis is released.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. High CPU usage when using SSH connection.
2. Unable to save the schedule changes.
3. TAB key did not work when adding field.
4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Crashed when opening Preferences in some cases.
2. Unable to save changes in SQL Server View.
3. Crashed when importing database to model in some cases.
4. Crashed when saving table after changing field comment.
5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Memory utilization issue.
2. Crashed when importing data to model in some cases.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to backup if database folder did not exist.
2. "SET IDENTITY_INSERT [TableName] ON" was not run before importing in some cases.
3. Unable to load cloud connection info when opening data transfer profile.
4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Default value did not show when adding new records.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. 1267 error occurred when clicking the "Users" button.
2. Bar chart label display issue.
3. Unable to connect CockroachDB Serverless.
4. BLOB data was truncated in Console.
5. MongoDB create index issue.
6. Table columns were not aligned in Console.
7. Chart value labels disappeared after reopening Navicat in dark mode.
8. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to enter Enum values in MariaDB table designer.
2. Query Builder did not recognize the selected fields.
3. Crashed when connecting to MongoDB in some cases.
4. "Feature not supported" error occurred when using MongoExport.
5. "Incomplete Input" error occurred when editing SQLite table.
6. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Main New Features:

1. Support OceanBase Community Edition.
2. Support Trend Line for several chart types.
3. Support adding On-Prem Server with URI.
4. Allow skip preview of changes in data sync.
5. Enhanced responsiveness and performance.
6. Improved UI/UX.
7. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Query parameters did not work in some cases.
2. Function group creation issue.
3. Hanged when updating records in some cases.
4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Chart title display issue.
2. Query listing issue when loading cloud queries.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Crashed when opening a table in some cases.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Crashed when hovering over tabs.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Add/Delete Foreign Key issue in ER diagram.
2. "Show bar labels" setting cannot be saved in Charts.
3. Crashed when moving a connection from Navicat Cloud to My Connections.
4. Crashed when running Automation in some cases.
5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Crashed when using table viewer.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Auto completion did not work when inputting ENUM value in the table viewer.
2. Crashed when closing Navicat in some cases.
3. Hanged when designing table.
4. Unable to scroll through the fields with the mouse wheel in Query Builder.
5. Duplicate options in the user Plugin dropdown menu.
6. Connection coloring did not work on subtabs.
7. Crashed when importing invalid json files.
8. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Missing zero padding in year when exporting data to CSV / TXT file.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Data Transfer failed when using HTTP tunnel.
2. Line numbers disappeared when scrolling in Query Editor.
3. Crashed when mapping MySQL and MariaDB fields in Data Synchronization.
4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Main New Features:

1. New Data Generation Tool
2. Enhanced Charts Feature
3. Support of Navicat On-Prem Server

Additional Features:

1. Connection Profiles
2. Field Information Pane
3. PostgreSQL Extensions Management
4. Query Execution Summary
5. Navicat On-Prem Server is released
6. Many other new features and improvements

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Crashed when running scripts in some cases.
2. Crashed when copying records in some cases.
3. The TEXT pane did not retain when running queries.
4. Cannot connect to Microsoft Azure Database in some cases.
5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to dump databases from MongoDB Atlas using MongoDump.
2. Unable to show the cursor when editing TEXT data using Form View in Dark Mode.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Crashed when adding relations to a logical model.
2. Differences were incorrectly detected when synchronizing MySQL table structures.
3. Crashed when running query in some cases.
4. Error occurred when transferring SQL Server tables with user-defined types to other server types.
5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to update data in some cases.
2. Crashed when adding a trigger to PostgreSQL model.
3. Crashed when using Data Transfer in some cases.
4. Exporting JSON field didn't handle NULL and integer values properly.
5. Cursor did not focus to the Search box after pressing CMD-F.
6. Crashed when selecting the "Group by Object Type" in Structure Synchronization.
7. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to read grid data in Dark mode.
2. Unable to sort the last column by clicking the column header in Table Viewer.
3. Duplicate entry error occurred when editing the pasted records.
4. Unable to connect to server via SSH Tunnel in some cases.
5. Hanged when starting Navicat in some cases.
6. "Different primary key type" error occurred when synchronizing MySQL data.
7. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. 'Primary key needs to be integer' error occurred when synchronizing data.
2. Unable to show the ENUM items list in Table Viewer.
3. Unable to sort by clicking the column header in Table Viewer.
4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Crashed when modifying PostgreSQL permissions.
2. Only 10,000 records were exported when exporting MongoDB collection.
3. Data Synchronization UX issue.
4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Improvements:

1. Set the values of a column to NULL.

Bug-fixes:

1. Crashed when saving MariaDB Views.
2. The modified dates of backup files were incorrect.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Improvements:

1. Prompt to change the MariaDB password when it expired.

Bug-fixes:

1. Unable to show the granted privileges if the database name contained wildcard characters.
2. Only the last selected table was printed when printing multiple tables.
3. The SQL Editor was flickered and repainted when saving the query.
4. "Auto Increment" and "Unsigned" options were removed after adding another field.
5. Crashed when using Query Builder on Big Sur.
6. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. The "Set to Null" option was applied to a wrong column when some columns were hidden in Table Viewer.
2. The field size was incorrect in Form View.
3. Crashed when opening/testing a connection after changing "Settings Location" to a folder in Documents.
4. The "SQLite3 Dynamic Library" option did not work.
5. The "Encoding" setting was not stored when the connection was synchronized to Navicat Cloud.
6. "Dump SQL File" stopped running in some cases.
7. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to set the encoding of MariaDB connection.
2. Unable to connect MySQL server when using TLSv1.2.
3. Schedule did not trigger when using Navicat App Store version.
4. The "Close Database" option in the context menu was dimmed when a query tab was focused.
5. The entire connection tree was collapsed when searching.
6. Crashed when deleting a data source in Charts.
7. Crashed when connecting to MongoDB in some cases.
8. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Improvements:

1. Improvement on resizing Information pane.

Bug-fixes:

1. Negative default value displayed as "-" in MariaDB.
2. No records were imported in some cases when Import Wizard displayed "Finished Successfully".
3. Wrong SQL generated for CAST function when switching between Query Editor and Query Builder.
4. "Authentication failed" error occurred when using MongoDump.
5. Crashed when running MongoDB query for the second time.
6. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Error occurred when running a valid updateMany query.
2. Unable to show full table names in the Data Synchronization window.
3. Field names in the Join dialog were truncated.
4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. MongoDB data export failed.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Jumped to the first record when refreshing in Form View.
2. Unable to synchronize data to MySQL 8.0.19.
3. Unable to connect AnalyticDB.
4. Unable to set SET IDENTITY_INSERT ON in Data Synchronization.
5. The list of the reference tables for foreign key was empty in Model.
6. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Scrolling was slow in data viewer.
2. "Error moving files" error occurred when accessing Navicat Cloud.
3. The color picker disappeared in diagram.
4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. The state of the pane in model was not retained.
2. Crashed when synchronizing SQL Server data.
3. Field count was missing in Table Designer.
4. Crashed when opening Console.
5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. "9015: Error Moving Error" error occurred when using Navicat Cloud.
2. Crashed when clicking the Next button without choosing a target database in Data Transfer.
3. Unable to show the whole Trial Reminder dialog.
4. Crashed when editing/composing new queries in some cases.
5. Invalid XML error occurred when importing connections.
6. Crashed when starting Data Transfer in some cases.
7. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Relation attributes were wrong after reopening the logical model.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Crashed when using Data Transfer in some cases.
2. Inserted records to the target server when transferring views.
3. CPU usage was high when using Query Builder.
4. Unable to open the main window when starting Navicat.
5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Crashed when starting Navicat.
2. Dates before 1900 were exported as numeric values when exporting to Excel.
3. The Search feature did not work properly in the Data Transfer window.
4. Icon and text were not aligned well in the Navigation pane
5. The unchecked "Includes anonymous system profile" option was reverted to check after restarting Navicat.
6. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

New Features:

1. New Charts
2. Advanced Data Transfer
3. Brand new Query Builder
4. Enhanced Data Modeling Tool
5. Dark theme UI and Diagram
6. Many other new features and improvements

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Data Synchronization options were unable to save in profile.
2. Unable to copy SQL query from Process List in Server Monitor.
3. "Option" button was missing in the file selection window of Import Wizard.
4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to show tables in PostgreSQL 12.
2. Unable to change the Settings Location path of Navicat Cloud connections.
3. A red exclamation mark was incorrectly displayed on the Navicat Cloud query icon.
4. "Add Object Privileges" UI issue when using Dark Mode.
5. Crashed when connecting to MongoDB database.
6. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Byte type integer was default converted to bytea when importing from Access files.
2. Unable to search in menu bar / Help.
3. Unable to show the database list when there was more then 255 databases.
4. Data Transfer process was stopped in some cases.
5. Error occurred when running "select * from table1 where field1 like '%SA_%' escape '';".
6. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to list users for MariaDB 10.4.
2. Error occurred when running multiple SQL Server queries (ended with ;) in Query Editor.
3. List View was not retained in the main window after restarting Navicat.
4. The backup context menu was incorrect when the SQL Server connection was not opened.
5. "Field 'type' is currently not supported." error occurred when listing MongoDB collections.
6. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to transfer views from MySQL to MariaDB.
2. Crashed when running query in some cases.
3. Unable to use the Add Privilege button.
4. Unable to add, edit or remove users in AWS Redshift instance.
5. Connections moved out of the group after editing.
6. "Incorrect syntax near ','" occurred when importing accdb file to SQL Server.
7. Crashed when editing model in some cases.
8. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Empty tables were created when importing .accdb file.
2. Run Selected option did not run all highlighted text when using shortcut to select the SQL.
3. SSH connection dropped issue.
4. Unable to retain selected columns in Foreign Key Selection window.
5. PostgreSQL SCRAM authentication did not work properly.
6. Data Synchronization data grid UI issue in Dark Mode.
7. Data Synchronization inserted values into Generated Columns.
8. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Error occurred when connecting to MySQL 4.0.
2. Missing "Tools" menu when running an infinite loop in Console.
3. Crashed when comparing databases in Structure Synchronization.
4. Login failed when connecting to Azure SQL Database.
5. Crashed when saving models.
6. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Grid View and Form View menu options were flipped.
2. SQLite table structure cannot be modified when using an HTTP tunnel.
3. "On Update Current Timestamp" option did not reflect the settings when using ANSI_QUOTES SQL mode.
4. The row height of the object list did not match the font size.
5. Column order was incorrect when importing database to model.
6. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Improvements:

1. Enter the datetime value directly in the Filter.
2. Add a "Drop with CASCADE" option for deleting PostgreSQL objects.

Bug-fixes:

1. Crashed when opening a database in some case.
2. If the filter value box was opened, Navicat window disappeared when switching to another App.
3. Crashed when using Find feature after updating the data.
4. Crashed when code completion was triggered in large query.
5. Freeze when entering/exiting Full Screen.
6. Selected connection, database and schema names were missing in Data Transfer window.
7. "Directory" textbox became empty when creating SQL Server database.
8. Structure Synchronization was unable to create SQL Server primary or secondary XML indexes.
9. 1146 error occurred when duplicating MySQL 8.0 functions.
10. SQL Server Data Transfer was slow.
11. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to search the grouped queries unless the group was selected.
2. Crashed when using Find in Database/Schema if the connection was not opened.
3. Field comment font color issue when using Dark Mode.
4. SSH key file reselect issue when opening connection in App Store version.
5. Crashed when creating a project.
6. Beautify SQL feature wrongly split text which started with numbers.
7. Row highlight issue when using Dark Mode.
8. Crashed when opening Datetime picker window in Table Viewer.
9. Unable to show line number in SQL Editor on macOS 10.14.
10. Code Folding did not work properly in SQL Editor on macOS 10.14.
11. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Crashed when opening Navicat if logged in Navicat Cloud.
2. Unable to connect using SSH private key in some cases.
3. Hanged when saving Procedure/Function.
4. Crashed when clicking Views in some cases.
5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Mojave's Dark Mode did not display properly.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Stored procedures was not exported properly when using Data Transfer.
2. Import Wizard was slow in some cases.
3. "ORA-00922: missing or invalid option" error occurred when connecting to Oracle.
4. "Connection is in use" message prompted when restarting Navicat if connection password was not stored.
5. Crashed after Navicat was opened in a few minutes.
6. Crashed when showing Navicat Cloud Agreement.
7. Crashed when synchronizing data in MariaDB System Versioned Tables.
8. Unable to copy data from Table Viewer.
9. Code Completion did not work properly in some cases.
10. Inputted text was not displayed when renaming objects on Navigation Pane in Mojave's Dark Mode.
11. Unable to list the batch jobs in some cases.
12. Connection/Database did not open when dragging tables into it.
13. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. "<html>" tag was repeated twice when exporting HTML file.
2. Definition was missing when dumping Views and Functions.
3. Crashed when starting Navicat in some cases.
4. Foreign key data selection did not work.
5. Link connection from Oracle to SQL Server failed in some cases.
6. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. HTML export did not specify charset.
2. Fixed PostgreSQL 11 compatibility issue.
3. Unable to connect MongoDB using password with special characters.
4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Main New Features:

1. Support of MongoDB
2. Support of Roles for MySQL 8
3. Support of Roles for MariaDB 10
4. Support of Partitioned Table for PostgreSQL 10
5. Brand new Filter Wizard
6. UI and UX Improvement

To upgrade, please visit our Customer Center.

Bug-fixes:

1. The Not Null checkbox states were inverted in Oracle Table Designer.
2. Unable to rename table with double-click in some cases.
3. Sorting Rows column on the Objects tab did not work properly.
4. Command-W shortcut did not close the active window in some cases.
5. Some menu items were missing in Table Designer.
6. Export Wizard did not add a leading zero to pad days and months to two digits.

To upgrade, please visit our Customer Center.

Improvements:

1. Ability to copy comparison results of Model.
2. Added thousand separators to the row count on the table objects list.

Bug Fixes:

1. Crashed when opening Navicat if invalid characters were used for the paths in Preferences.
2. The generated CREATE PROCEDURE statement was incorrect when dumping database to SQL file.
3. Unable to execute Navicat commands using Automator.

To upgrade, please visit our Customer Center.

Improvements:

1. Supported to connect MySQL 8 using SHA2 connection.
2. Supported coloring the Objects tab when a colored connection is selected.
3. Improved table mapping in Import Wizard.
4. Improved keyboard navigation with tab key in Import Wizard.

Bug Fixes:

1. Left single quotation mark was wrong style when inputting in Form View.
2. Error occurred when deleting multiple users in SQL Server.
3. Extra "(" was added to INSERT statements when deploying scripts in Data Synchronization.
4. Objects list loading was slow in some cases.
5. Zero decimal place digits were not displayed in Table Viewer.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Incorrect SQL "ON UPDATE CURRENT_TIMESTAMP(0)" was dumped for MariaDB 5.5 tables.
2. Crashed when starting Navicat.
3. Unable to edit query results when tables had alias.
4. Exported files were not attached to the notification email.
5. Procedure Parameters was missing when synchronizing structure.
6. Unable to filter connections in the Navigation Pane.
7. Error occurred when importing data to TIMESTAMP(6) fields.
8. Profile icons did not have indicator after adding attachments in Batch Job.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Unable to copy error messages in Query.
2. Database name was added to the query when using Query Builder.
3. Unable to show the Oracle Package Body definition.
4. XML file data was not imported to JSON fields completely.
5. Unable to edit data in Query result set in some cases.
6. Adjusting the height of split screen in Table Designer was not allowed.
7. Crashed when selecting or editing Procedure SQL in Query Editor.
8. Incorrect SQL was generated when changing Primary Key name in Table Designer.
9. Query column width reset after restarting Navicat.
10. Memory leak issue.
11. "Fields" and "Referenced Fields" values were vanished after saving and moving cursor to another Foreign Key.
12. Field properties were not shown when adding a field in Table Designer.
13. Incorrect field name were shown when moving a field in Table Designer.
14. UI issue in Full Screen mode.
15. Exported Excel files were corrupted in some cases.

To upgrade, please visit our Customer Center.

Improvements:

1. Supported Microsoft Azure Database for MySQL.

Bug Fixes:

1. Unable to open Console if a non-tabbed window was opened in font.
2. Incorrect syntax error occurred when transferring SQL Server tables.
3. Added records showed wrong values until refreshing SQLite table grid.
4. Navicat hanged when refreshing table grid after changing field names.
5. Navicat process was unable to terminate.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Error occurred when synchronizing structure in some cases.
2. Enum type value returned as string in query results.
3. Exported Excel files were corrupted in some cases.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Unable to show all PostgreSQL tables.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Unable to open a table twice.
2. Running multi-statement SQLs with delimiters issue.
3. Crashed when adding default value in Table Designer.
4. Crashed when clicking the Server Privileges tab in User Designer.
5. Find feature in Table Viewer was not function correctly.
6. Target object name was garbled when copying object named with non-ascii characters.
7. Crashed when executing SQL to insert emoji to table.
8. Crashed when performing Data Transfer in some cases.
9. Navicat hanged when executing scripts in Data Synchronization.
10. Unable to show Oracle SYS.XMLTYPE type data in Table Viewer.
11. Unable to hide the Information pane permanently in Query.
12. Preferences settings reset when Navicat started.
13. Unable to stop query when using SSL connection.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Result tab was focused when explaining query.
2. Query Plan result column was too narrow in Query.
3. " " character was appended to the end of the row when copying data to text / Excel file.
4. Unable to map fields in Import Wizard.
5. Dump SQL File process was slow.
6. Create new table wrongly when importing to existing table in some cases.
7. Use old user to connect after changing new user name in Connection window.
8. Unable to import decimal values when data has thousand separator.
9. Crashed when searching on different pages in Table Viewer.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. The database/schema combo-box did not work in Query.
2. Manual refresh did not work in Server Monitor when auto-refresh was enabled.
3. Oracle connection's Service Name setting reset after re-login Navicat Cloud.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Unable to modify the Current value of Identity to 0 in Table Designer.
2. Supported refresh PostgreSQL Materialized Views with CONCURRENTLY option.
3. Information panel retained when opening Navicat.
4. Fixed importing connections with Settings Location issue.
5. Error occurred when modifying SQLite schema or data in App Store version.
6. Command-D shortcut did not open Design form when viewing View data.
7. Syntax error occurred when editing data in table with binary primary key.
8. Unable to resize the assistant editor in Table Viewer.
9. Fixed cursor focus issue in Console.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Syntax error occurred when creating MariaDB triggers in Table Designer.
2. Unable to commit the same query twice.
3. Unable to create the second filter by using context menu.
4. Unable to reload or reopen tables after connection was timeout.
5. Navicat hanged when opening large BLOB data in Hex Editor.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Save dialog prompted even no changes made in Table Designer.
2. Unable to paste Chinese in SQL Server Table Viewer.
3. Query Builder loading was slow.
4. Unable to execute query in some cases.
5. Data synchronization crashed when HTTP connection was used.
6. Crashed when dumping PostgreSQL tables to SQL files.
7. Unable to export views on High Sierra.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Error occurred when creating virtual columns in MariaDB Table Designer.
2. Table Designer UI improvements.
3. Font settings in Preferences reset to default after restarting Navicat.
4. SQL Formatting was missing in the Triggers tab of Table Designer.
5. Unable to delete fields in Table Designer.
6. View Builder button was missing in View Designer.
7. SSH connection hangs issue.
8. Objects list loading was slow.
9. Automation did not work when the profile name contained spaces.
10. Syntax error occurred when filtering with ' character in Table Viewer.
11. Unable to run DELIMITER $$ statements in Query.
12. Navicat hanged when using normal OS user account.
13. Duplicate Entry error occurred when importing with Append/Update mode.
14. Sync Username to Navicat Cloud option was missing in Connection form.
15. Navicat hanged when connection was cut off.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Auto increment field was ignored when importing
2. Unable to set the default value of TEXT/BLOB field for MariaDB 10.2.1 or above.
3. Error occurred when connecting to MariaDB in some cases.
4. System items were shown in the Import from Database window.
5. Navicat hanged when running a query export profile in some cases.
6. Window was resized when clicking the Triggers tab in PostgreSQL Table Designer.
7. Crashed when viewing or editing Functions.
8. Code completion displayed unrelated items.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Replace All did not work in Table Viewer.
2. Wrong row was inserted to when selecting foreign key value in Table Viewer.
3. Memory error occurred when transferring tables.
4. Suggested wrong table column in code completion list.
5. Context menu UI issue in some cases.
6. Tables displayed as NEW in Import Wizard even it is already existed.
7. Slow issue occurred when using code completion.
8. Server name was missing in the window title bar of Console.
9. Unable to add tables/views to Query Builder.
10. Crashed when opening SQLite connection in some cases.

To upgrade, please visit our Customer Center.

New Features:

1. New UI/UX.
2. On Startup: open favorite tabs automatically when Navicat launches.
3. Code Snippet.
4. Advanced Code Completion with better suggestions.
5. Brand new Structure Synchronization: visually show side-by-side DDL comparison between two databases.
6. Brand new Data Synchronization: show particular status to distinguish the differences between records easily.
7. New Automation: easy to find desired profiles and create automated batch jobs.
8. Responsiveness and performance improved.
9. Many other new features and improvements.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Failed to export SQLite views with alias field names.
2. Crashed when dumping certain PostgreSQL SQL statements.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Failed to save Oracle trigger changes when trigger definition is updated in Trigger Designer.
2. Crashed when transferring certain Oracle Timestamp values in Data Transfer.
3. Failed to move procedures to a virtual group.
4. Unable to create roles in PostgreSQL 9.6.
5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Unable to show errors when running query in some cases.
2. Failed to import JSON files in some cases.
3. Query Editor window has disappeared when it lost focus.
4. Failed to parse PostgreSQL rules with “DO INSTEAD NOTHING” when dumping SQL.
5. Some options were wrongly displayed in Essentials Edition.
6. Unable to save the changes in Oracle Package Body Designer.
7. Settings Location was wrongly copied when duplicating connection.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. The default date time format and delimiter of Export Wizard did not follow Import Wizard.

To upgrade, please visit our Customer Center.

Improvements:

1. Added some common keyboard shortcuts.

Bug Fixes:

1. Displayed wrong database name on PostgreSQL Console.
2. Failed to transfer tables when enabled "Convert object name" in Data Transfer.
3. Crashed when opening Query view in some cases.
4. Crashed when running backup tasks in Batch Job.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Unable to show the "Conditions" and "Commands" settings of PostgreSQL Rule in Table Designer.
2. Crashed after exporting in some cases.
3. Crashed when importing files with long field name.
4. Failed to run "LOAD DATA LOCAL INFILE" statement in Query Editor.
5. Column titles was unable to display properly in Form view when using large font size.
6. Crashed when deleting tables with relations in Diagram view.

To upgrade, please visit our Customer Center.

Improvements:

1. Support PostgreSQL 9.5 keywords in Query Editor.
2. Support utf8mb4 Character Set in MySQL and MariaDB connections.
3. Support smart quotes in Query Builder.

Bug Fixes:

1. "DATETIME" was not displayed as SQL Server keyword in Query Editor.
2. Progress bar did not update in Data Transfer.
3. Unable to expand connection tree in some case if the corresponding tab was not selected.
4. Crashed while working with a profile in a virtual group.
5. Unable to perform data synchronization using command line.
6. Crashed when inserting record with RAW mode in Table Viewer.
7. Failed to move multiple objects into a virtual group by right-click menu in Navicat Cloud connections.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Crashed when opening or closing Navicat Cloud database in some cases.
2. Unable to beautify SQL keywords to upper case in Query Editor.

To upgrade, please visit our Customer Center.

Major New Features:

Navicat Cloud Collaboration

1. Create/Modify/Delete projects.
2. Add members to project for sharing connection settings, queries and models.
3. View Project Activity Log.

PostgreSQL Objects

1. Support Foreign Server with User Mapping.
2. Support Foreign Table.
3. Support PostgreSQL Debugger.
4. Enhanced Object Designers.

Data Modeling Tool

1. Support Model Conversion.
2. Support Views.
3. Enhanced Table Designer.

Others

1. SQLite Users Management.
2. Enhanced Filter Wizard.
3. Enhanced Query Designer.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Failed to log in Navicat Cloud in some cases.
2. Crashed when running Structure Synchronization.
3. Failed to open SQL Server connections on Mac OS X 10.9 or below.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Unable to copy backup files to another database by drag and drop method.
2. Crashed when running Data Transfer more than once on OS X 10.11.
3. Froze when operating Table Viewer with longtext data.
4. Crashed when running stored procedures on OS X 10.11.
5. Template database name has not escaped when creating PostgreSQL database.
6. Crashed when adding password using MD5 function in Table Viewer Raw mode.
7. Crashed when running SQL multi times in Console.
8. Unable to login SQL Server with password contains ";".
9. Unable to set the default value of the bit type in Table Designer.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Incorrect schema name for CREATE INDEX or TRIGGER SQL for PostgreSQL in Structure Synchronization.
2. Crashed when getting table constraints due to extra constraints created by PostgreSQL extension earthdistance.
3. Showed wrong database in Connection Tree.
4. Execute SQL file did not output errors in some cases.
5. Lost local connections after Navicat crashed during synchronizing to Navicat Cloud.
6. App Store version: In-App Purchase did not work in Mac OS X 10.11.

To upgrade, please visit our Customer Center.

Improvements:

1. Supported format strings in Schedule email body.

Bug Fixes:

1. Unable to send notification email in Schedule.
2. Wrongly updated the SQL Server table identity columns in Import Wizard.
3. Created a new connection when previewing a view or a materialized view.
4. Syntax error occurred when updating SQL Server tables in Table Viewer.
5. "Database file path is not correct" error occurred when opening SQLite database files from finder.
6. Crashed when dumping SQL Server tables to a SQL file.
7. Unable to change the case of the backup file name.
8. Failed to synchronize Row Format when creating MySQL tables in Structure Synchronization.
9. Lost connections in some cases.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Unable to show error messages when saving SQL Server procedures.
2. Crashed when importing connections.
3. Error occurred when using profile to perform Data Synchronization for PostgreSQL.
4. SQL Server connection would hang when the connection was disconnected.
5. Crashed when reversing database to model.
6. Generated incorrect SQL for foreign keys when transferring Oracle tables to a SQL file.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Unable to connect PostgreSQL with password contained single quote/backslash characters.
2. Object List tab did not change when selecting nodes from connection tree.
3. Unable to synchronize or export model to SQL Azure.
4. Unable to send email when running batch jobs using Command Line.
5. Failed to save the order of connections in Navicat Cloud.
6. Unable to transfer PostgreSQL index when index field contained function.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Unable to edit BLOB field's text data on TEXT editor.
2. Error occurred when opening SQL Server 2005 and SQL Azure connections.
3. Unable to use CMD-Y New Query shortcut after selecting Tables, Views, etc nodes on Connection Tree.
4. .wal and .shm files were not deleted after closed SQLite connections.
5. Failed to create/edit users for MySQL 5.7.6.
6. Failed to run schedule for connections in Navicat Cloud.
7. Cursor did not focus on Query Editor when opening a query.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Fixed the escape character data issue for PostgreSQL tables in Data Transfer.
2. Unable to insert/update/delete money type in Table Viewer and Data Transfer for SQL Server 2000.
3. Wrongly showed MySQL/MariaDB TEXT fields with collation xxx_bin as BLOB fields in Table Viewer.
4. Fixed import DBF file with empty datetime value issue.
5. Crashed when typing "create function test (in_" in Query Editor.
6. Error occurred when opening SQL Server 2008 R2 schemas.
7. Error occurred when opening SQLite files with the same name by double-clicking the database files.

To upgrade, please visit our Customer Center.

Improvements:

1. Added the ability to copy column name with data and copy records as Insert/Update statements in Query/View Result.

Bug Fixes:

1. App Store Essentials version: Fixed unable to copy query by drag-and-drop method.
2. Fixed the SQL Azure connection hang issue.
3. Fixed the time interval setting issue in Schedule.
4. Fixed the multi headers issue when exporting multi SELECT query to XML file.
5. Fixed the warning issue when renaming query.
6. Fixed unable to handle delimiter statements issue in Execute SQL File.

To upgrade, please visit our Customer Center.

Improvements:

1. Added the ability to copy column name with data in Table Viewer.

Bug Fixes:

1. Crashed in SSH re-connection.
2. Fixed the smart quotes/dashes issue in Query Builder.
3. Fixed the data type issue when importing xlsx in Import Wizard.
4. Fixed the creation of database/schema issue when no target database/schema name provided in MySQL/MariaDB/PostgreSQL/SQLite Data Transfer.

To upgrade, please visit our Customer Center.

Improvements:

1. Show popup message if errors occur during dumping tables/databases/schemas to SQL file.

Bug Fixes:

1. Crashed when using "Reverse Database to Model" feature.
2. Crashed when the connection between server and client is disconnected.
3. Unable to scroll on long query.
4. Unable to re-send Navicat Cloud verification email.
5. Result set scrolled to line 2 after executing the query in OS X 10.10 .

To upgrade, please visit our Customer Center.

Improvements:

1. Support NTLMv2 in Windows Authentication for SQL Server.
2. Supported copy data as INSERT/UPDATE statements in Table Viewer.

Bug Fixes:

1. Wrongly changed field type varchar(400) to BLOB for MySQL version 5.0.4 or above in Data Transfer.
2. Editing data was not allowed sometimes in Table Viewer TEXT editor for MySQL/MariaDB.
3. Failed to transfer MySQL tables with trigger in Data Transfer.
4. The Lock icon position moved up under Environments tab in Preferences.
5. Failed to save SID/Service type for Oracle connection after quitting Navicat.
6. Unable to copy data of unknown SQLite field type in Table Viewer.
7. Error occurred when changing the case of the connection name.
8. Crashed when importing database/schema to Model.
9. Crashed when creating Navicat Cloud account.
10. Wrongly applied "Use smart quotes and dashes" setting in Console.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Unable to execute Data Transfer profiles in Batch Job.
2. Navicat Cloud login checking restriction.
3. The Select/Where/Group By/Having/Order By clasue bar disappeared in Query/View Builder.
4. Crashed when saving profiles.
5. Failed to import date time field and float number from DBF files..
6. Select fields panel in Table Designer did not update after the table was saved.
7. INT type values were rounded up when importing XLS files.
8. Table Designer view was not displayed corrently in HTTP connections.

To upgrade, please visit our Customer Center.

Improvements:

1. Customized column width and column order in Table Design are saved.

Bug Fixes:

1. Failed to run Backup Server jobs for cloud connections in Schedule.
2. PostgreSQL JSON type data was unable to show in Table Text Editor.
3. Generated wrong query for field name with "." in Filter Wizard.
4. Crashed when removing connection from a virtual group.
5. Unable to save the Word Wrap setting in Table Text Editor.
6. Crashed when creating a new virtual group in fresh installed Navicat.
7. Connection list did not refresh automatically after dragging connections between Navicat Cloud and My Connections.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. App Store Full version: Wrongly changed referenced schema after altered foreign key's referenced schema, table and fields in Table Design.
2. The Object list could not display properly in Navicat main window.
3. Failed to import all records from xls/xlsx files in Import Wizard.

To upgrade, please visit our Customer Center.

New Features:

1. Support to sync selected connection settings, queries, model files and virtual group information to Navicat Cloud. For more information, please visit here.

Improvements:

1. Support PostgreSQL 9.3 Materialized View.
2. Support adding shapes in Model.
3. Added Show in Finder feature for Query, Backup and Model.
4. Added Open with External Editor feature for Query.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Crashed when adding foreign key under Table Designer in Data Modeling Tool.
2. Crashed when running delimiter statement in MySQL Query Viewer.
3. Crashed when opening a SQLite table which contained a self referenced foreign key without the referenced field.
4. Paging buttons did not work after applied sorting in PostgreSQL/SQL Server Table Viewer.
5. The schema name of inherited table not showed correctly in PostgreSQL Table Designer.

To upgrade, please visit our Customer Center.

Improvements:

1. Support length of SSH password/private key passphrase increased from 99 to 255.
2. Support to save name with "/" for Connection Save Path, Query, Import/Export/Backup profile, Backup, Schedule, Model, Data Transfer/Synchronization profile.
3. Support syntax "ON UPDATE CURRENT_TIMESTAMP" and default value "CURRENT_TIMESTAMP" for datetime type (since MySQL 5.6.5) in Table Designer.

Bug Fixes:

1. Crashed after opening Navicat for long time.
2. Crashed when prompted to input password for SSH connection in Data Transfer, Data/Structure Synchronization and Server Monitor.
3. Reduced the time needed to wait for connection timeout when disconnected to server.
4. Non-ASCII characters not able to show in Hex Editor under Table Viewer.
5. Some operations in main window did not popup error when error occurred.
6. Time in Schedule tab for existing event did not show in MySQL Event Designer.
7. When generated update query, identity column did not skip in Import Wizard.
8. Crashed when modifying an MySQL/MariaDB error view.
9. Website version: "SSH:Unknown Error!" error occured if doing any further action for SSH connection.
10. Website version: "Bad Private Key" error occured for SSH with private key connection.
11. SQL Azure Table Viewer would hang when refreshing after idled for around 10 mins.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Crashed when copied and pasted a new row and committed the changes by clicking the "tick" button in Table Viewer.
2. Crashed when exporting empty string for SQLite unknown type field.
3. Export Wizard window did not show up for exporting query results.
4. The title in Console window did not update into newly changed connection name.
5. When typing single/double quote in Console, the quote would be changed into other char that did not recognized by server.

To upgrade, please visit our Customer Center.

Improvements:

1. Update SQLite to 3.8.4.
2. Allow drag to reorder field as default in Table Designer.
3. Allow customization for PostgreSQL Index and Trigger items in tool bar.

Bug Fixes:

1. Connection password was unable to be saved.
2. The database names were truncated and the right half of the list was completely empty under advanced connections list in MySQL/PostgreSQL Connection Properties.
3. The state of running in full screen was unable to be saved, so that Navicat only started up in window mode.
4. Error message occured while viewing table structure to show the file path.
5. Default value '''' turned into ''' in MySQL Table Designer.
6. Disabled the vertical elastic effect to avoid wrong colour drawing for row index < 0 in Table Viewer.
7. The result dataset did not show warning messages for unknown type query in SQL Server Query Viewer.
8. Crashed when getting Oracle Materialised View.
9. When previewed and enabled save queries to file, queries were not correctly written to the file in Data Synchronization.
10. The file and file size position in Model info view were wrong.
11. Crashed when right-clicked on an open area and seleted "Restore Backup".
12. The bookmark setting of saved path was incorrect in Backup schedule.

To upgrade, please visit our Customer Center.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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 Navicat Premium 15.0.24激活 Users.
4. Server Monitor.

Download here