Versionshinweise

Bug-fixes:

1. Unable to save changes after updating foreign key names in the model.
2. Scrolling skipped two rows in the data viewer.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Crashed when connecting using SSH tunnel in some cases.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Main New Features:

1. Support AI Assistant
2. Data Modeling supports Data Vault and Dimensional modeling methods
3. BI data source supports data profiling
4. Filter & Sort pane in Table Viewer supports Text mode
5. Some minor bug fixes and usability improvements

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Error occurred when saving changes in PostgreSQL Function.
2. Crashed when reversing PostgreSQL schema to model.
3. Undoing changes in a function incorrectly cleared all code.
4. Time values imported from Access database were incorrect.
5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. The "New Table" column was empty when dragging and dropping a file to import.
2. Access Violation error occurred when copying procedure results.
3. 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. PostgreSQL timestamp data were exported incorrectly.
2. Crashed when backing up PostgreSQL schema in some cases.
3. "ERROR: more than one row returned by a subquery used as an expression" error occurred when opening PostgreSQL tables.
4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to backup with Automation.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Multi-line editing did not work in Query Editor.
2. Crashed when deleting "My Connections".
3. Crashed when copying UPDATE statements from query results.
4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Crashed when sorting data.
2. Incorrect database name assigned when using "Synchronize Database To Model".
3. "Invalid Stored Procedure Syntax" error occurred when saving PostgreSQL functions.
4. Unable to change primary key name.
5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to display Chinese characters in the bookmark outline of the data dictionary PDF file.
2. Unable to import Access file when 32-bit Office installed.
3. The Fields pane always displayed when opening table.
4. Incorrect CREATE INDEX statement was displayed in the DDL pane.
5. Column sizes did not persist when refreshing table.
6. Crashed when using "Filter & Sort".
7. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Response was slow when hovering over the menu bar.
2. Crashed when starting Navicat in some cases.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to import all records from a file in some cases.
2. 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 Profile
7. Navicat URI
8. Manage Connection
9. Enhanced BI Feature
10. Focus Mode
11. Support Alibaba Cloud PolarDB for PostgreSQL
12. Many other new features and improvements

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to show data in some cases.
2. Unable to connect PostgreSQL in some cases.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Crashed when PostgreSQL connection was lost.
2. Primary key index incorrectly displayed when data type was citext.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Importing data to Redshift was slow.
2. Crashed when importing paradox files.
3. Failed to import JSON file from web service.
4. Unable to transfer data from Redshift.
5. Refresh button did not work in Server Monitor.
6. Some labels disappeared after adding the chart to the dashboard.
7. Unable to display proportion percentages in the chart axis.
8. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. The percentage values shown in the chart were incorrect.
2. Not all data was imported when scheduling import.
3. Unknown Internal Error occurred when importing data.
4. The comment code shortcut did not work in some cases.
5. Unknown Internal Error occurred when transferring data.
6. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Improvements:

1. Support enabling or disabling "Detect Data Types" in Import Wizard.
2. Support ssh agent using pageant unix mode.

Bug-fixes:

1. Primary keys were not displayed for PostgreSQL partitioned tables.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to show the privileges of "public" in PostgreSQL Privilege Manager.
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. Crashed when opening Charts workspaces in some cases.
2. Crashed when scheduling import jobs.
3. Missing records when importing files in some cases.
4. Special characters were garbled when using double-click to add a snippet to the query.
5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Crashed when importing Access files.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Improvements:

1. Auto guess field types when importing xlsx files.

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. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Incorrectly triggering code completion when pressing ENTER in Query Editor.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to close tabs in some cases.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Main New Features:

1. Show fields, indexes and more under tables in Navigation Pane.
2. Minor bug fixes and improvements.
3. Navicat for Redis is released.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. High CPU usage when using SSH connection.
2. "permission denied for view geometry_columns" error occurred when opening PostgreSQL table.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Query Builder window was larger than the screen in some cases.
2. Unable to display full server output in Query's Message tab.
3. Modifying PostgreSQL table with a geometry field and no primary key did not take effect.
4. Unable to display the data differences of TEXT fields in Data Synchronization.
5. The second field was selected when adding a sort condition in Table Viewer.
6. Crashed when stopping Data Transfer process.
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. Memory utilization issue.
2. Modification did not take effect on tables with geometry fields and no primary key.
3. Table Viewer did not show the SQL if errors occurred.
4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to save changes after deleting a cell value in Table Viewer.
2. Access violation error occurred when opening a model.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Improvements:

1. Support the PARALLEL option for PostgreSQL functions.

Bug-fixes:

1. Cannot display column comment when mouse over in dark mode.
2. Missing $$ quotes in PostgreSQL function definition.
3. Data Synchronization did not work in Automation.
4. "Failed to send mail. Stream error." occurred when sending email.
5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. "Cannot open source table" error occurred when using Condition Query in Import Wizard.
2. Exporting to Excel file was slow.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Failed to transfer large tables.
2. Crashed when batch querying tables with FK dependency.
3. Unknown Internal Error occurred when exporting large amount of data.
4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Main New Features:

1. Support Trend Line for several chart types.
2. Support adding On-Prem Server with URI.
3. Allow skip preview of changes in data sync.
4. Enhanced responsiveness and performance.
5. Improved UI/UX.
6. 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. Double foreign key lines were printed when exporting a model to a PDF file.
2. Access violation error occurred when searching in the Backup's Object Selection tab.
3. No data value on the label when exporting a chart to a PDF file.
4. Unable to rename a view inside a group in Navicat Cloud.
5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Improvements:

1. Support tunneling on PHP 8.

Bug-fixes:

1. Unknown Internal Error occurred when importing Excel file in some cases.
2. An empty string was not quoted when exporting to a text file.
3. Query was garbled when the system locale set to Japanese.
4. Export/Import profile did not work if it was copied to Desktop.
5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Empty rows were added when exporting more than 1.05 M records to Excel file.
2. Error occurred when using Recordset Generator to generate a record set for the Date field.
3. Hanged when designing a table with many fields.
4. Relation lines were disappeared after saving and reopening Logical Model.
5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. ER diagram was reloaded when clicking the Design Table button.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Incorrect CREATE INDEX statements were generated when comparing PostgreSQL model.
2. Error occurred when debugging PostgreSQL functions.
3. Unable to change the owners of PostgreSQL functions.
4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to change the label text color in Report's header.
2. Incorrect Foreign Key ALTER statements were generated when synchronizing PostgreSQL table structures.
3. Notification email subject was incorrect when the job finished unsuccessfully.
4. Cursor focusing issue when using Find feature in Table Viewer.
5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Queries cannot be displayed when "Settings Location" was set to a network path.
2. Error 80041318 occurred when setting schedule .
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Flashed in dark mode.
2. "Unallowed argument in list..." error when running export / import schedule.
3. Error occurred when modifying the value in a DateTimeOffset field.
4. Unable to load version 10 data synchronization profiles.
5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to import MEMO data from DBF files.
2. Unable to reconnect SSH connection after the PC woke up.
3. Crashed when setting multiple cells to NULL in Table Viewer.
4. Incorrect PostgreSQL function definition was displayed in some cases.
5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to show records that had -1 data in Table Viewer.
2. "Drop target objects before create" option did not work in Data Transfer.
3. Memory leak issue when enabled code completion.
4. "Relation does not exist" error occurred when debugging a function in a schema other than the "public" schema.
5. "Unknown Internal Error (A70529211102SE)" error occurred when exporting / importing data.
6. Slow issue when transferring large tables.
7. Unable to show the inputted text in Filter Wizard.
8. Error occurred when filtering data by right-clicking a cell in Table Viewer.
9. "Cannot insert into column" error occurred when transferring PostgreSQL tables.
10. Inserted records to the wrong table when transferring data to the target table with a different name.
11. "Debugger Plugin is not installed or enabled" error occurred when the extension was installed in another schema.
12. "COMMENT ON FUNCTION" clause was mistakenly generated when synchronizing PostgreSQL procedures.
13. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Differences were detected when re-comparing the model and the database.
2. Unable to synchronize large ndm2 model files to Navicat Cloud.
3. Drop-down list was blank in Table Designer.
4. Unable to scroll after switching the query results to Form view.
5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Improvements:

1. Integer column exported in Number format when exporting Excel file.
2. Display export profiles in the same group of queries.

Bug-fixes:

