Release Notes

Bug-fixes:

1. Fixed an issue where scheduled tasks failed to execute.
2. Fixed query result columns not retaining the order specified in the SELECT statement.
3. Fixed keyboard navigation problems in the Import Wizard.
4. Fixed custom column widths resetting to default when changing a field's data type in the Import Wizard.
5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

AI Integration in Table Designer & Data Editor

1. Fill with AI - Update, generate, or summarize column data directly within the grid.
2. Ask AI - Construct entire schema structures using natural language prompts.
3. Fill Comment with AI - Generate table summary based on field definitions.

Code Insight in Query Editing

1. Refactoring - Rename symbols, aliases, and identifiers uniformly across scripts.
2. Hover Info - Quick-access metadata previews when hovering over SQL elements.
3. Real-Time Error Detection - Real-time syntax flaw and invalid schema object detection.
4. Highlight Usages - One-click symbol usage tracing within the editor.
5. Go to Declaration - Direct navigation to underlying object definitions.

Data Masking

1. Secure sensitive production records and generate test datasets.
2. Support Masking Technique - Substitution, Variance, Shuffling, Hashing, and Nulling.

Data Modeling

1. Hybrid Model - Bridge logical entities and physical structures within a single model.
2. Naming Standards & Glossary - Support centralized glossaries and standardized naming rules across schemas.
3. Bulk Editor - View and edit fields across multiple tables simultaneously.
4. Import SQL to Model - Generate data models directly from SQL scripts.
5. Diagram Add-ons - Move Fields Between Tables, Create New Table & Alignment Guide.

Interactive BI

1. Auto Tile Layer - Automatic dynamic chart alignment and resizing for dashboard layouts.
2. Parameters - Dynamic workspace-wide parameters for cross-visual data filtering.
3. Dashboard Add-ons - Auto Refresh, Page Navigation links & Alignment Guide.

Usability & Workspace Improvements

1. Reimagined Import Wizard - Redesigned into a single-step workflow with live preview panes.
2. Parquet Support - Native support for importing Apache Parquet files.
3. Batch Editing - Batch record modifications with a manual Apply/Discard bar.
4. Session History - Track and audit for SQL queries executed during data editing sessions.
5. Side-panel Record Navigation - Quick-jump navigation panel in Form View.
6. Conditional Data Synchronization - Set custom filter conditions during data synchronization.
7. Personal Profile Sync - Synchronize connection profiles, table preferences, starred settings, and coloring info across Navicat Cloud and Navicat On-Prem Server.
8. And More.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. The table comment in the data dictionary was stretched off the page.
2. Unable to display the complete text in the data grid after moving Navicat to a larger monitor.
3. Crashed when using Model workspace in some cases.
4. Opening databases in Query Builder was slow.
5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Crashed when using data transfer in some cases.
2. Some words were collapsed when adding lines in the Query Editor.
3. Unable to save cardinality settings in the model diagram.
4. Incorrect time displayed in the log of Data Dictionary.
5. Error occurred when opening the exported Excel file.
6. 'Parameter is incorrect' error returned when creating schedule to run the batch job.
7. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. ORA-01002 error occurred when exporting Oracle data.
2. Unable to save changes after updating foreign key names in the model.
3. Scrolling skipped two rows in the data viewer.
4. 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

Note: The Report feature has been deprecated.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Undoing changes in a function incorrectly cleared all code.
2. Time values imported from Access database were incorrect.
3. 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. Unable to handle CASE statement when using Query Builder.
3. Access Violation error occurred when copying procedure results.
4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Oracle query only accepted SCHEMA.TABLE syntax.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to show tables when using Oracle OS authentication.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to show tables when using Oracle OS authentication.
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. Unable to change primary key name.
4. 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. Column sizes did not persist when refreshing table.
5. Crashed when using "Filter & Sort".
6. 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 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.

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.

Bug-fixes:

1. Source connection info was not pre-populated in the Structure Synchronization window.
2. Model diagram disappeared when hovering over.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Main New Features:

1. Enhanced Query Editor
2. Enhanced BI Feature
3. New Filter & Sort Layout
4. Many other new features and improvements

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Crashed when clicking the Options button in the Data Generation window.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Foreign keys were not deleted when deleting the parent table in the model.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Invalid file format error occurred when opening a model workspace.
2. Crashed when opening a model workspace in some cases.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Keyboard support failure in Data Viewer.
2. The reference field was not updated when changing the primary key field in the model.
3. Non-filtering objects did not hide in the overview navigator of ER Diagram.
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. All-New Model Workspace
2. Data Profiling
3. Data Dictionary
4. Query Pinned Result
5. Table Profile
6. Navicat URI
7. Manage Connection
8. Enhanced BI Feature
9. Focus Mode
10. Many other new features and improvements

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to show data in some cases.
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 importing paradox files.
2. Failed to import JSON file from web service.
3. Refresh button did not work in Server Monitor.
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. 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. 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. 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. 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.

Bug-fixes:

1. Cannot type a new name for the table in Import Wizard.
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.

Improvements:

1. Support unix socket forwarding in SSH.

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. Query Builder window was larger than the screen in some cases.
2. Unable to display the data differences of TEXT fields in Data Synchronization.
3. The second field was selected when adding a sort condition in Table Viewer.
4. Crashed when stopping Data Transfer process.
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.

Improvements:

1. Support OceanBase Oracle Mode.

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

Bug-fixes:

1. Cannot display column comment when mouse over in dark mode.
2. Data Synchronization did not work in Automation.
3. "Failed to send mail. Stream error." occurred when sending email.
4. 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.

Bug-fixes:

1. Bar chart label display issue.
2. Unable to export Excel file in some cases.
3. Hanged when transferring tables.
4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Font size issue in Form View.
2. Buttons in the lower right corner of the main window were missing in some cases.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Crashed when changing the chart type in some cases.
2. Hanged when deleting a table in Query Builder.
3. Text color issue in Dark Mode.
4. Unable to connect AWS RDS database via SSH.
5. Backup and Dump SQL File was slow in some cases.
6. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to open the objects in the "Find in Database" window.
2. The first number of every value in the list was removed in the table filter.
3. Unknown Internal Error occurred when updating query results in some cases.
4. Unable to use "Copy As" in View results.
5. Crashed when opening functions in some cases.
6. Unknown Internal Error occurred when foreign key selection window popped up.
7. Crashed when clicking on the value box in table filter.
8. Cannot retain the window size and position for existing objects.
9. 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.

Bug-fixes:

1. Query parameters did not work in some cases.
2. Decimal precision issue when importing from Excel files.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Crashed when opening large tables.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unknown Internal Error occurred when exporting large amount of data.
2. Unable to sign in Subscription plan.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Crashed when running Automation in some cases.
2. Missing the first record when import.
3. Unable to locate project when running batch job.
4. Unable to get table information when scheduling data synchronization.
5. Refresh button ran all SQLs in Query Editor.
6. .0000 data export issue.
7. Navicat exited when clicking the Type column in Table Designer.
8. Crashed when batch querying tables with FK dependency.
9. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to close the error dialog when changing field name in model canvas.
2. Unable to close the error dialog when editing chart y-axis range.
3. Failed to transfer large tables.
4. SSH connection issue when using Automation.
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. The "Compare" button did not work in Data Synchronization in some cases.
2. "Couldn't open known_hosts file" error occurred when the SSH path contained Chinese characters.
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. Connection password issue when updating connection in Navicat Cloud.
2. Error occurred when synchronizing to Navicat Cloud.
3. Unable to view and edit user/role privileges.
4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Notification Email authentication failed in some cases.
2. 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. Query Execution Summary
4. Navicat On-Prem Server is released
5. 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. No data value on the label when exporting a chart to a PDF file.
3. Unable to rename a view inside a group in Navicat Cloud.
4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to show accurate value of Oracle BINARY_DOUBLE type.
2. Unknown Internal Error occurred when importing Excel file in some cases.
3. An empty string was not quoted when exporting to a text file.
4. Query was garbled when the system locale set to Japanese.
5. Export/Import profile did not work if it was copied to Desktop.
6. 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. Unable to rename Oracle views when the "Use custom database list" option is enabled.
3. Error occurred when using Recordset Generator to generate a record set for the Date field.
4. Hanged when designing a table with many fields.
5. Relation lines were disappeared after saving and reopening Logical Model.
6. 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. 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. Notification email subject was incorrect when the job finished unsuccessfully.
3. Cursor focusing issue when using Find feature in Table Viewer.
4. 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. Unable to load version 10 data synchronization profiles.
4. 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. Unknown Internal Error occurred when executing Oracle's package body.
4. Unable to display full Oracle view definition 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. "Unknown Internal Error (A70529211102SE)" error occurred when exporting / importing data.
5. Slow issue when transferring large tables.
6. Unable to show the inputted text in Filter Wizard.
7. Error occurred when filtering data by right-clicking a cell in Table Viewer.
8. Inserted records to the wrong table when transferring data to the target table with a different name.
9. 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. Double quotes were added to the fields of a compound index in Oracle.
6. 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. Unable to set data to NULL in query results.
2. Crashed when clicking the ellipsis button in Custom Recordset.
3. Pasting data into a column cleared another column data.
4. Default Settings Location path was set to a wrong location for some cases.
5. "Floating point division by zero" error occurred when setting the dashboard background.
6. The file extension was missing when exporting the dashboard.
7. Query Parameter did not work when using a parameter twice.
8. "Invalid floating point operation" error occurred when adding NULL data to the chart.
9. Incorrect columns were displayed after clicking the Default button in the "Choose columns" window
10. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to export data to .mdb files.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unknown Internal error occurred when opening Oracle tables.
2. Unable to set default value for fields in Table Designer.
3. Data Pump Import's Table Exists Action drop-down list options were incorrect.
4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Incorrect SQL generated when transferring Oracle tables.
2. Invalid XML error occurred when importing connections.
3. Differences was detected in re-comparison in Structure Synchronization and Synchronize to Database.
4. Incorrect data was updated when saving ; in a non-text field.
5. Incorrect SQL generated for altering fields in Structure Synchronization.
6. Incorrect items were displayed in suggestion list when using code completion with alias.
7. Minor bug fixes 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. Query wrongly returned null results in some cases.
2. "," was replaced by "." when using Custom Filter in Table Viewer.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Improvements:

1. Added "Table Relation" and "Field Relation" options to Query Builder.
2. Added Connection Coloring to Query windows.

Bug-fixes:

1. Unknown Internal Error occurred when starting Navicat in some cases.
2. Crashed when importing two XML files.
3. Popup menu was missing when right-clicking on stored procedure results.
4. The performance of Privilege Manager was slow.
5. Refresh button in Privilege Manager did not pull the latest privileges.
6. Differences were detected after synchronizing model to database.
7. Syntax error occurred when saving procedures in some cases.
8. Datetime functions generated text in exported Excel files.
9. Hanged when searching regular expression in Query Editor.
10. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Only the first batch was transferred when "Number of row per batch" was enabled.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Improvements:

1. Added "Keep Orthogonal Layout" to Model.

Bug-fixes:

1. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Improvements:

1. Added shortcuts for "Run Current Statement" and "Select Current Statement" in Query Editor.

Bug-fixes:

1. "Unknown Internal Error" occurred when modeling databases.
2. Find bar UI issue in Data Viewer.
3. Unable to print table when using popup menu on Navigation pane.
4. Explain feature did not work with query parameters.
5. Interval type was not supported in Charts.
6. Highlight color issue in Filter wizard when using Dark mode.
7. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Wrong options were selected when loading another Data Transfer profile.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. OCI Environment setting was unable to save.
2. "Invalid floating point operation" error occurred when resizing tables in View Builder.
3. Multiple primary key names were generated when exporting model to SQL files.
4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Access violation error occurred when adding users to Navicat Cloud project.
2. Access Denied error occurred when designing table.
3. Unable to highlight field when typing in Filter's field selection list.
4. Wrong fields are exported to the SQL file when not all fields are selected.
5. Dark theme kept reverting back to Normal theme.
6. Wrong CREATE INDEX was generated in Model.
7. Empty value was exported as **** when exporting DBF file.
8. Data Transfer high memory consumption issue.
9. Run queries slow issue.
10. "List index out of bounds (-1)" error occurred when editing role privileges.
11. "Last Tab Window" option was missing.

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. Down arrow key did not highlight table grid cell in some cases.
2. 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. Unable to dump the default value of TIMESTAMP field.
3. Synchronize to Database feature wrongly detected differences of unique constraints.
4. 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. Unable to map a source field to multiple target fields in Import Wizard.
4. "Cannot open file" error occurred when scheduling export profiles in some cases.
5. Unable to show empty fields in query result sets.
6. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. "Unknown Internal Error" occurred when opening Table Designer.
2. 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. Primary Key checkbox was deselected when tabbing to the next field in Table Designer.
2. "Unknown Internal" error occurred when importing data.
3. The deployment scripts generated incorrect default value in Structure Synchronization.
4. "Access Violation" error occurred after editing the data pipeline in Report.
5. "Unknown Internal" error occurred when using Automation.
6. 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. Crashed when opening Oracle table with Spatial data.
4. A table was mistakenly transferred even it was not selected.
5. Incorrect syntax highlighting issue in Query Editor.
6. Filter criteria input box was not retained when switching applications.
7. Drag and drop selected text on Query Editor did not move the text.
8. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Crashed when opening Oracle table with Spatial data.
2. Code completion box displayed off the bottom of the screen and partially obscured.
3. Unable to customize query result tab name by using /*NAME:XYZ*/ .
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. Importing files to Oracle server was slow.
8. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to change variable's value when debugging Oracle function.
2. SQL order issue in Structure Synchronization.
3. Console window was not colored when connection coloring were set.
4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. List index out of bounds error occurred when inserting data in Table Viewer.
2. Unable to shrink the last column on the Process List tab in Server Monitor.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Slow performance when editing users or roles.
2. Unable to show the ROWID column when running Oracle queries.
3. Floating point numbers were rounded to decimals when import.
4. <html> tag was repeated twice when exporting HTML files.
5. "Add Database to List" button was enabled when the "Use custom database list" option was not checked.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Custom Filter was cleared when editing it.
2. DBMS Output result was incomplete.
3. HTML export did not specify charset.
4. "Show/Hide Columns" option was missing in Form View.
5. The hidden Information pane was shown when switching from Form View to Grid View.
6. Cursor focus issue in Form View.
7. Code Completion did not work in some cases.
8. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. "SQLite function sqlite_libversion cannot linked" error occurred when starting Navicat.
2. Unable to scroll inside the text box in Form View.
3. "is in list" operator in Filter Wizard did not working correctly.
4. Structure Synchronization compared table options.
5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unknown Internal Error occurred when showing data "{}" in TEXT editor.
2. Esc shortcut did not work when error occurred during deleting records.
3. Error occurred when renaming an existing column and adding a new one.
4. Filter value did not displayed when the string exceeded 5880 characters.
5. Unable to display the columns list in Table Designer's Index tab when there was no index.
6. Unable to apply Filter profile.
7. Unable to scroll to right in Filter Wizard.
8. Opening Design Table froze in large database.
9. "Open Table" and "Design Table" were not properly synchronized.
10. Import Target and Field Mapping changed after changing the source file in profile.

To upgrade, please visit our Customer Center.

Improvements:

1. Improved Filter Wizard.
2. Supported expression for default field value in Table Designer.

Bug-fixes:

1. Crashed when applying filter in Foreign Key Selection window.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Main New Features:

1. Brand new Filter Wizard
2. UI and UX Improvement
3. MongoDB is added in Navicat Premium
4. 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. .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. Transaction did not end after closing the table in some cases.
4. Error occurred when there was a "CRLF" character in Oracle procedure.

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. Unknown Internal Error occurred when importing from ODBC.
4. Syntax error occurred when importing CSV files in some cases.
5. Database names were missing in the Drop SQL generated by Structure Synchronization.
6. ORA-01830 error occurred when transferring tables to Oracle server in some cases.
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. Encoding issue of the exported text file.
13. Crashed when the Oracle host name was longer than 1000.

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.

Bug Fixes:

1. Spaces were missing in the SQL exported from Model.
2. Extra newlines were added to the SQL exported from Model.
3. "Hourly" option was missing on Task Schedule's Trigger tab.
4. Wrong datestamp was appended to the exported files.
5. Slow issue when searching in Table Viewer.
6. Unable to move functions into a group.
7. Target functions/procedures were not dropped before create when synchronizing structure.
8. Unable to synchronize models/queries in Navicat Cloud.
9. Exported Excel files were corrupted in some cases.
10. "Access is denied" error occurred when setting schedule.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Error occurred when synchronizing structure in some cases.
2. Replace All did not work in Table Viewer.
3. Cell selection disappeared after pressing CTRL+C in Table Viewer.
4. Error occurred when running query in some cases.
5. "Unknown Internal Error" occurred when exporting query results.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Unknown Internal error occurred when editing/adding connections.
2. Adding self-referencing table issue in Query Builder.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Out of memory issue when running Data Transfer.
2. "Unknown Internal Error" occurred when loading profiles in Structure Synchronization.
3. Export Float data to csv files issue.
4. Unable to display Oracle Chinese data in some cases.
5. Crashed when importing Excel or Text files in some cases.
6. Opening large databases in List View took long time.
7. Unable to show query files with ".SQL" extension in Objects tab.
8. The length of NVARCHAR fields were missing when exporting models to SQL files.
9. CTRL+SPACE shortcut were missing in Query Editor.
10. Target's default Tablespace were not used in Data Transfer.
11. Print report to PDF command wrongly sent the report to printer.
12. Null date values were exported wrongly as "1900-01-00" in Excel files.
13. Tables Viewer displayed wrong number of digits.
14. Input parameter window did not pop up when exporting query.
15. High CPU usage issue.

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 zoom in/out Query Editor using mouse wheel.
2. Swapping connections did not work when re-comparing in Data Synchronization.
3. Code Completion did not work when logged in with non DBA users.
4. Syntax errors occurred when running query in some cases.
5. Unknown Internal error occurred when performing Structure Synchronization.
6. Query syntax highlight was wrong after switching tabs.
7. DateTime field Not Null checkbox unchecked wrongly in Table Designer.
8. Unable to export table to xlsx with name longer than 31 characters.
9. Hanged when searching in Table Viewer in some cases.

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.
4. Unknown Internal Error occurred when performing Structure Synchronization.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Fixed exporting numbers to Excel issue.
2. Fixed importing connections with Settings Location issue.
3. Fixed ER diagram layout issue.
4. Table groups were not synchronized to other members in Navicat Cloud.
5. Wrong SQLs were generated when inserting fields in Table Designer.
6. Unable to run CREATE PROCEDURE statements in Query Editor.
7. Unable to save function after changing parameter names.
8. Unable to import DBF files.
9. Identifiers panel retained when opening new query window.
10. The Stop button in Export Wizard did not work properly.
11. Unknown Internal Error occurred when typing in Query Editor.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Record delimiter was wrong when exporting to text file using Automation.
2. Table Viewer moved back to the first page when refreshing a table.
3. Unable to dump Oracle tables to SQL files.
4. Unable to show synonyms in the Objects tab.
5. Characters displayed wrongly in Table Viewer.
6. Error occurred when adding fields in Oracle table.
7. Unable to select fields when exporting to Excel file.
8. Hanged when closing connection on less session environment.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Error occurred when deleting INT field value in Table Viewer.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Wrongly shown differences when synchronizing structure.
2. The DDL tab in Information pane did not updated after saving changes in sub forms.
3. Unknown Internal Error occurred when synchronizing structure/data in some cases.
4. Unable to schedule Data Synchronization profiles.
5. Syntax error occurred when filtering with ' character in Table Viewer.
6. Input decimal separator issue in Table Viewer.
7. Unable to import date from Excel to VARCHAR field.
8. Query Builder loading was slow.
9. Re-registration issue.
10. Unable to create new table in Import Wizard in some cases.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Table triggers was not included when backing up tables.
2. Auto increment field was ignored when importing
3. Navicat hanged when running a query export profile in some cases.
4. Error occurred when running LOAD DATA LOCAL queries.
5. Special characters were garbled when exporting Access files.
6. Unknown Internal error occurred when exporting Access files.
7. Unknown Internal error occurred when saving changes in Table Designer.
8. "Too many client tasks" error occurred when importing Access files.
9. Double-quote encased text fields were split into new records when importing a record which multiple lines.
10. Syntax error occurred when performing data transfer in some cases.
11. Unknown Internal error occurred when adding multiple records in Table Viewer.
12. Two identical functions declared as different in Structure Synchronization.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Unable to open Information pane by context menu.
2. Unable to import fixed width text file in some cases.
3. Access Violation error occurred when creating models / tables in some cases.
4. Access Violation error occurred after Navicat was idle.
5. ORA-01861 error occurred when importing Excel files.
6. Unable to import the CDATA data in XML files.
7. Number values were exported as text in Excel files.
8. Code completion did not work for alias in SQL Editor.
9. Beautify SQL did not format multiple statements properly in SQL Editor.
10. Unknown Internal error occurred when running query with parameters.
11. Table menu displayed wrong item in some cases.
12. Unknown Internal error occurred when running old version export profiles in Automation.
13. Unknown Internal error occurred when opening tables in some cases.
14. Wrong syntax displayed for PostgreSQL in Function Designer.
15. "_Navicat_Temp_Stored_Proc() does not exist" error occurred when saving functions.
16. High memory usage issue in Data Synchronization.
17. "Use empty string as NULL" option did not work in Import Wizard.
18. Unknown Internal error occurred when writing query in some cases.
19. Unknown Internal error occurred when backup in Automation in some cases.
20. Hang issue occurred when launching Import Wizard.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Unable to import Chinese characters from Excel files.
2. Incorrect date and decimal formats in exported Excel files.
3. Filter criteria settings were removed when applying sorting on column.
4. Unknown Internal Error occurred when executing old version export profiles in Batch Job.
5. Unknown Internal Error occurred when loading Filter profiles in Table Viewer.
6. File path and file name were not saved in Export profiles.
7. Unknown Internal Error occurred when there was multiple statements in Query.
8. Incorrect field names were shown in code completion suggestion list.
9. Unable to attach the report PDF file in notification email.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. "Unknown Internal Error" occurred when typing statement in SQL Editor.
2. Unable to show field names in data pipeline after editing SQL in Report.
3. Beautify SQL formatted the statement wrongly in some cases.
4. Sorting by modified/create date did not work for details view in main window.
5. Connection coloring displayed wrong color in some cases.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Wrong table showed when comparing tables in Data Synchronization in some cases.
2. Unable to import special characters from Excel.
3. Unable to paste multiple records in Table Viewer.
4. Created Batch Jobs did not show in Standard Edition.
5. "Unknown Internal Error" occurred when importing files.
6. View Builder locked up when re-open for editing in some cases.
7. Unable to log in Oracle server using lower case username.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. "Access violation" error occurred when create new query/view.
2. Wrongly showed primary key warning in some cases.
3. Unable to type some characters in editor when using international keyboard.
4. Unable to edit connection settings in some cases.
5. Information Pane did not appear in some cases.
6. "Oracle Library not loaded" error occurred when connecting.
7. Internal error occurred when importing CSV files.
8. Cell values froze when scrolling in grid view.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Failed to load Data Synchronization profiles.
2. Data display issues in table viewer.
3. Minor bug fixes and improvements.

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. Fixed the CREATE PACKAGE and CREATE PACKAGE BODY issue in SQL Editor.
2. Error occurred when exporting with Time field type.
3. Removed "WHEN()" if "When Clause" is NULL for trigger.
4. Wrong SQL statements were generated wrong when running "Synchronize to Database" in Model.
5. Fixed the varchar2 issue when running "Synchronize to Database" in Model.
6. 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 Query in some cases.
2. Query auto-save feature did not work in some cases.

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. Fixed the sorting issue in Table Viewer.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Copy and paste issue in Table Viewer's Memo Editor.
2. "Date format is too long for internal buffers" error occurred when viewing Oracle tables in some cases.

To upgrade, please visit our Customer Center.

Improvements:

1. Support inputting tabs in the editor of Table Designer.
2. Support UTF16 formatted files in Execute SQL File and Query's Import SQL functions.

Bug Fixes:

1. The media keys (play, pause, next etc) did not work.
2. Failed to transfer data in Chinese locale OS.
3. Crashed when synchronizing model to database in some cases.
4. Unable to show the light coloring when the tab is non-active.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. The datetime field values were inconsistent in exported file.
2. Error occurred when adding tables to report.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Unable to add tables to Report's Query Wizard and Query Designer when the table name contained dot.
2. Error occurred when logging in Navicat Cloud if profile path contained Unicode.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Failed to get Oracle Materialized View information for Code Completion.
2. Fixed multi-monitor with different dpi issue.
3. Column import definition broken when importing.
4. Saved Import profile mapped columns wrongly.
5. "invalid varient operation" error occurred when import from ODBC.
6. "Argument out of range" error occurred when importing CSV file.
7. Primary Key settings were deleted when modifying import profile.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Error "Diagram table already exists" occurred when opening some model files.
2. Crashed when exporting connections.
3. "Access violation" error occurred when importing CSV file.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Unable to edit the query in Query Editor when running it.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Schedule and Command Line stopped working when user did not sign in Navicat Cloud.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. "Argument out of range" error occurred when using "Find in Database/Schema".
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.

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. Enhanced Stored Procedure editor.

Bug Fixes:

1. Exported result incorrect for TIME field type in Export Wizard.
2. File name with appended timestamp issue in Export Wizard.
3. Wrong caption/icon showed for Stored Procedure.
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. Foreign keys were re-created when editing Oracle tables in Table Designer.
2. Generated object SQL identifier without escaping quote characters in Model.
3. Unable to load the virtual group settings file created by old versions of Navicat.
4. 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.
3. 'Cannot create oci environment' error occurred in Oracle connections.

To upgrade, please visit our Customer Center.

Improvements:

1. Improved the Message Log information.

Bug Fixes:

1. Unable to generate the SET clause properly for Oracle when using update mode in Import Wizard.
2. Unable to convert object names in Data Transfer when using Schedule.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Unable to run in Windows Server 2003.
2. Fixed the color issue in the connection tree.
3. Unable to show Material View in Query Builder.

To upgrade, please visit our Customer Center.

Improvements:

1. Allow copying field names in Table Viewer and Query's Result.

Bug Fixes:

1. Crashed after multiple drag & drop tables in Model Designer.

To upgrade, please visit our Customer Center.

Improvements:

1. Error counting in Data Transfer's Message Log changed from records to records and objects.

Bug Fixes:

1. 'Cannot create oci environment' error occurred in some machines.
2. Unable to select new mode in connection tree using Alt+MouseDown.
3. Access Violation error occurred when exporting single column to Word.
4. Duplicated foreign key names issue in Model.
5. Unable to recognize the Row Delimiter when importing from CSV files.
6. Import Wizard was unable to import currency data from DBF files.
7. Advanced settings were saved incorrectly in Data Transfer profiles.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Synchronized Navicat Cloud model files even they did not have any changes.

To upgrade, please visit our Customer Center.

Improvements:

1. Added Open Containing Folder feature for Query, Report and Model.
2. Added Open with External Editor feature for Query.
3. Added press and hold Alt key and double-click table to open Table Design.

Bug Fixes:

1. Failed to dump SQL file from Navicat Cloud connection.
2. Unable to select foreign key for new table in Table Design.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Oracle unicode characters in Export handled incorrectly.
2. Data started with single quote issue in exported Excel file.

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

To upgrade, please visit our Customer Center.

Improvement:

1. Query profile now support to show in server level.

Bug Fixes:

1. Unable to save local file if database name contained heading/tailing space.
2. Crashed when loading and parsing a long incorrect syntax SQL in Query.
3. After adding a new row, pressing next/last button would freeze the Form View in Table Viewer.
4. Number of rows selected incorrectly when using shift+up/down keys in Table Viewer.
5. Multiple selection not working properly with shift+keys in Table Viewer.
6. When using CTRL+A to select text inside a data cell, all cells were incorrectly selected in Table Viewer.
7. Import Paradox not able to import data properly in Navicat 64bits.
8. ORA-00911: invalid character error occured when exporting query results.
9. Wrong NullsOrder setting was shown for foreign key fields under Table Designer in Data Modeling Tool.
10. Wrong CREATE TABLE SQL with character set and comment exported under Export SQL in Data Modeling Tool.

To upgrade, please visit our Customer Center.

Improvement:

1. Always import as NULL value if "Use empty string as NULL" option is checked in Import Wizard.
2. All records are now able to show under the Fixed Width window in step 3 of Import Wizard.

Bug Fixes:

1. 'Control 'Dock2Form_1' has no parent window' error occured while docking in and out of windows.
2. Connection was deleted after renamed to capitalized name.
3. 'Table does not exist' error occured while opening an export profile.
4. Binary Data Encoding option was ignored in Import Wizard if string data type existed.
5. Server with unsaved password not able to connect under 'Import from Database' in Data Modeling Tool.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Lose focus in Table Viewer.
2. Function parser error.
3. Access Violation error occurred when importing invalid connections.
4. ERegistry Exception error occurred when starting Navicat.
5. Oracle reconnection problem.
6. Wrong Date Editor frame size in Table Viewer.
7. Stack Overflow error when running Query.
8. Permissions issue of the Updater.
9. Cursor was missing in Stored Procedure.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Please refer to Navicat Premium and Navicat for MySQL release notes for the bug fixes of version 11.0.12.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Missed to mark quotation on keywords in Query Builder.
2. Process was unable to stop while running query in Essentials version.

To upgrade, please visit our Customer Center.

Bug Fixes:

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

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Column width not able to be reset after showing the hidden column in Table Viewer.
2. Access violation occured in Table Viewer while reconnecting SSH connection with another port.
3. Query message in status bar not updated if no result return after Run.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Column width not able to be reset after showing the hidden column in Table Viewer.
2. Access violation occured in Table Viewer while reconnecting SSH connection with another port.
3. Query message in status bar not updated if no result return after Run.

To upgrade, please visit our Customer Center.

Bug Fixes:

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

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Fixed "Keyboard Interactive Failed" error for SSH tunnel connection.
2. Crashed while using SSH tunnel connection for both source and target servers in Data Transfer.
3. Notification email not sent with an unsaved batch job.

To upgrade, please visit our Customer Center.

Major New Features:

Native 64-bit version

Interface

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

Connection

1. New SSH Manager
2. Connection Tree Filter

Table Viewer

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

Table Designer

1. Search Columns
2. Field Type Prediction

Query

1. Enhanced Query Builder

Import Wizard/Export Wizard

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

Backup/Restore

1. Oracle Data Pump

Report

1. Enhanced PDF printing

Others

1. New Registration and Activation System
2. New Updater

To upgrade, please visit our Customer Center.

Bug Fixes:

1. "Access violation" error occurred while applying an existing table name on a new table in Data Modeling Tool.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. "List index out of bounds" error occurred when some source fields were removed after import profile were created during Import Wizard.
2. Synchronize to Database function in Data Modeling Tool genarated incorrect comparison result for equivalent source and target foreign keys.
3. Dump SQL File function produced inorrect SQL for CLOB fields.

To upgrade, please visit our Customer Center.

Improvement:

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

Bug Fixes:

1. The dump of a table with CLOB produced an incorrect SQL statement.
2. Wrong time unit (ms) was shown under Messages tab in Query function.
3. Table Designer in Data Modeling Tool was unable to save newly added index and foreign key.
4. Synchronize to Database function in Data Modeling Tool was unable to generate the referencing table schema name in the SQL scripts.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Empty named relation was unable to load back in Data Modeling Tool.
2. "Access violation" error occurred while opening "Import from Database" form in Data Modeling Tool.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Minimized docked window could not restore normally.

To upgrade, please visit our Customer Center.

Improvement:

1. Added font selection in Option for ER Diagram.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. If the table contained many columns, new column would be inserted to wrong position in Table Designer (Data Modeling Tool).
2. Error occured in Filter Wizard when the filter criteria contain '.
3. 'GRANT CREATE ....' not being run in Query.

To upgrade, please visit our Customer Center.

Improvements on Data Modeling Tool:

1. Build model with multiple schemas.
2. New wizard "Import from Database".
3. New wizard "Synchronize to Database".
4. Search filter.
5. Align/Distribute diagram objects.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Data truncated when exporting pdf file from Report Builder.
2. Navicat got hanged while performing a search in Table Viewer.
3. Incorrect excel file format was exported while having data started with 0 in Export Wizard.
4. "80070001: PrectServer2 not connected" error occurred while transfering data to file.

To upgrade, please visit our Customer Center.

Improvement:

1. Import speed has been improved in Import Wizard.
2. Export speed has been improved in Export Wizard.

Bug Fixes:

1. Navicat generated 'Not Implemented' error when running under replacement shell UI.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Long Number could not shown in Table Designer.
2. Crash occurred when closing Synchronize to Database in Modeler during the comparison in progress.
3. Crash occurred while renaming table failed with server error in ER-diagram view.
4. Data Transfer would hang in Navicat Scheduler.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. "Access violation" error occurred when dragging n dropping a server node in connection tree together with the Model/Schedule object pane were opened.
2. When created a virtual group in the connection tree, it would be added under Model/Schedule object pane while they were opened.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Incorrect field type showed in ER Diagram.
2. Fixed-width and row delimiter were unable to retrieve from a profile in Import Wizard.
3. Print report to PDF file would generate a blank file.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Data Modeling Tool was unable to set the reference field of foreign key.
2. Data Modeling Tool was unable to print with landscape page setting.
3. When importing data from an URL, it failed to create a temporary file if the same temporary file was being accessed.
4. Connection Information could not display properly in large font size.

To upgrade, please visit our Customer Center.

Improvements:

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

Bug Fixes:

1. Import from paradox file was unable to get signed short integer values.
2. User Privileges typo was fixed.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. The highlighted items from the previous searching results in Table Designer was failed to clear for the next searching.
2. Default scale of 4 was applied when encountering currency data during the Import of Access file.
3. "Access violation" error occurred in Navicat main windows during the debug function in Debugger.

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. Added object list in Query Editor.
2. Added DDL tab in Object Information.

To upgrade, please visit our Customer Center.

Improvements:

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

Bug Fixes:

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

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Scroll bar in Trigger Definition editor was missing.
2. Object List frozen.
3. The size of the width in Run Result columns were too large in Stored Procedure form.
4. "Grid index out of range" error occured while refreshing in Table Viewer.
5. Connection combo box showed wrongly in Data Synchronization.

To upgrade, please visit our Customer Center.

Improvements:

1. Added "Grant All", "Revoke All" etc in Server Privileges tab of User Designer.

Bug Fixes:

1. Table with object array was unable to be opened in Table Viewer.
2. Imported text-based file with UTF-8 encoded data to blob field incorrectly.
3. "Use empty string as NULL" option while importing from XLS/XLSX formats is now working correctly.
4. Failed to run multiple Data Synchronization at the same time.
5. Table with identity fields was not working correctly in Data Synchronization.

To upgrade, please visit our Customer Center.

Improvements:

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

Bug Fixes:

1. Table Designer was unable to show/edit trigger definition.

To upgrade, please visit our Customer Center.

Improvements:

1. Improved the compatibility of third party plugin (eg. Ultramon, Hardcopy etc).

Bug Fixes:

1. Multiple files with files delimited as '|' were unable to be recognized during Import Wizard.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Tree node was unable to be highlighted when Connection Coloring feature was applied under Windows XP.
2. DBF character field length would be set to 254 if table field length is 0 while exporting to DBF file.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Wrong parenthesis generation in Query Builder when new table was added to FROM clause of query like e.g. select ... from (t1 join t2 on a=b).
2. Code Completion did not work properly with field name if tables were from different database.
3. Exported data (string) to Excel file did not work properly, e.g. value of '1E' would being exported as 1.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Data was truncated with VARCHAR as data type.

To upgrade, please visit our Customer Center.

Major New Features:

1. Support Keep Connection Alive.
2. New Privilege Manager.
3. Enhanced User/Role Management.
4. Data Synchronization performance improved with new engine.
5. Connection Coloring.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. "Out of memory" error occured when running a long SQL in Query function.
2. "Access violation" error occurred when running an invalid SQL syntax in Query function e.g. SELECT DBMS_OBFUSCATION_TOOLKIT.MD5 (input_string=>'1') FROM DUAL.
3. Result form showed in Query Editor would be closed after a new query was run.
4. Beautify SQL returned an invalid SQL syntax, e.g. formatted xxx@yyy into xxx @ yyy.
5. "Cannot call Start on a running or suspended thread" error occured when exporting tables with mutli resultsets.

Upgrade Procedure : click here to upgrade

Improvements:

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

Bug Fixes:

1. When pasting an enum type value using CTRL+V in Tabler Viewer, the drop down list box would be shown in wrong position.
2. "Access violation" error occurred when running an invalid SQL syntax in Query Builder, e.g. select ... from ,table01.
3. Failed to import characters data as NVARCHAR2, NCHAR, CLOB, NCLOB to server using Import Wizard.
4. In Structure Synchronization, when the queries generated in the "Queries for Modification" list were too long (e.g. 8000 characters), the whole line would become blank.
5. Error occurred when primary key constraint name in source table conflicted with the unique index which was created as the same name as the primary key in Structure Synchronization.
6. Field names for some tables with special names were unable to be listed in Report Builder.

Upgrade Procedure : click here to upgrade

Improvements:

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

Bug Fixes:

1. "Access violation" error sometimes occurred when running an invalid syntax in Query Editor.
2. "Access violation" error occurred when opening a search report in Report Viewer.

Upgrade Procedure : click here to upgrade

Bug Fixes:

1. Brackets in FROM clause could not be parsed between Query Editor and Query Builder.
2. When exporting numeric data with comma as decimal seperator to access file, the numbers were displayed without the comma.
3. When exporting numeric data to excel file, it would be exported as string type.
4. Sort by time could not work properly in Server Monitor.
5. Process ID became negative value in Server Monitor.

Upgrade Procedure : click here to upgrade

Improvements:

1. Added highlight keywords - ELSIF in SQL Beautifier.

Bug Fixes:

1. "Access Violation" error occured when printing database/table structure to PDF, HTML etc.
2. "Open Table (Quick)" could not work properly in some machines issues.
3. "List Index our of bounds (58)" error occured when trying to enter/edit SQL in query Definition tab.
4. Foreign Key link position in Visual Builder were not accurate enough.
5. Fixed bug when parsing FROM clause with brackets in Visual Builder, e.g. select ... from ((...)).
6. Privileges tab in Table Designer was unable to toggle check box using keyboard.
7. Server Monitor would crash if being opened for a while.
8. The info column in Server Monitor only showed (WIDEMEMO).

Upgrade Procedure : click here to upgrade

Bug Fixes:

1. Beautify SQL would cause error if extra spaces existed in aggregate function.
2. Fixed error when importig XML files from the Interent.
3. When exported data to Excel spreadsheet, string start with zero (e.g. 009123) would be changed to integer (9123).
4. "Ask to save new queries" in Options would be reset to unchecked after Navicat restarted.

Upgrade Procedure : click here to upgrade

Bug Fixes:

1. "Duplicate name 'Field11' in TFieldDefs" error occured if a table contained more than 11 fields in which the first ten field names include "Field1".
2. Tab order in Import Wizard was set up incorrectly.

Upgrade Procedure : click here to upgrade

Improvements:

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

Bug Fixes:

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

Upgrade Procedure : click here to upgrade

Improvements:

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

Bug Fixes:

1. Access Violation error occured when exporting chart report to excel file.
2. The automatic word wrap in TEXT fields not working properly in Form View.
3. "Navicat is not able to prase SQL" error occured in Query Editor.
4. Navicat freezed when applying "Beautify SQL" on some SQL statements.

Upgrade Procedure : click here to upgrade

Improvements:

1. Added Java and XML syntax highlighting for Oracle.

Bug Fixes:

1. The font size used in Query grid was smaller than in View grid.
2. "Set Display Format" option in Table Viewer did not work in numerical field.
3. Fixed the wrong positioning issue of main menu items.

Upgrade Procedure : click here to upgrade

Improvements:

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

Bug Fixes:

1. When selecting a particular entry in an enum select box by typing the first letters of the item, the wrong value would be saved if confirmed the changes using the check mark.
2. When applied "Auto save" function, recover window would not launched if multiple Navicat instances started.
3. "Access violation" error occured when creating function using Function wizard.
4. "Not enough storage is available to complete this operation" error occured when exporting field values start with "=" to Excel file.
5. Fixed the drag & drop problem on Select, Where, Group By, Having, Order By, Limit regions in Query Builder.
6. When trying to determine if the dataset were editable in Query, error would occur if user contained privilege on View, but did not have select privilege for Table.
7. "Access violation" error occured for code/word completion feature.

Upgrade Procedure : click here to upgrade

Improvements:

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

Bug Fixes:

1. Toolbar buttons did not refresh after maximized/minimized and changed size of panes.
2. Toolbar would blink when toggling taskbar auto hide option.
3. Oracle debugger window could not be closed when debug running error occured.
4. When sweithed between Query Builder ad Query Editor, ";" would be inserted into the middle of the statement.
5. "Select All" and "UnSelect All" buttons missing in Data Synchronization window.

Upgrade Procedure : click here to upgrade

Main New Features:

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

Upgrade Procedure : click here to upgrade

Bug Fixes:

1. "ORA-00932" error occured when opening Oracle 9i table, which contained FLOAT type, in Table Viewer.
2. Word Wrap status did not save in the Query Editor.
3. "Access violation" error occured when adding "Order By" or selecting any fields after "Select * from table" being run several times in Query Builder.
4. When import from ODBC with empty tables, "BOF/EOF access" error would occur.
5. Error dialog occured when selecting target connection in Data Transfer.

Upgrade Procedure : click here to upgrade

Bug Fixes:

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

Upgrade Procedure : click here to upgrade

Bug Fixes:

1. Sequence checkbox status and counter did not work properly in Data Transfer.

Upgrade Procedure : click here to upgrade

Improvements:

1. In step 6 of Import Wizard, Source field name would be truncated if longer than 255 characters. Now, Navicat supports up to 5000 field name characters.

Bug Fixes:

1. Refresh did not work for getting update data.
2. When import text-based file using Import Wizard, Navicat was unable to get the number of columns correctly if the file did not contain field name row or there were empty lines existed before first data row.

Upgrade Procedure : click here to upgrade

Bug Fixes:

1. Primary Key were defined improperly under SQL Preview tab in Table Designer.
2. The cursor position moved to end-of-line after saved the Stored Procesure/Function.
3. "'x,x' is not a valid floating point value" error occured when opening a table that contains floats data type together with the regional settings were set to Dutch environment.
4. Failed to establish SSH connection when the private key path contained unicode.
5. when the server name contain unicode characters, this server name was unreadable in SQL file which created using Data Transfer feature.
6. "Control 'ppParameterEditor' has no parent window" error occured when clicked on the ParametersEditor button which under Generation topic in Report Builder.
7. When a table contained some long field names, those field names were only partialy visible or even invisible in Form View.
8. When resizing the Data Transfer/Data Synchronization/Structure Synchronization window, all data fields expanded to display longer content except the "profile" drop down list.

Upgrade Procedure : click here to upgrade

Bug Fixes:

1. Please refer to Navicat Premium, Navicat for MySQL and Navicat for PostgreSQL release notes for the bug fixes of version 8.2.15.

Upgrade Procedure : click here to upgrade

Improvements:

1. Export Wizard is now able to export data filering result.

Bug Fixes:

1. "Property cannot be found" error occured when importing Access file with datatype that may involve decimal places info, e.g.currecy, number, floating point value.
2. "Access Violation" error occured when exporting data to Access file if using HTTP Tunnel connection.

Upgrade Procedure : click here to upgrade

Improvements:

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

Bug Fixes:

1. Import Wizard would be launched if the Data format was not properly set.
2. Date field was not converted correctly when exported to DBF file.
3. Undo (Ctrl + z) function did not work properly on memo editor in Table Viewer.
4. Docked windows could not show in task bar under Windows 7.
5. Email attachment in Schedule could not be sent if "Add timestamp" option was enabled in Export Wizard.

Upgrade Procedure : click here to upgrade

Improvements:

1. Improve suggestion on target data type and provide a default precision and scale information in Import Wizard.
2. Support export to clipboard.

Bug Fixes:

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

Upgrade Procedure : click here to upgrade

Bug Fixes:

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

Upgrade Procedure : click here to upgrade

Bug Fixes:

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

Upgrade Procedure : click here to upgrade

Enhancement:

1. Improved dual monitor system support.
2. Report files are now able to copy to other dataabses.

Bug Fixes:

1. Access Violation error happened on Data Synchronization when the target connection applied HTTP Tunnel.
2. Backup failed when connection applied HTTP Tunnel.
3. When closed the Restore dialog after restored, Access violation occured.
4. User-defined schema would not show in Structure Synchronization.
5. "Not enough timers available" error occured in Structure Synchronization.
6. After saved the query in Query Editor, the cursor returned to the beginning of the script.
7. When deleted multi-cell in Table Viewer, Navicat would hang.

Upgrade Procedure : click here to upgrade

Enhancement:

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

Bug Fixes:

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

Upgrade Procedure : click here to upgrade

Enhancement:

1. Ability to duplicate connection.

Upgrade Procedure : click here to upgrade

Bug Fixes:

1. Fixed access violation issue while reorganizing Join table for a saved query.
2. Fixed "Duplicate Field" function in Table Designer, given "unknown column..." error message.
3. Fixed access violation issue during backup process.
4. BFile/CFile not being handled.

Upgrade Procedure : click here to upgrade

Enhancement:

1. Added BINARY_FLOAT and BINARY_DOUBLE in datatype picklist for Oracle 10 or above.
2. Improved stability in Query.
3. Ability to stop while establishing connection to server.
4. Adjusted the default Settings Save Path to "My Documents".
5. Detail View (object attributes) will now being adjusted under View menu.
6. Improved Stored Procedures/Functions Wizard as non-modal form.
7. Adjusted the file size behavior of "Use extended insert statements" when transfering to file.
8. Added execute time for Explain action under Message tab in Query.
9. Support Ctrl+Del shortcut to delete records.

Bug Fixes:

1. Fixed SSH Tunnel: BigInteger Overflow issue.
2. OCI settings was unable to be changed.
3. Fixed missing ROWID issue in Table Viewer.
4. Fixed the crash issue while doing the seach action in Query results.
5. Fixed field alias update/insert issue in Query.
6. Date became 0 while exporting to Excel.
7. Fixed password prompt issue while connecting to server in Data Transfer, Data/Structure Synchronization, Console and Server monitor.
8. Fixed GUI font size issue in Connection form.
9. Fixed columns missing while printing reports using schedule in command line
10. Fixed Virtual Grouping was unable to load.
11. When importing dbf/excel file floating values '.' or ',' as decimal separator, Navicat will now try both in order to recognize its proper floating values.
12. Navicat will now end to run the routine for Profile/Status if the Query has stopped by user.
13. Fixed access violation issue when deleted table in Query Builder after running the query.
14. Fixed file association for Windows Vista and Windows 7.

Upgrade Procedure : click here to upgrade

Navicat new logo design has been launched.

Upgrade Procedure : click here to upgrade

Bug Fixes:

• Query Builder failed to work for JOIN statement.

Download here

Upgrade Procedure : click here to upgrade

Improvement

• Added Ctrl+Q shortcut to popup new query.

Bug Fixes:

• Fixed "New Group" behavior in Schedule group setting.
• Hidden Primary Key setting for External table design.
• Fixed Access Violation error while running schedule for import in command line.
• Fixed Unicode error message issue.
• Fixed VARCHAR2 data type error in Dump SQL/Data Transfer.

Download here

Upgrade Procedure : click here to upgrade

Bug Fixes:

• Fixed incorrect negative value is fetched.

Download here

Upgrade Procedure : click here to upgrade

Enhancements:

1. Support of Oracle 8i.
2. Added smart auto-choosing Record Separator (CRLF, CR and LF) in Import Wizard.

Download here

New features:

1. Form View.
2. Foreign Key Data Selection - locate the available values from the reference table.
3. SQL Builder.
4. Import Wizard.
5. Export Wizard.
6. Data Transfer.
7. Data Synchronization.
8. Structure Synchronization.
9. Schedule.
10. Build in SQL*Plus.
11. Server Monitor.
12. Print Database/Table Structure.
13. Report Builder.

1. Added choosing of ServiceName/SID for connection string.
2. Added login as SYSDBA and SYSOPER.
3. Added login with OS Authentication.
4. Added Change Password prompt dialog when password expired.
5. Support of Recycle Bin object.
6. Code Completion for SQL Editors.
7. A DBMS output tab is added in Query.
8. Added Run button in Stored Procedure.
9. Added "Refresh Materialized View" in Navicat Main.

Download here

Improvements:

1. Support of OCI setting in Options.
2. Support of Java object (Source/Class/Resource).
3. Support of XML Schema object.
4. Support of External and Index Organized table.
5. Support of Physical Attributes in Table Design, Tablespace Design, Index Design, Materialized View Design and Materialized View Log Design.
6. Added syntax highlight for objects SQL Preview and DDL.
7. Added Object Information in object Popup menu under Others item.
8. Added Tablespace Objects in Object Information.
9. Added Dependencies in Object Information.
10. Added password prompt dialog for opening Table Shortcut when password not saved in Connection Properties.

1. Fixed the connect string problem for Oracle Client 9.
2. Fixed of binding multiple BLOB fields.

Upgrade Procedure : click here to upgrade

Improvements:

1. Edit Directory privileges provided.

1. When got focus on Connection icon in Navigation Pane, delete on database objects will not working.
2. Fixed privilege SQL creation while altering Collection Type.
3. Set DYNAMIC_FETCH_SIZE to 65536.
4. Fixed Max Size settings in Tablespace.
5. Fixed bug of dropping field

Upgrade Procedure : click here to upgrade

Main features:

Lastest Oracle versions support:

1. Compatible with Oracle servers version 9i, 10g and 11g.
2. Support of all Oracle objects and subobjects.
3. Support of character set and unicode.

Connection Management:

1. Multiple local/remote Oracle server connections.
2. Support of Basic (OCI) and TNS connection.
3. Connection to Oracle server through SSH.
4. Backup connection settings.

Well-designed user interface:

1. Customize of connection order.
2. Data are well shown in the tree view.
3. Provide well-vision for users in table grid.
4. Support dock windows.

Powerful data management tools:

1. Grid view.
2. Support of TEXT, Hex and BLOB/BFile viewer/editor.
3. Support of Copying and pasting selected records.
4. Customize display formats.
5. Incremental search, sorting and formatting table grid.
6. Ability to show/hide ROWID.
7. Ability to set number of records showing on each page.
8. Multiple SQL editors with syntax highlighted feature
9. Ability to preview SQL before execution.
10. Support of Query and Parameter Query.
11. Executing SQL script.

Additional features:

1. Support of Manage User.
2. Create table/view shortcut on desktop .
3. Support of Log files - keep track on the actions have been performed in Navicat.

Bug-fixes:

1. Fixed an issue where scheduled tasks failed to execute.
2. Fixed query result columns not retaining the order specified in the SELECT statement.
3. Fixed keyboard navigation problems in the Import Wizard.
4. Fixed custom column widths resetting to default when changing a field's data type in the Import Wizard.
5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

AI Integration in Table Designer & Data Editor

1. Fill with AI - Update, generate, or summarize column data directly within the grid.
2. Ask AI - Construct entire schema structures using natural language prompts.
3. Fill Comment with AI - Generate table summary based on field definitions.

Code Insight in Query Editing

1. Refactoring - Rename symbols, aliases, and identifiers uniformly across scripts.
2. Hover Info - Quick-access metadata previews when hovering over SQL elements.
3. Real-Time Error Detection - Real-time syntax flaw and invalid schema object detection.
4. Highlight Usages - One-click symbol usage tracing within the editor.
5. Go to Declaration - Direct navigation to underlying object definitions.

Data Masking

1. Secure sensitive production records and generate test datasets.
2. Support Masking Technique - Substitution, Variance, Shuffling, Hashing, and Nulling.

Data Modeling

1. Hybrid Model - Bridge logical entities and physical structures within a single model.
2. Naming Standards & Glossary - Support centralized glossaries and standardized naming rules across schemas.
3. Bulk Editor - View and edit fields across multiple tables simultaneously.
4. Import SQL to Model - Generate data models directly from SQL scripts.
5. Diagram Add-ons - Move Fields Between Tables, Create New Table & Alignment Guide.

Interactive BI

1. Auto Tile Layer - Automatic dynamic chart alignment and resizing for dashboard layouts.
2. Parameters - Dynamic workspace-wide parameters for cross-visual data filtering.
3. Dashboard Add-ons - Auto Refresh, Page Navigation links & Alignment Guide.

Usability & Workspace Improvements

1. Reimagined Import Wizard - Redesigned into a single-step workflow with live preview panes.
2. Parquet Support - Native support for importing Apache Parquet files.
3. Batch Editing - Batch record modifications with a manual Apply/Discard bar.
4. Session History - Track and audit for SQL queries executed during data editing sessions.
5. Side-panel Record Navigation - Quick-jump navigation panel in Form View.
6. Conditional Data Synchronization - Set custom filter conditions during data synchronization.
7. Personal Profile Sync - Synchronize connection profiles, table preferences, starred settings, and coloring info across Navicat Cloud and Navicat On-Prem Server.
8. And More.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. The table comment in the data dictionary was stretched off the page.
2. Unable to display the complete text in the data grid after moving Navicat to a larger monitor.
3. Crashed when using Model workspace in some cases.
4. Opening databases in Query Builder was slow.
5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Crashed when using data transfer in some cases.
2. Some words were collapsed when adding lines in the Query Editor.
3. Unable to save cardinality settings in the model diagram.
4. Incorrect time displayed in the log of Data Dictionary.
5. Error occurred when opening the exported Excel file.
6. 'Parameter is incorrect' error returned when creating schedule to run the batch job.
7. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. ORA-01002 error occurred when exporting Oracle data.
2. Unable to save changes after updating foreign key names in the model.
3. Scrolling skipped two rows in the data viewer.
4. 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

Note: The Report feature has been deprecated.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Undoing changes in a function incorrectly cleared all code.
2. Time values imported from Access database were incorrect.
3. 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. Unable to handle CASE statement when using Query Builder.
3. Access Violation error occurred when copying procedure results.
4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Oracle query only accepted SCHEMA.TABLE syntax.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to show tables when using Oracle OS authentication.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to show tables when using Oracle OS authentication.
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. Unable to change primary key name.
4. 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. Column sizes did not persist when refreshing table.
5. Crashed when using "Filter & Sort".
6. 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 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.

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.

Bug-fixes:

1. Source connection info was not pre-populated in the Structure Synchronization window.
2. Model diagram disappeared when hovering over.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Main New Features:

1. Enhanced Query Editor
2. Enhanced BI Feature
3. New Filter & Sort Layout
4. Many other new features and improvements

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Crashed when clicking the Options button in the Data Generation window.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Foreign keys were not deleted when deleting the parent table in the model.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Invalid file format error occurred when opening a model workspace.
2. Crashed when opening a model workspace in some cases.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Keyboard support failure in Data Viewer.
2. The reference field was not updated when changing the primary key field in the model.
3. Non-filtering objects did not hide in the overview navigator of ER Diagram.
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. All-New Model Workspace
2. Data Profiling
3. Data Dictionary
4. Query Pinned Result
5. Table Profile
6. Navicat URI
7. Manage Connection
8. Enhanced BI Feature
9. Focus Mode
10. Many other new features and improvements

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to show data in some cases.
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 importing paradox files.
2. Failed to import JSON file from web service.
3. Refresh button did not work in Server Monitor.
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. 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. 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. 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. 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.

Bug-fixes:

1. Cannot type a new name for the table in Import Wizard.
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.

Improvements:

1. Support unix socket forwarding in SSH.

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. Query Builder window was larger than the screen in some cases.
2. Unable to display the data differences of TEXT fields in Data Synchronization.
3. The second field was selected when adding a sort condition in Table Viewer.
4. Crashed when stopping Data Transfer process.
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.

Improvements:

1. Support OceanBase Oracle Mode.

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

Bug-fixes:

1. Cannot display column comment when mouse over in dark mode.
2. Data Synchronization did not work in Automation.
3. "Failed to send mail. Stream error." occurred when sending email.
4. 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.

Bug-fixes:

1. Bar chart label display issue.
2. Unable to export Excel file in some cases.
3. Hanged when transferring tables.
4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Font size issue in Form View.
2. Buttons in the lower right corner of the main window were missing in some cases.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Crashed when changing the chart type in some cases.
2. Hanged when deleting a table in Query Builder.
3. Text color issue in Dark Mode.
4. Unable to connect AWS RDS database via SSH.
5. Backup and Dump SQL File was slow in some cases.
6. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to open the objects in the "Find in Database" window.
2. The first number of every value in the list was removed in the table filter.
3. Unknown Internal Error occurred when updating query results in some cases.
4. Unable to use "Copy As" in View results.
5. Crashed when opening functions in some cases.
6. Unknown Internal Error occurred when foreign key selection window popped up.
7. Crashed when clicking on the value box in table filter.
8. Cannot retain the window size and position for existing objects.
9. 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.