1. The fields of PostgreSQL compound index were displayed incorrectly.
2. Unable to show index fields in PostgreSQL 9.0 .
3. Unable to set data to NULL in query results.
4. Crashed when clicking the ellipsis button in Custom Recordset.
5. Pasting data into a column cleared another column data.
6. Default Settings Location path was set to a wrong location for some cases.
7. "Floating point division by zero" error occurred when setting the dashboard background.
8. The file extension was missing when exporting the dashboard.
9. Query Parameter did not work when using a parameter twice.
10. "Invalid floating point operation" error occurred when adding NULL data to the chart.
11. Incorrect columns were displayed after clicking the Default button in the "Choose columns" window
12. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to set the identity seed and increment in PostgreSQL models.
2. Unable to export data to .mdb files.
3. 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. Query wrongly returned null results in some cases.
2. Unable to update bit type data.
3. Datetime format issue when exporting to Excel files.
4. Query Results Text pane appended values of the selected cells.
5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Crashed when running COPY XXX FROM STDIN query.
2. Wrong options were selected when loading another Data Transfer profile.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. "Unknown Internal Error" occurred when debugging PostgreSQL functions.
2. Unable to list external tables when connecting to Redshift.
3. Down arrow key did not highlight table grid cell in some cases.
4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Failed to update records in table viewer.
2. "Input profile is invalid" error occurred when opening export query profiles.
3. Tab was exported instead of "," when scheduling to export CSV files.
4. Automation was failed when scheduling export profile and import profile.
5. Unable to copy and paste "," comma decimal separator.
6. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Export process was slow.
2. Error occurred when editing Stored Aggregate Functions.
3. Unable to restore tables that included "pg_catalog"."name" type.
4. Unable to dump the default value of TIMESTAMP field.
5. Synchronize to Database feature wrongly detected differences of unique constraints.
6. Unable to show multiple values for list partitioning in PostgreSQL partition table.
7. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Copy and paste data issue in Table Viewer.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Code Completion did not work in some cases.
2. Unable to import signed numbers when there was spaces between the sign and the number.
3. A double quote was added to the JSONB column index (PostgreSQL).
4. Unable to map a source field to multiple target fields in Import Wizard.
5. "Synchronize to Database" incorrectly detected differences for unique constraints (PostgreSQL).
6. "Cannot open file" error occurred when scheduling export profiles in some cases.
7. Unable to show empty fields in query result sets.
8. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. "syntax error at end of input" error occurred when running CREATE RULE statement in Query Editor.
2. "Unknown Internal Error" occurred when opening Table Designer.
3. "syntax error at or near "VERBOSE"" occurred when using Vacuum Analyze on PostgreSQL 11 tables.
4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Text editor did not display the full text in some cases.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to execute SQL files that contain "NaN" values.
2. Primary Key checkbox was deselected when tabbing to the next field in Table Designer.
3. "Unknown Internal" error occurred when importing data.
4. The DDL of PostgreSQL tables with "tstzrange" data type was incorrect.
5. The deployment scripts generated incorrect default value in Structure Synchronization.
6. "Access Violation" error occurred after editing the data pipeline in Report.
7. "Unknown Internal" error occurred when using Automation.
8. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Query result pane size did not retain after minimizing the window.
2. Paradox tables cannot be imported.
3. Unknown Internal error occurred when importing data.
4. Column order was incorrect when importing database to model.
5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. "Replace All" button was unable to replace the last occurrence in Query Editor.
2. Code completion suggestion list did not show on the same screen as the editor.
3. A table was mistakenly transferred even it was not selected.
4. Incorrect syntax highlighting issue in Query Editor.
5. Filter criteria input box was not retained when switching applications.
6. Drag and drop selected text on Query Editor did not move the text.
7. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Improvements:

1. Add a "Drop with CASCADE" option for deleting PostgreSQL objects.

Bug-fixes:

1. Code completion box displayed off the bottom of the screen and partially obscured.
2. Unable to customize query result tab name by using /*NAME:XYZ*/ .
3. Boolean or BIT(1) values importing, exporting and transferring issue.
4. Copying table field names in Table Designer was slow.
5. Table Form view was unable to show jpg images.
6. Unable to import data when using Append/Update mode.
7. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. SQL order issue in Structure Synchronization.
2. Console window was not colored when connection coloring were set.
3. Unable to save PostgreSQL function in some cases.
4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Main New Features:

1. Support of Partitioned Table for PostgreSQL 10
2. Brand new Filter Wizard
3. UI and UX Improvement
4. MongoDB is added in Navicat Premium
5. Navicat for MongoDB is released

To upgrade, please visit our Customer Center.

Bug Fixes:

1. File encoding was incorrect when transferring database to SQL file.
2. Structure Synchronization detected differences after synchronizing.
3. Incorrect unique values were imported from .dbf file.
4. Crashed when saving the modified field names in some cases.
5. Extra "(" was added to INSERT statements when deploying scripts in Data Synchronization.
6. Foreign keys were not transferred when transferring tables from MySQL to SQLite.
7. .ndm file association was not worked.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. 80041318 error occurred when saving a task schedule.
2. The cursor position row moved to the bottom line after saved the procedure/function.
3. "XXX is not a valid value" error occurred when editing a PostgreSQL model table in some cases.
4. Transaction did not end after closing the table in some cases.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Zero decimal place digits were not displayed in Table Viewer.
2. Exported SQL file did not have table name when exporting an unsaved query.
3. The privileges of PostgreSQL functions with parameters were not visible in Privilege Manager.
4. Unknown Internal Error occurred when importing from ODBC.
5. Incorrect dates were exported when exporting PostgreSQL tables to Excel files.
6. Syntax error occurred when importing CSV files in some cases.
7. Database names were missing in the Drop SQL generated by Structure Synchronization.
8. Unable to change the Tab Width in Query Editor.
9. Unable to edit query results when tables had alias.
10. Procedure parameters were missing in the scripts generated by Structure Synchronization.
11. Unknown Internal Error occurred when Automation ran.
12. Unable to transfer tables with HEX format.
13. Default parameter syntax was stripped after saving PostgreSQL function.
14. Syntax error occurred when creating PostgreSQL function with array parameters.
15. Encoding issue of the exported text file.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. "Access Violation" error occurred when creating new connections in fresh installed Navicat.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Unable to create a query inside a group.
2. The color of function keywords did not change according to the Font Color settings in Options.
3. Column width did not retain after hide and show the column in Table Viewer.
4. Unable to drag and drop a query into a group in some cases.
5. Unable to edit query results in some cases.
6. Unable to disable Foreign Key constraint in Data Synchronization.
7. Crashed when dumping table to sql file in some cases.
8. Foreign Key constraint issue in Import Wizard.
9. Code completion replaced the text after caret.
10. Exported files or reports were not attached to the notification email.
11. Keepalive Interval setting attempted to connect continuously even the database was down.
12. If a query was opened, abnormal behavior happened when closing Navicat.
13. Automation did not start when the computer was logged out.

To upgrade, please visit our Customer Center.

Improvements:

1. Supported creating PostgreSQL 10 Models.

Bug Fixes:

1. RAISE NOTICE events did not show in Message Log.
2. Spaces were missing in the SQL exported from Model.
3. Extra newlines were added to the SQL exported from Model.
4. Unable to change the comment of PostgreSQL functions with named parameters.
5. "Hourly" option was missing on Task Schedule's Trigger tab.
6. Wrong datestamp was appended to the exported files.
7. Slow issue when searching in Table Viewer.
8. Unable to move functions into a group.
9. Unable to select Enum data in query results.
10. "Invalid byte sequence for encoding" error occurred when opening PostgreSQL tables.
11. Target functions/procedures were not dropped before create when synchronizing structure.
12. Unable to synchronize models/queries in Navicat Cloud.
13. Exported Excel files were corrupted in some cases.
14. "Access is denied" error occurred when setting schedule.

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. Error occurred when exporting with Time field type.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Cannot to show PostgreSQL large decimal data properly in Table Viewer.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Crashed when using Query in some cases.
2. Query auto-save feature did not work in some cases.
3. Debugger did not work for PostgreSQL 8.3 to 9.0.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Unable to move PostgreSQL function with special parameter to virtual group.
2. Minor bug fixes and improvements.

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. Enhanced Connection Coloring.
2. Search database object structure.

To upgrade, please visit our Customer Center.

Improvements:

1. Supported PostgreSQL 9.5.

Bug Fixes:

1. Exported result incorrect for TIME field type in Export Wizard.
2. File name with appended timestamp issue in Export Wizard.
3. Unable to synchronize BIT fields for PostgreSQL tables in Data Synchronization.
4. Slow performance when showing/hiding column with Memo editor opened.
5. SSH protocol error issue.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Generated object SQL identifier without escaping quote characters in Model.
2. Unable to load the virtual group settings file created by old versions of Navicat.
3. After sorted a selected column in Table Viewer, access violation occurred when resizing column width.

To upgrade, please visit our Customer Center.

Improvements:

1. Reset the field length to default value after changing the auto guessed field type in Table Designer.

Bug Fixes:

1. Access violation error occurred when entering SQL in Query.
2. Unable to download source files with HTTPS connection in Import Wizard.

To upgrade, please visit our Customer Center.

Improvements:

1. Improved the Message Log information.

Bug Fixes:

1. Failed to generate PostgreSQL index field clause in Structure Synchronization.
2. Unable to drop columns for PostgreSQL View in View Designer.
3. Unable to identify equality of trigger definitions with different system line breaks in Structure Synchronization.
4. Unable to convert object names in Data Transfer when using Schedule.

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 parameter in Report command line.
3. Support adding shapes in Model.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Crashed when attempting to create a new model.
2. Crashed when using the reverse database feature.
3. Pressing Shift-Command-N filled in every cell with "n".
4. Unable to save passwords in connections.
5. Inserting a column or refreshing the view did not function as expected.
6. The source file name was not displayed in the import wizard.
7. Data Synchronization over SSH was failed in some cases.
8. Printing model did not function as expected.
9. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Syntax error occurred during data synchronization via HTTP tunnel.
2. Unable to activate the Find bar in the DDL pane when the table viewer tab was focused.
3. "Convert object name to" did not work in Data Transfer.
4. Hanged when using Data Transfer or Dump SQL File.
5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Crashed when adding a new user.
2. Missing options for virtual types in Table Design.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Main New Features:

1. Support AI Assistant
2. Data Modeling supports Data Vault and Dimensional modeling methods
3. BI data source supports data profiling
4. Filter & Sort pane in Table Viewer supports Text mode
5. Some minor bug fixes and usability improvements

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to import data from ODBC in some cases.
2. Display columns reset after refreshing data grid.
3. Error occurred when saving changes in PostgreSQL Function.
4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Cannot retain object positions in ER diagram after reopening the connection.
2. Cannot view long conditions and add new conditions in Filter.
3. Unable to reload external files when changes are detected.
4. Unable to search in History Log.
5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to create PostgreSQL partition tables in Model.
2. Unable to show queries in Data Synchronization's Messages Log.
3. Wrong table data was shown in the Compare step of Data Synchronization.
4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to backup with Automation.
2. Crashed when finding data in query results.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Time delay when reporting errors.
2. Wrongly displayed German in UI.
3. 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 copy multiple columns in the data viewer.
2. Lost focus when updating row value.
3. Unable to open database connection after VPN disconnected/reconnected.
4. 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 Profile
7. Navicat URI
8. Manage Connection
9. Enhanced BI Feature
10. Focus Mode
11. Support Alibaba Cloud PolarDB for PostgreSQL
12. 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. Crashed when transferring PostgreSQL data in some cases.
2. The screen scrolled to the left after refreshing the data in Data Viewer.
3. 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. Unable to connect using ssh agent in some cases.
4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Crashed when closing Server Monitor.
2. Crashed when switching tabs on Information Pane.
3. The percentage values shown in the chart were incorrect.
4. 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. 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. Crashed when transferring large tables using SSH connection.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Crashed on macOS 14.
2. 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. 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.