Bug-fixes:

1. Query parameters did not work in some cases.
2. Decimal precision issue when importing from Excel files.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Crashed when opening large tables.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unknown Internal Error occurred when exporting large amount of data.
2. Unable to sign in Subscription plan.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Crashed when running Automation in some cases.
2. Missing the first record when import.
3. Unable to locate project when running batch job.
4. Unable to get table information when scheduling data synchronization.
5. Refresh button ran all SQLs in Query Editor.
6. .0000 data export issue.
7. Navicat exited when clicking the Type column in Table Designer.
8. Crashed when batch querying tables with FK dependency.
9. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to close the error dialog when changing field name in model canvas.
2. Unable to close the error dialog when editing chart y-axis range.
3. Failed to transfer large tables.
4. SSH connection issue when using Automation.
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. The "Compare" button did not work in Data Synchronization in some cases.
2. "Couldn't open known_hosts file" error occurred when the SSH path contained Chinese characters.
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. Connection password issue when updating connection in Navicat Cloud.
2. Error occurred when synchronizing to Navicat Cloud.
3. Unable to view and edit user/role privileges.
4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Notification Email authentication failed in some cases.
2. 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. Query Execution Summary
4. Navicat On-Prem Server is released
5. 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. No data value on the label when exporting a chart to a PDF file.
3. Unable to rename a view inside a group in Navicat Cloud.
4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to show accurate value of Oracle BINARY_DOUBLE type.
2. Unknown Internal Error occurred when importing Excel file in some cases.
3. An empty string was not quoted when exporting to a text file.
4. Query was garbled when the system locale set to Japanese.
5. Export/Import profile did not work if it was copied to Desktop.
6. 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. Unable to rename Oracle views when the "Use custom database list" option is enabled.
3. Error occurred when using Recordset Generator to generate a record set for the Date field.
4. Hanged when designing a table with many fields.
5. Relation lines were disappeared after saving and reopening Logical Model.
6. 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. 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. Notification email subject was incorrect when the job finished unsuccessfully.
3. Cursor focusing issue when using Find feature in Table Viewer.
4. 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. Unable to load version 10 data synchronization profiles.
4. 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. Unknown Internal Error occurred when executing Oracle's package body.
4. Unable to display full Oracle view definition 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. "Unknown Internal Error (A70529211102SE)" error occurred when exporting / importing data.
5. Slow issue when transferring large tables.
6. Unable to show the inputted text in Filter Wizard.
7. Error occurred when filtering data by right-clicking a cell in Table Viewer.
8. Inserted records to the wrong table when transferring data to the target table with a different name.
9. 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. Double quotes were added to the fields of a compound index in Oracle.
6. 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. Unable to set data to NULL in query results.
2. Crashed when clicking the ellipsis button in Custom Recordset.
3. Pasting data into a column cleared another column data.
4. Default Settings Location path was set to a wrong location for some cases.
5. "Floating point division by zero" error occurred when setting the dashboard background.
6. The file extension was missing when exporting the dashboard.
7. Query Parameter did not work when using a parameter twice.
8. "Invalid floating point operation" error occurred when adding NULL data to the chart.
9. Incorrect columns were displayed after clicking the Default button in the "Choose columns" window
10. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to export data to .mdb files.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unknown Internal error occurred when opening Oracle tables.
2. Unable to set default value for fields in Table Designer.
3. Data Pump Import's Table Exists Action drop-down list options were incorrect.
4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Incorrect SQL generated when transferring Oracle tables.
2. Invalid XML error occurred when importing connections.
3. Differences was detected in re-comparison in Structure Synchronization and Synchronize to Database.
4. Incorrect data was updated when saving ; in a non-text field.
5. Incorrect SQL generated for altering fields in Structure Synchronization.
6. Incorrect items were displayed in suggestion list when using code completion with alias.
7. Minor bug fixes 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. Query wrongly returned null results in some cases.
2. "," was replaced by "." when using Custom Filter in Table Viewer.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Improvements:

1. Added "Table Relation" and "Field Relation" options to Query Builder.
2. Added Connection Coloring to Query windows.

Bug-fixes:

1. Unknown Internal Error occurred when starting Navicat in some cases.
2. Crashed when importing two XML files.
3. Popup menu was missing when right-clicking on stored procedure results.
4. The performance of Privilege Manager was slow.
5. Refresh button in Privilege Manager did not pull the latest privileges.
6. Differences were detected after synchronizing model to database.
7. Syntax error occurred when saving procedures in some cases.
8. Datetime functions generated text in exported Excel files.
9. Hanged when searching regular expression in Query Editor.
10. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Only the first batch was transferred when "Number of row per batch" was enabled.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Improvements:

1. Added "Keep Orthogonal Layout" to Model.

Bug-fixes:

1. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Improvements:

1. Added shortcuts for "Run Current Statement" and "Select Current Statement" in Query Editor.

Bug-fixes:

1. "Unknown Internal Error" occurred when modeling databases.
2. Find bar UI issue in Data Viewer.
3. Unable to print table when using popup menu on Navigation pane.
4. Explain feature did not work with query parameters.
5. Interval type was not supported in Charts.
6. Highlight color issue in Filter wizard when using Dark mode.
7. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Wrong options were selected when loading another Data Transfer profile.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. OCI Environment setting was unable to save.
2. "Invalid floating point operation" error occurred when resizing tables in View Builder.
3. Multiple primary key names were generated when exporting model to SQL files.
4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Access violation error occurred when adding users to Navicat Cloud project.
2. Access Denied error occurred when designing table.
3. Unable to highlight field when typing in Filter's field selection list.
4. Wrong fields are exported to the SQL file when not all fields are selected.
5. Dark theme kept reverting back to Normal theme.
6. Wrong CREATE INDEX was generated in Model.
7. Empty value was exported as **** when exporting DBF file.
8. Data Transfer high memory consumption issue.
9. Run queries slow issue.
10. "List index out of bounds (-1)" error occurred when editing role privileges.
11. "Last Tab Window" option was missing.

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. Down arrow key did not highlight table grid cell in some cases.
2. 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. Unable to dump the default value of TIMESTAMP field.
3. Synchronize to Database feature wrongly detected differences of unique constraints.
4. 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. Unable to map a source field to multiple target fields in Import Wizard.
4. "Cannot open file" error occurred when scheduling export profiles in some cases.
5. Unable to show empty fields in query result sets.
6. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. "Unknown Internal Error" occurred when opening Table Designer.
2. 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. Primary Key checkbox was deselected when tabbing to the next field in Table Designer.
2. "Unknown Internal" error occurred when importing data.
3. The deployment scripts generated incorrect default value in Structure Synchronization.
4. "Access Violation" error occurred after editing the data pipeline in Report.
5. "Unknown Internal" error occurred when using Automation.
6. 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. Crashed when opening Oracle table with Spatial data.
4. A table was mistakenly transferred even it was not selected.
5. Incorrect syntax highlighting issue in Query Editor.
6. Filter criteria input box was not retained when switching applications.
7. Drag and drop selected text on Query Editor did not move the text.
8. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Crashed when opening Oracle table with Spatial data.
2. Code completion box displayed off the bottom of the screen and partially obscured.
3. Unable to customize query result tab name by using /*NAME:XYZ*/ .
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. Importing files to Oracle server was slow.
8. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to change variable's value when debugging Oracle function.
2. SQL order issue in Structure Synchronization.
3. Console window was not colored when connection coloring were set.
4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. List index out of bounds error occurred when inserting data in Table Viewer.
2. Unable to shrink the last column on the Process List tab in Server Monitor.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Slow performance when editing users or roles.
2. Unable to show the ROWID column when running Oracle queries.
3. Floating point numbers were rounded to decimals when import.
4. <html> tag was repeated twice when exporting HTML files.
5. "Add Database to List" button was enabled when the "Use custom database list" option was not checked.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Custom Filter was cleared when editing it.
2. DBMS Output result was incomplete.
3. HTML export did not specify charset.
4. "Show/Hide Columns" option was missing in Form View.
5. The hidden Information pane was shown when switching from Form View to Grid View.
6. Cursor focus issue in Form View.
7. Code Completion did not work in some cases.
8. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. "SQLite function sqlite_libversion cannot linked" error occurred when starting Navicat.
2. Unable to scroll inside the text box in Form View.
3. "is in list" operator in Filter Wizard did not working correctly.
4. Structure Synchronization compared table options.
5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unknown Internal Error occurred when showing data "{}" in TEXT editor.
2. Esc shortcut did not work when error occurred during deleting records.
3. Error occurred when renaming an existing column and adding a new one.
4. Filter value did not displayed when the string exceeded 5880 characters.
5. Unable to display the columns list in Table Designer's Index tab when there was no index.
6. Unable to apply Filter profile.
7. Unable to scroll to right in Filter Wizard.
8. Opening Design Table froze in large database.
9. "Open Table" and "Design Table" were not properly synchronized.
10. Import Target and Field Mapping changed after changing the source file in profile.

To upgrade, please visit our Customer Center.

Improvements:

1. Improved Filter Wizard.
2. Supported expression for default field value in Table Designer.

Bug-fixes:

1. Crashed when applying filter in Foreign Key Selection window.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Main New Features:

1. Brand new Filter Wizard
2. UI and UX Improvement
3. MongoDB is added in Navicat Premium
4. 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. .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. Transaction did not end after closing the table in some cases.
4. Error occurred when there was a "CRLF" character in Oracle procedure.

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. Unknown Internal Error occurred when importing from ODBC.
4. Syntax error occurred when importing CSV files in some cases.
5. Database names were missing in the Drop SQL generated by Structure Synchronization.
6. ORA-01830 error occurred when transferring tables to Oracle server in some cases.
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. Encoding issue of the exported text file.
13. Crashed when the Oracle host name was longer than 1000.

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.

Bug Fixes:

1. Spaces were missing in the SQL exported from Model.
2. Extra newlines were added to the SQL exported from Model.
3. "Hourly" option was missing on Task Schedule's Trigger tab.
4. Wrong datestamp was appended to the exported files.
5. Slow issue when searching in Table Viewer.
6. Unable to move functions into a group.
7. Target functions/procedures were not dropped before create when synchronizing structure.
8. Unable to synchronize models/queries in Navicat Cloud.
9. Exported Excel files were corrupted in some cases.
10. "Access is denied" error occurred when setting schedule.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Error occurred when synchronizing structure in some cases.
2. Replace All did not work in Table Viewer.
3. Cell selection disappeared after pressing CTRL+C in Table Viewer.
4. Error occurred when running query in some cases.
5. "Unknown Internal Error" occurred when exporting query results.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Unknown Internal error occurred when editing/adding connections.
2. Adding self-referencing table issue in Query Builder.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Out of memory issue when running Data Transfer.
2. "Unknown Internal Error" occurred when loading profiles in Structure Synchronization.
3. Export Float data to csv files issue.
4. Unable to display Oracle Chinese data in some cases.
5. Crashed when importing Excel or Text files in some cases.
6. Opening large databases in List View took long time.
7. Unable to show query files with ".SQL" extension in Objects tab.
8. The length of NVARCHAR fields were missing when exporting models to SQL files.
9. CTRL+SPACE shortcut were missing in Query Editor.
10. Target's default Tablespace were not used in Data Transfer.
11. Print report to PDF command wrongly sent the report to printer.
12. Null date values were exported wrongly as "1900-01-00" in Excel files.
13. Tables Viewer displayed wrong number of digits.
14. Input parameter window did not pop up when exporting query.
15. High CPU usage issue.

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 zoom in/out Query Editor using mouse wheel.
2. Swapping connections did not work when re-comparing in Data Synchronization.
3. Code Completion did not work when logged in with non DBA users.
4. Syntax errors occurred when running query in some cases.
5. Unknown Internal error occurred when performing Structure Synchronization.
6. Query syntax highlight was wrong after switching tabs.
7. DateTime field Not Null checkbox unchecked wrongly in Table Designer.
8. Unable to export table to xlsx with name longer than 31 characters.
9. Hanged when searching in Table Viewer in some cases.

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.
4. Unknown Internal Error occurred when performing Structure Synchronization.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Fixed exporting numbers to Excel issue.
2. Fixed importing connections with Settings Location issue.
3. Fixed ER diagram layout issue.
4. Table groups were not synchronized to other members in Navicat Cloud.
5. Wrong SQLs were generated when inserting fields in Table Designer.
6. Unable to run CREATE PROCEDURE statements in Query Editor.
7. Unable to save function after changing parameter names.
8. Unable to import DBF files.
9. Identifiers panel retained when opening new query window.
10. The Stop button in Export Wizard did not work properly.
11. Unknown Internal Error occurred when typing in Query Editor.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Record delimiter was wrong when exporting to text file using Automation.
2. Table Viewer moved back to the first page when refreshing a table.
3. Unable to dump Oracle tables to SQL files.
4. Unable to show synonyms in the Objects tab.
5. Characters displayed wrongly in Table Viewer.
6. Error occurred when adding fields in Oracle table.
7. Unable to select fields when exporting to Excel file.
8. Hanged when closing connection on less session environment.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Error occurred when deleting INT field value in Table Viewer.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Wrongly shown differences when synchronizing structure.
2. The DDL tab in Information pane did not updated after saving changes in sub forms.
3. Unknown Internal Error occurred when synchronizing structure/data in some cases.
4. Unable to schedule Data Synchronization profiles.
5. Syntax error occurred when filtering with ' character in Table Viewer.
6. Input decimal separator issue in Table Viewer.
7. Unable to import date from Excel to VARCHAR field.
8. Query Builder loading was slow.
9. Re-registration issue.
10. Unable to create new table in Import Wizard in some cases.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Table triggers was not included when backing up tables.
2. Auto increment field was ignored when importing
3. Navicat hanged when running a query export profile in some cases.
4. Error occurred when running LOAD DATA LOCAL queries.
5. Special characters were garbled when exporting Access files.
6. Unknown Internal error occurred when exporting Access files.
7. Unknown Internal error occurred when saving changes in Table Designer.
8. "Too many client tasks" error occurred when importing Access files.
9. Double-quote encased text fields were split into new records when importing a record which multiple lines.
10. Syntax error occurred when performing data transfer in some cases.
11. Unknown Internal error occurred when adding multiple records in Table Viewer.
12. Two identical functions declared as different in Structure Synchronization.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Unable to open Information pane by context menu.
2. Unable to import fixed width text file in some cases.
3. Access Violation error occurred when creating models / tables in some cases.
4. Access Violation error occurred after Navicat was idle.
5. ORA-01861 error occurred when importing Excel files.
6. Unable to import the CDATA data in XML files.
7. Number values were exported as text in Excel files.
8. Code completion did not work for alias in SQL Editor.
9. Beautify SQL did not format multiple statements properly in SQL Editor.
10. Unknown Internal error occurred when running query with parameters.
11. Table menu displayed wrong item in some cases.
12. Unknown Internal error occurred when running old version export profiles in Automation.
13. Unknown Internal error occurred when opening tables in some cases.
14. Wrong syntax displayed for PostgreSQL in Function Designer.
15. "_Navicat_Temp_Stored_Proc() does not exist" error occurred when saving functions.
16. High memory usage issue in Data Synchronization.
17. "Use empty string as NULL" option did not work in Import Wizard.
18. Unknown Internal error occurred when writing query in some cases.
19. Unknown Internal error occurred when backup in Automation in some cases.
20. Hang issue occurred when launching Import Wizard.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Unable to import Chinese characters from Excel files.
2. Incorrect date and decimal formats in exported Excel files.
3. Filter criteria settings were removed when applying sorting on column.
4. Unknown Internal Error occurred when executing old version export profiles in Batch Job.
5. Unknown Internal Error occurred when loading Filter profiles in Table Viewer.
6. File path and file name were not saved in Export profiles.
7. Unknown Internal Error occurred when there was multiple statements in Query.
8. Incorrect field names were shown in code completion suggestion list.
9. Unable to attach the report PDF file in notification email.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. "Unknown Internal Error" occurred when typing statement in SQL Editor.
2. Unable to show field names in data pipeline after editing SQL in Report.
3. Beautify SQL formatted the statement wrongly in some cases.
4. Sorting by modified/create date did not work for details view in main window.
5. Connection coloring displayed wrong color in some cases.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Wrong table showed when comparing tables in Data Synchronization in some cases.
2. Unable to import special characters from Excel.
3. Unable to paste multiple records in Table Viewer.
4. Created Batch Jobs did not show in Standard Edition.
5. "Unknown Internal Error" occurred when importing files.
6. View Builder locked up when re-open for editing in some cases.
7. Unable to log in Oracle server using lower case username.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. "Access violation" error occurred when create new query/view.
2. Wrongly showed primary key warning in some cases.
3. Unable to type some characters in editor when using international keyboard.
4. Unable to edit connection settings in some cases.
5. Information Pane did not appear in some cases.
6. "Oracle Library not loaded" error occurred when connecting.
7. Internal error occurred when importing CSV files.
8. Cell values froze when scrolling in grid view.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Failed to load Data Synchronization profiles.
2. Data display issues in table viewer.
3. Minor bug fixes and improvements.

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. Fixed the CREATE PACKAGE and CREATE PACKAGE BODY issue in SQL Editor.
2. Error occurred when exporting with Time field type.
3. Removed "WHEN()" if "When Clause" is NULL for trigger.
4. Wrong SQL statements were generated wrong when running "Synchronize to Database" in Model.
5. Fixed the varchar2 issue when running "Synchronize to Database" in Model.
6. 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 Query in some cases.
2. Query auto-save feature did not work in some cases.

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. Fixed the sorting issue in Table Viewer.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Copy and paste issue in Table Viewer's Memo Editor.
2. "Date format is too long for internal buffers" error occurred when viewing Oracle tables in some cases.

To upgrade, please visit our Customer Center.

Improvements:

1. Support inputting tabs in the editor of Table Designer.
2. Support UTF16 formatted files in Execute SQL File and Query's Import SQL functions.

Bug Fixes:

1. The media keys (play, pause, next etc) did not work.
2. Failed to transfer data in Chinese locale OS.
3. Crashed when synchronizing model to database in some cases.
4. Unable to show the light coloring when the tab is non-active.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. The datetime field values were inconsistent in exported file.
2. Error occurred when adding tables to report.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Unable to add tables to Report's Query Wizard and Query Designer when the table name contained dot.
2. Error occurred when logging in Navicat Cloud if profile path contained Unicode.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Failed to get Oracle Materialized View information for Code Completion.
2. Fixed multi-monitor with different dpi issue.
3. Column import definition broken when importing.
4. Saved Import profile mapped columns wrongly.
5. "invalid varient operation" error occurred when import from ODBC.
6. "Argument out of range" error occurred when importing CSV file.
7. Primary Key settings were deleted when modifying import profile.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Error "Diagram table already exists" occurred when opening some model files.
2. Crashed when exporting connections.
3. "Access violation" error occurred when importing CSV file.

To upgrade, please visit our Customer Center.