Main New Features:

1. Show fields, indexes and more under tables in Navigation Pane.
2. Minor bug fixes and improvements.
3. 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. Crashed when importing database to model in some cases.
3. Crashed when saving table after changing field comment.
4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Memory utilization issue.
2. 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. Unable to load cloud connection info when opening data transfer profile.
3. 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.

Main New Features:

1. Support Trend Line for several chart types.
2. Support adding On-Prem Server with URI.
3. Allow skip preview of changes in data sync.
4. Enhanced responsiveness and performance.
5. Improved UI/UX.
6. 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 hovering over tabs.
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. 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. 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. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to show the cursor when editing TEXT data using Form View in Dark Mode.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Crashed when running query in some cases.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Crashed when adding a trigger to PostgreSQL model.
2. Crashed when using Data Transfer in some cases.
3. Cursor did not focus to the Search box after pressing CMD-F.
4. Crashed when selecting the "Group by Object Type" in Structure Synchronization.
5. 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. 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 sort by clicking the column header in Table Viewer.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Crashed when modifying PostgreSQL permissions.
2. Data Synchronization UX issue.
3. 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. The modified dates of backup files were incorrect.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Only the last selected table was printed when printing multiple tables.
2. The SQL Editor was flickered and repainted when saving the query.
3. Crashed when using Query Builder on Big Sur.
4. 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. The Maintain options did not work in Navicat for PostgreSQL.
4. Crashed when opening/testing a connection after changing "Settings Location" to a folder in Documents.
5. "Dump SQL File" stopped running in some cases.
6. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Schedule did not trigger when using Navicat App Store version.
2. The "Close Database" option in the context menu was dimmed when a query tab was focused.
3. The entire connection tree was collapsed when searching.
4. Crashed when deleting a data source in Charts.
5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Improvements:

1. Improvement on resizing Information pane.

Bug-fixes:

1. No records were imported in some cases when Import Wizard displayed "Finished Successfully".
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to show full table names in the Data Synchronization window.
2. Field names in the Join dialog were truncated.
3. 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. Jumped to the first record when refreshing in Form View.
2. The list of the reference tables for foreign key was empty in Model.
3. 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.

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. Minor bug fixes 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. 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. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. List View was not retained in the main window after restarting Navicat.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Crashed when running query in some cases.
2. Unable to use the Add Privilege button.
3. Unable to add, edit or remove users in AWS Redshift instance.
4. Connections moved out of the group after editing.
5. Crashed when editing model in some cases.
6. 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. 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 "Tools" menu when running an infinite loop in Console.
2. Crashed when comparing databases in Structure Synchronization.
3. Crashed when saving models.
4. 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. The row height of the object list did not match the font size.
3. Column order was incorrect when importing database to model.
4. 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. 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.

Main New Features:

1. Support of Partitioned Table for PostgreSQL 10
2. Brand new Filter Wizard
3. UI and UX Improvement
4. MongoDB is added in Navicat Premium
5. Navicat for MongoDB is released

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to rename table with double-click in some cases.
2. Sorting Rows column on the Objects tab did not work properly.
3. Command-W shortcut did not close the active window in some cases.
4. Some menu items were missing in Table Designer.
5. 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. Unable to execute Navicat commands using Automator.

To upgrade, please visit our Customer Center.

Improvements:

1. Supported coloring the Objects tab when a colored connection is selected.
2. Improved table mapping in Import Wizard.
3. 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. Extra "(" was added to INSERT statements when deploying scripts in Data Synchronization.
3. Objects list loading was slow in some cases.
4. Zero decimal place digits were not displayed in Table Viewer.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Crashed when starting Navicat.
2. Unable to edit query results when tables had alias.
3. Exported files were not attached to the notification email.
4. Unable to filter connections in the Navigation Pane.
5. Error occurred when importing data to TIMESTAMP(6) fields.
6. 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. XML file data was not imported to JSON fields completely.
4. Unable to edit data in Query result set in some cases.
5. Adjusting the height of split screen in Table Designer was not allowed.
6. Crashed when selecting or editing Procedure SQL in Query Editor.
7. Incorrect SQL was generated when changing Primary Key name in Table Designer.
8. Query column width reset after restarting Navicat.
9. Memory leak issue.
10. "Fields" and "Referenced Fields" values were vanished after saving and moving cursor to another Foreign Key.
11. Field properties were not shown when adding a field in Table Designer.
12. Incorrect field name were shown when moving a field in Table Designer.
13. UI issue in Full Screen mode.
14. Exported Excel files were corrupted in some cases.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Unable to open Console if a non-tabbed window was opened in font.
2. Navicat hanged when refreshing table grid after changing field names.
3. Navicat process was unable to terminate.

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. Crashed when dumping certain PostgreSQL SQL statements.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Failed to move procedures to a virtual group.
2. Unable to create roles in PostgreSQL 9.6.
3. 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. Settings Location was wrongly copied when duplicating connection.

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. Enhanced Filter Wizard.
2. 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.

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. Crashed when running stored procedures on OS X 10.11.
4. Template database name has not escaped when creating PostgreSQL database.
5. Crashed when running SQL multi times in Console.

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. Created a new connection when previewing a view or a materialized view.
3. Unable to change the case of the backup file name.
4. Lost connections in some cases.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Crashed when importing connections.
2. Error occurred when using profile to perform Data Synchronization for PostgreSQL.
3. Crashed when reversing database to model.

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 send email when running batch jobs using Command Line.
4. Failed to save the order of connections in Navicat Cloud.
5. 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. Unable to use CMD-Y New Query shortcut after selecting Tables, Views, etc nodes on Connection Tree.
3. Failed to run schedule for connections in Navicat Cloud.
4. 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. Fixed import DBF file with empty datetime value issue.

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 time interval setting issue in Schedule.
3. Fixed the multi headers issue when exporting multi SELECT query to XML file.
4. Fixed the warning issue when renaming query.

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.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to restore from backup.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Main New Features:

1. Support AI Assistant
2. Data Modeling supports Data Vault and Dimensional modeling methods
3. BI data source supports data profiling
4. Filter & Sort pane in Table Viewer supports Text mode
5. Some minor bug fixes and usability improvements

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Error occurred when saving changes in PostgreSQL Function.
2. Unable to access PostgreSQL Sequence.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Model workspaces created by Windows version cannot be saved using Linux version.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to scroll horizontally using mouse in data grid.
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. Crashed when closing tabs in some cases.
2. Incorrect CREATE INDEX statement was displayed in the DDL pane.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to open database connection after VPN disconnected/reconnected.
2. Crashed when starting Navicat in some cases.
3. 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 Profile
7. Navicat URI
8. Manage Connection
9. Enhanced BI Feature
10. Focus Mode
11. Support Alibaba Cloud PolarDB for PostgreSQL
12. Linux ARM Version
13. Many other new features and improvements

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Primary key index incorrectly displayed when data type was citext.
2. Some labels disappeared after adding the chart to the dashboard.
3. Unable to display proportion percentages in the chart axis.
4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. The SQL scripts generated for PostgreSQL models were incorrect in some cases.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Improvements:

1. Support enabling or disabling "Detect Data Types" in Import Wizard.

Bug-fixes:

1. Primary keys were not displayed for PostgreSQL partitioned tables.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. PostgreSQL Table Designer did not recognize primary keys.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Crashed when using Structure Synchronization.
2. Crashed when changing data display in Charts.
3. 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. Beautify SQL incorrectly added spaces between the function name and parentheses.
2. Unable to set table inheritance for PostgreSQL in Model.
3. Dump SQL File did not correctly generate DEFAULT PARTITION.
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.

Main New Features:

1. Show fields, indexes and more under tables in Navigation Pane.
2. Minor bug fixes and improvements.
3. Navicat for Redis is released.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. High CPU usage when using SSH connection.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Memory utilization issue.
2. Table Viewer did not show the SQL if errors occurred.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Filter value was not highlighted in the pop up window.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to copy field names in Table Designer.
2. Unable to open Comment window in Table Designer.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Main New Features:

1. Support Trend Line for several chart types.
2. Support adding On-Prem Server with URI.
3. Allow skip preview of changes in data sync.
4. Enhanced responsiveness and performance.
5. Improved UI/UX.
6. 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. Unable to launch Navicat after upgrading the system to use GLib-2.70.0 .
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Crashed when viewing or adding emoji data.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. The Stop button did not work when processing deletion in the table viewer.
2. Error occurred when editing data in query results.
3. 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. Crashed when the query returned a large result set.
2. Not all matching data was highlighted when searching the query results.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Crashed when working with PostgreSQL.
2. Crashed after refreshing the table.
3. Unable to set privileges for PostgreSQL functions.
4. Crashed when importing PostgreSQL database to the model.
5. Hanged when dragging a table from the main window to the model window.
6. Incorrect default field size issue in Table Designer.
7. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. CTRL+R shortcut did not apply the filter.
2. Unable to view TEXT data in Data Synchronization.
3. Unable to show the input text in Table Viewer when using Dark Mode.
4. Missing the primary key warning in Table Viewer.
5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to export the fractional part when the decimal separator was comma.
2. Unable to select privileges in the "Add Privilege" window by using the Space key.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Crashed when restoring the backup file to another database.
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. Crashed when using Charts in some cases.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. The number of processes was missing in the Server Monitor window.
2. Unable to delete multiple fields in Table Designer.
3. The tab of Table Designer did not mark with * after deleting a field.
4. Some buttons were disabled at all times in New Query.
5. Unable to copy and paste multiple rows data to another table.
6. Right-clicking a row header in data grid highlighted the corresponding column.
7. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Crashed when editing functions.
2. No server, database and schema were selected when opening query.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. An empty diagram was created when reversing a database to a model.
2. Unable to change font for Editor and Records.
3. Query returned different results for an empty row.
4. DROP DEFAULT clause was incorrectly added to the statement when opening PostgreSQL table designer.
5. Unable to copy the selected text with shortcut in Console.
6. Crashed when importing tables to a model.
7. Unable to add a table to the model using the mouse.
8. Delay when pasting with CTRL+V.
9. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Crashed when synchronizing Navicat Cloud on Ubuntu OS.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. CTRL+Z, CTRL+Y, ESC shortcuts did no work when editing table columns.
2. Unable to copy variables in Server Monitor.
3. Unable to copy and paste views to other databases.
4. Unable to copy and paste indexes in Table Designer.
5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

New Features:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Crashed when running COPY XXX FROM STDIN query.
2. Wrong options were selected when loading another Data Transfer profile.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. "Unknown Internal Error" occurred when debugging PostgreSQL functions.
2. Unable to list external tables when connecting to Redshift.
3. Down arrow key did not highlight table grid cell in some cases.
4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Failed to update records in table viewer.
2. "Input profile is invalid" error occurred when opening export query profiles.
3. Tab was exported instead of "," when scheduling to export CSV files.
4. Automation was failed when scheduling export profile and import profile.
5. Unable to copy and paste "," comma decimal separator.
6. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Export process was slow.
2. Error occurred when editing Stored Aggregate Functions.
3. Unable to restore tables that included "pg_catalog"."name" type.
4. Unable to dump the default value of TIMESTAMP field.
5. Synchronize to Database feature wrongly detected differences of unique constraints.
6. Unable to show multiple values for list partitioning in PostgreSQL partition table.
7. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Copy and paste data issue in Table Viewer.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Code Completion did not work in some cases.
2. Unable to import signed numbers when there was spaces between the sign and the number.
3. A double quote was added to the JSONB column index (PostgreSQL).
4. Unable to map a source field to multiple target fields in Import Wizard.
5. "Synchronize to Database" incorrectly detected differences for unique constraints (PostgreSQL).
6. "Cannot open file" error occurred when scheduling export profiles in some cases.
7. Unable to show empty fields in query result sets.
8. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. "syntax error at end of input" error occurred when running CREATE RULE statement in Query Editor.
2. "Unknown Internal Error" occurred when opening Table Designer.
3. "syntax error at or near "VERBOSE"" occurred when using Vacuum Analyze on PostgreSQL 11 tables.
4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Text editor did not display the full text in some cases.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to execute SQL files that contain "NaN" values.
2. Primary Key checkbox was deselected when tabbing to the next field in Table Designer.
3. "Unknown Internal" error occurred when importing data.
4. The DDL of PostgreSQL tables with "tstzrange" data type was incorrect.
5. The deployment scripts generated incorrect default value in Structure Synchronization.
6. "Access Violation" error occurred after editing the data pipeline in Report.
7. "Unknown Internal" error occurred when using Automation.
8. Unable to duplicate model files.
9. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Query result pane size did not retain after minimizing the window.
2. Paradox tables cannot be imported.
3. Unknown Internal error occurred when importing data.
4. Column order was incorrect when importing database to model.
5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. "Replace All" button was unable to replace the last occurrence in Query Editor.
2. Code completion suggestion list did not show on the same screen as the editor.
3. A table was mistakenly transferred even it was not selected.
4. Incorrect syntax highlighting issue in Query Editor.
5. Filter criteria input box was not retained when switching applications.
6. Drag and drop selected text on Query Editor did not move the text.
7. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Improvements:

1. Add a "Drop with CASCADE" option for deleting PostgreSQL objects.

Bug-fixes:

1. Code completion box displayed off the bottom of the screen and partially obscured.
2. Unable to customize query result tab name by using /*NAME:XYZ*/ .
3. Boolean or BIT(1) values importing, exporting and transferring issue.
4. Copying table field names in Table Designer was slow.
5. Table Form view was unable to show jpg images.
6. Unable to import data when using Append/Update mode.
7. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. SQL order issue in Structure Synchronization.
2. Unable to save PostgreSQL function in some cases.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Main New Features:

1. Support of Partitioned Table for PostgreSQL 10
2. Brand new Filter Wizard
3. UI and UX Improvement
4. MongoDB is added in Navicat Premium
5. Navicat for MongoDB is released

To upgrade, please visit our Customer Center.

Bug Fixes:

1. File encoding was incorrect when transferring database to SQL file.
2. Structure Synchronization detected differences after synchronizing.
3. Incorrect unique values were imported from .dbf file.
4. Crashed when saving the modified field names in some cases.
5. Extra "(" was added to INSERT statements when deploying scripts in Data Synchronization.
6. Foreign keys were not transferred when transferring tables from MySQL to SQLite.
7. .ndm file association was not worked.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. 80041318 error occurred when saving a task schedule.
2. The cursor position row moved to the bottom line after saved the procedure/function.
3. "XXX is not a valid value" error occurred when editing a PostgreSQL model table in some cases.
4. Transaction did not end after closing the table in some cases.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Zero decimal place digits were not displayed in Table Viewer.
2. Exported SQL file did not have table name when exporting an unsaved query.
3. The privileges of PostgreSQL functions with parameters were not visible in Privilege Manager.
4. Incorrect dates were exported when exporting PostgreSQL tables to Excel files.
5. Syntax error occurred when importing CSV files in some cases.
6. Database names were missing in the Drop SQL generated by Structure Synchronization.
7. Unable to change the Tab Width in Query Editor.
8. Unable to edit query results when tables had alias.
9. Procedure parameters were missing in the scripts generated by Structure Synchronization.
10. Unknown Internal Error occurred when Automation ran.
11. Unable to transfer tables with HEX format.
12. Default parameter syntax was stripped after saving PostgreSQL function.
13. Syntax error occurred when creating PostgreSQL function with array parameters.
14. Encoding issue of the exported text file.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. "Access Violation" error occurred when creating new connections in fresh installed Navicat.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Unable to create a query inside a group.
2. The color of function keywords did not change according to the Font Color settings in Options.
3. Column width did not retain after hide and show the column in Table Viewer.
4. Unable to drag and drop a query into a group in some cases.
5. Unable to edit query results in some cases.
6. Unable to disable Foreign Key constraint in Data Synchronization.
7. Crashed when dumping table to sql file in some cases.
8. Foreign Key constraint issue in Import Wizard.
9. Code completion replaced the text after caret.
10. Exported files were not attached to the notification email.
11. Keepalive Interval setting attempted to connect continuously even the database was down.
12. If a query was opened, abnormal behavior happened when closing Navicat.
13. Automation did not start when the computer was logged out.
14. Navicat was not responded when performing Structure Synchronization.

To upgrade, please visit our Customer Center.

Improvements:

1. Supported creating PostgreSQL 10 Models.

Bug Fixes:

1. RAISE NOTICE events did not show in Message Log.
2. Spaces were missing in the SQL exported from Model.
3. Extra newlines were added to the SQL exported from Model.
4. Unable to change the comment of PostgreSQL functions with named parameters.
5. "Hourly" option was missing on Task Schedule's Trigger tab.
6. Wrong datestamp was appended to the exported files.
7. Slow issue when searching in Table Viewer.
8. Unable to move functions into a group.
9. Unable to select Enum data in query results.
10. "Invalid byte sequence for encoding" error occurred when opening PostgreSQL tables.
11. Target functions/procedures were not dropped before create when synchronizing structure.
12. Unable to synchronize models/queries in Navicat Cloud.
13. Exported Excel files were corrupted 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. Error occurred when exporting with Time field type.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Cannot to show PostgreSQL large decimal data properly in Table Viewer.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Crashed when using Query in some cases.
2. Query auto-save feature did not work in some cases.
3. Debugger did not work for PostgreSQL 8.3 to 9.0.
4. Set task schedule in Batch Job did not work.
5. Fixed UI font issue in Ubuntu 16.10.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Unable to move PostgreSQL function with special parameter to virtual group.
2. Minor bug fixes and improvements.

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. Enhanced Connection Coloring.
2. Search database object structure.

To upgrade, please visit our Customer Center.

Improvements:

1. Supported PostgreSQL 9.5.

Bug Fixes:

1. Exported result incorrect for TIME field type in Export Wizard.
2. File name with appended timestamp issue in Export Wizard.
3. Unable to synchronize BIT fields for PostgreSQL tables in Data Synchronization.
4. Slow performance when showing/hiding column with Memo editor opened.
5. SSH protocol error issue.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Generated object SQL identifier without escaping quote characters in Model.
2. Unable to load the virtual group settings file created by old versions of Navicat.
3. After sorted a selected column in Table Viewer, access violation occurred when resizing column width.

To upgrade, please visit our Customer Center.

Improvements:

1. Reset the field length to default value after changing the auto guessed field type in Table Designer.

Bug Fixes:

1. Access violation error occurred when entering SQL in Query.
2. Unable to download source files with HTTPS connection in Import Wizard.

To upgrade, please visit our Customer Center.

Improvements:

1. Improved the Message Log information.

Bug Fixes:

1. Failed to generate PostgreSQL index field clause in Structure Synchronization.
2. Unable to drop columns for PostgreSQL View in View Designer.
3. Unable to identify equality of trigger definitions with different system line breaks in Structure Synchronization.
4. Unable to convert object names in Data Transfer when using Schedule.

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.

To upgrade, please visit our Customer Center.