Notes de version

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. 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. Error occurred when duplicating SQL Server tables.
2. Response was slow when hovering over the menu bar.
3. Crashed when starting Navicat in some cases.
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. No tables listed when reverse engineering SQL Server databases to model.
3. Model diagram disappeared when hovering over.
4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Main New Features:

1. Support Visual Query Explain for SQL Server
2. Enhanced Query Editor
3. Enhanced BI Feature
4. New Filter & Sort Layout
5. 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.

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. 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. Code Completion did not work properly in SQL Server queries.
5. The comment code shortcut did not work in some cases.
6. Unknown Internal Error occurred when transferring data.
7. 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. Naming issue in the Foreign Keys tab of SQL Server Table Designer.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Crashed when opening Charts workspaces in some cases.
2. "The number of row value expressions in the INSERT statement exceeds the maximum allowed number of 1000 row values." error occurred when importing data to SQL Server.
3. Crashed when scheduling import jobs.
4. Missing records when importing files in some cases.
5. Special characters were garbled when using double-click to add a snippet to the query.
6. 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. "Parameters supplied for object 'xxx' which is not a function" error occurred when adding record in some cases.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Main New Features:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to Import MySQL Longtext data to SQL Server.
2. Query Builder window was larger than the screen in some cases.
3. Unable to display the data differences of TEXT fields in Data Synchronization.
4. The second field was selected when adding a sort condition in Table Viewer.
5. Crashed when stopping Data Transfer process.
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. 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. "Default or null are not allowed as explicit identity values" error occurred when inserting a row in SQL Server table.
3. Data Synchronization did not work in Automation.
4. "Failed to send mail. Stream error." occurred when sending email.
5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to list tables or views in Azure SQL Database connection.
2. "Cannot open source table" error occurred when using Condition Query in Import Wizard.
3. Exporting to Excel file was slow.
4. 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. SQL Server datetimeoddset column did not display the timezone offset.
5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Main New Features:

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

To upgrade, please visit our Customer Center.

Main New Features:

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

Additional Features:

1. Connection Profiles
2. Field Information Pane
3. 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 synchronize decimal precision from a model to SQL Server database.
4. Unable to rename a view inside a group in Navicat Cloud.
5. Cannot connect to Microsoft Azure Database in some cases.
6. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unknown Internal Error occurred when importing Excel file in some cases.
2. Wrong SQL generated when comparing SQL Server tables with different constraint names.
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. Error occurred when using Recordset Generator to generate a record set for the Date field.
3. Hanged when designing a table with many fields.
4. Relation lines were disappeared after saving and reopening Logical Model.
5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to exclude collations when synchronizing a model to a database.
2. ER diagram was reloaded when clicking the Design Table button.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to 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. Error occurred when modifying the value in a DateTimeOffset field.
4. Unable to load version 10 data synchronization profiles.
5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to import MEMO data from DBF files.
2. Unable to reconnect SSH connection after the PC woke up.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. "IDENTITY_INSERT is already ON" error occurred when synchronizing SQL Server tables.
2. Unable to show records that had -1 data in Table Viewer.
3. "Drop target objects before create" option did not work in Data Transfer.
4. Memory leak issue when enabled code completion.
5. "Unknown Internal Error (A70529211102SE)" error occurred when exporting / importing data.
6. Slow issue when transferring large tables.
7. Unable to show the inputted text in Filter Wizard.
8. Error occurred when filtering data by right-clicking a cell in Table Viewer.
9. Inserted records to the wrong table when transferring data to the target table with a different name.
10. 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. Wrong SQL generated when adding aggregates using Query Builder in SQL Server.
6. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Improvements:

1. Support Active Directory authentication method for SQL Server.
2. Integer column exported in Number format when exporting Excel file.
3. 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 set SET IDENTITY_INSERT ON in Data Synchronization.
2. Unable to export data to .mdb files.
3. 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. 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. 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. "IDENTITY_INSERT is already ON for table" error occurred when transferring tables (SQL Server).
6. Unable to show empty fields in query result sets.
7. 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. Unable to set the precision of "datetime2" data type to 0 in Table Designer.
4. The deployment scripts generated incorrect default value in Structure Synchronization.
5. "Access Violation" error occurred after editing the data pipeline in Report.
6. "Unknown Internal" error occurred when using Automation.
7. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

1. SQL order issue in Structure Synchronization.
2. Console window was not colored when connection coloring were set.
3. 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.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Zero decimal place digits were not displayed in Table Viewer.
2. "Double" format issue for SQL Server in Table Viewer.
3. Exported SQL file did not have table name when exporting an unsaved query.
4. Unknown Internal Error occurred when importing from ODBC.
5. Syntax error occurred when importing CSV files in some cases.
6. Database names were missing in the Drop SQL generated by Structure Synchronization.
7. Unable to change the Tab Width in Query Editor.
8. Unable to edit query results when tables had alias.
9. Procedure parameters were missing in the scripts generated by Structure Synchronization.
10. Unknown Internal Error occurred when Automation ran.
11. Unable to transfer tables with HEX format.
12. Encoding issue of the exported text file.

To upgrade, please visit our Customer Center.

Bug Fixes:

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

To upgrade, please visit our Customer Center.

Bug Fixes:

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

To upgrade, please visit our Customer Center.

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.

New Features:

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

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Error occurred when exporting with Time field type.
2. Error occurred when importing identity column.
3. Unable to insert trigger in Table Viewer.
4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Crashed when using Query in some cases.
2. "IGNORE_DUP_KEY" was always set to "ON" for SQL Server in Structure Synchronization.
3. 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 session break with identity insert SQL issue for SQL Server in Data Transfer.
2. Fixed the sorting issue in Table Viewer.
3. Unable to select database and schema for SQL Server 2000 in "Find in Schema".

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Copy and paste issue in Table Viewer's Memo Editor.

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.

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

To upgrade, please visit our Customer Center.

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.

Bug Fixes:

1. Unable to alter SQL Server 2014 database compatibility levels.
2. Failed to generate field comment SQL of newly created field in existing SQL Server table.
3. Generated insert/update statements with SQL Server identity column in Import Wizard.
4. Data started with single quote issue in exported Excel file.
5. Generated COLLATE clause for incorrect SQL Server data types in Data Modeling Tool.
6. Generated DROP COLUMN and ADD COLUMN into single SQL statement for SQL Server in Table Design

To upgrade, please visit our Customer Center.

Improvements:

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. Database properties not able to alter proper compatibility levels.
3. Crashed when loading and parsing a long incorrect syntax SQL in Query.
4. After adding a new row, pressing next/last button would freeze the Form View in Table Viewer.
5. Number of rows selected incorrectly when using shift+up/down keys in Table Viewer.
6. Multiple selection not working properly with shift+keys in Table Viewer.
7. When using CTRL+A to select text inside a data cell, all cells were incorrectly selected in Table Viewer.
8. Import Paradox not able to import data properly in Navicat 64bits.
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.

Improvements:

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. datetime2 value with fractional seconds not able to import using Import Wizard.
4. Binary Data Encoding option was ignored in Import Wizard if string data type existed.
5. DateTime with fractional precision not handling correctly in Export Wizard.
6. 'Table does not exist' error occured while opening an export profile.
7. 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. Wrong Date Editor frame size in Table Viewer.
6. Stack Overflow error when running Query.
7. Permissions issue of the Updater.
8. 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.
3. Failed to get the accurate fraction part of date time data.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Failed to identify the correct installed Native Client version.
2. Failed to check/uncheck column fields in Show/Hide Columns using space key in Tabler Viewer.
3. Failed to scroll horizontally for wide content after applying Filter Wizard in Table Viewer.

To upgrade, please visit our Customer Center.

Bug Fixes:

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

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Fixed timeout reconnect issue.
2. SQL Server PRINT message was not showed.
3. Column width not able to be reset after showing the hidden column in Table Viewer.
4. Access violation occured in Table Viewer while reconnecting SSH connection with another port.
5. Query message in status bar not updated if no result return after Run.
6. Certain function not copies over in a Data Transfer profile.
7. Synchronize to database in Data Modeling Tool generated column SQL with multiple identity columns.

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. SQL Server Backup

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.

Improvements:

1. Allow max SQL Server datatype (varchar, nvarchar, varbinary) in Data Synchronization.

Bug Fixes:

1. Synchronize to Database function in Data Modeling Tool genarated incorrect comparison result for equivalent source and target foreign keys.
2. "List index out of bounds" error occurred when some source fields were removed after import profile were created during Import Wizard.
3. When "Run multiple queries in each execution" option is checked, character data was unable to import correctly in Import Wizard.

To upgrade, please visit our Customer Center.

Improvements:

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

Bug Fixes:

1. Wrong time unit (ms) was shown under Messages tab in Query function.
2. Table Designer in Data Modeling Tool was unable to save newly added index and foreign key.
3. 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. "Execute SQL File" was unable to parse a query if 'GO' characters contained in a word.
2. "Synchronize to Database" function in Data Modeling Tool was unable to generate SCHEMA property in comment SQL.
3. Empty named relation was unable to load back in Data Modeling Tool.
4. "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.

Improvements:

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. Stored Procedure only showed the final message after multiple PRINT statements.

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. Execute SQL File function would not run if there was an identifier contains "GO" characters.
5. "double" data type was not being handled properly in Export Wizard.

To upgrade, please visit our Customer Center.

Improvement:

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

Bug Fixes:

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

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Collation in Database Properties not able to set since wrong SQL generation.
2. Not able to open schema for databases with non-default database collation in SQL Server 2000.
3. Crash occurred when closing Synchronize to Database in Modeler during the comparison in progress.
4. Crash occurred while renaming table failed with server error in ER-diagram view.
5. 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.
3. Failed to execute a Stored function with some field types.

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. Structure Synchronization produced invalid pointer exception error when comparing stored procedures.
4. 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.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. New version of Native Client could not be recognized.
2. Failed to set open status for database in Connection Properties.
3. The highlighted items from the previous searching results in Table Designer was failed to clear for the next searching.
4. Table Designer did not accept an index name with over 30 characters long.
5. Parse could not apply on a running SQL in Query form.
6. Failed to match source column data to the corresponding column during Import Wizard.

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.
6. "[Err] Field 'COUNT(1)' not found" error occured when applying Update mode in Import Wizard.
7. Permission denied on object 'sysproperties'.
8. Import Wizard was unable to import string data to varchar, varchar(max), text field properly.

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. Navicat Main was unable to list huge number of Logins.
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. Procedure names were unable to locate from Data Transfer.
5. Failed to run multiple Data Synchronization at the same time.
6. Table with identity fields was not working correctly in Data Synchronization.

To upgrade, please visit our Customer Center

New Feature:

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

Improvements:

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

To upgrade, please visit our Customer Center

Improvements:

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

Bug Fixes:

1. "Failed to parse code near RESTRICT" error occurred when updaing/deleting a foreign key to a field with RESTRICT action in Table Designer.
2. SQL Server export view profile did not show in list.
3. Multiple files with files delimited as '|' were unable to be recognized during Import Wizard.
4. Date format were fixed in Data Transfer.

To upgrade, please visit our Customer Center

Bug Fixes:

1. Limit Records feature did not work in Table Viewer.
2. When altered procedure, SQL would be missing a dot between schema name and object name during Structure Synchronization.
3. DBF character field length would be set to 254 if table field length is 0 while exporting to DBF file.
4. Tree node was unable to be highlighted when Connection Coloring feature was applied under Windows XP.

To upgrade, please visit our Customer Center

Improvements:

1. Improves performance in Table Viewer.

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.
4. Fixed no permission returned when getting row count of table.

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

Main Features:

Common SQL Server support:

1. Support SQL Server 2000, 2005, 2008 and 2008R2.
2. Support of most SQL Server objects and subobjects
3. Support of character set and unicode.

Connection Management:

1. Multiple local/remote SQL Server server connections.
2. Connection to SQL Server through SSH.
3. Keep connection alive.
4. Import/Export connections settings.

Well-designed user interface:

1. Virtual Grouping for connections and objects.
2. Connection Coloring.
3. Customize of connection order.
4. Grid View and Form View support.
5. Well-described Wizard System.
6. Provide well-vision for users in table grid.
7. Support dock windows.

Powerful data management tool:

1. Foreign Key Data Selection.
2. Supports Parameter Query.
3. Import and Export support.
4. Data Transfer support.
5. Data Synchronization support.
6. Structure Synchronization support.
7. Schedule for Batch Job.

Visual Designer:

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

Server Security and Maintenance Services:

1. Visual user/role management.
2. Visual privilege manager.
3. Maintance database / schema objects.
4. Server Monitor.

Additional features:

1. UUID/GUID generator.
2. Code outline.
3. Print Schema / Table Structure.
4. Support of setting global Row Height and Column Width in table grid.
5. Support of Word Wrap.
6. Provides a short-cut to terminate a running query.
7. Code Folding.
8. Matched Brace/Bracket Highlighting.
9. Parameter Tips.
10. Zoom In/Out for SQL editors.
11. SQL Beautifier.
12. Favorites.
13. Object Filter.
14. Unicode Character Report.
15. Auto save in Query, Function etc.
16. Custom sort in Tabler Viewer.
17. Notification email supports SSL/TLS in Schedule.
18. SQL Console.
19. History Log Viewer.

Download here

Bug-fixes:

1. Crashed when finding data in query results.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Time delay when reporting errors.
2. Wrongly displayed German in UI.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to show the trigger definition after reordering the trigger in Table Designer.
2. Error occurred when duplicating SQL Server tables.
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. Incorrectly setting all values in the row to NULL, not just the selected cell.
2. No tables listed when reverse engineering SQL Server databases to model.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Model diagram disappeared when hovering over.
2. Unable to import CSV data with escaped double quotes.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Main New Features:

1. Support Visual Query Explain for SQL Server
2. Enhanced Query Editor
3. Enhanced BI Feature
4. New Filter & Sort Layout
5. Many other new features and improvements

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to copy and paste records in the data grid.
2. Crashed when clicking the Options button in the Data Generation window.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Main New Features:

1. All-New Model Workspace
2. Data Profiling
3. Data Dictionary
4. Query Pinned Result
5. 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. Column headers were not aligned in the data grid.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Modified data types were not retained when switching to other tables in Import Wizard.
2. "Invalid cursor state" error occurred after computer was idle.
3. Unable to connect using ssh agent in some cases.
4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Crashed when closing Server Monitor.
2. Crashed when switching tabs on Information Pane.
3. The percentage values shown in the chart were incorrect.
4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Column widths were not retained when opening tables/views.
2. Crashed when scheduling batch jobs in some cases.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

1. "The number of row value expressions in the INSERT statement exceeds the maximum allowed number of 1000 row values." error occurred when importing data to SQL Server.
2. Crashed on macOS 14.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Main New Features:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Memory utilization issue.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Main New Features:

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

To upgrade, please visit our Customer Center.

Main New Features:

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

Additional Features:

1. Connection Profiles
2. Field Information Pane
3. 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. Crashed when hovering over tabs.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Crashed when using Data Transfer in some cases.
2. Cursor did not focus to the Search box after pressing CMD-F.
3. Crashed when selecting the "Group by Object Type" in Structure Synchronization.
4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to read grid data in Dark mode.
2. Unable to sort the last column by clicking the column header in Table Viewer.
3. Duplicate entry error occurred when editing the pasted records.
4. Hanged when starting Navicat in some cases.
5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Data Synchronization UX issue.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Improvements:

1. Set the values of a column to NULL.

Bug-fixes:

1. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Only the last selected table was printed when printing multiple tables.
2. The SQL Editor was flickered and repainted when saving the query.
3. Crashed when using Query Builder on Big Sur.
4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. The "Set to Null" option was applied to a wrong column when some columns were hidden in Table Viewer.
2. The field size was incorrect in Form View.
3. Crashed when opening/testing a connection after changing "Settings Location" to a folder in Documents.
4. "Dump SQL File" stopped running in some cases.
5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Improvements:

1. Improvement on resizing Information pane.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to show full table names in the Data Synchronization window.
2. Field names in the Join dialog were truncated.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to change the Settings Location path of Navicat Cloud connections.
2. A red exclamation mark was incorrectly displayed on the Navicat Cloud query icon.
3. "Add Object Privileges" UI issue when using Dark Mode.
4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to search in menu bar / Help.
2. Unable to show the database list when there was more then 255 databases.
3. Data Transfer process was stopped in some cases.
4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Error occurred when running multiple SQL Server queries (ended with ;) in Query Editor.
2. List View was not retained in the main window after restarting Navicat.
3. The backup context menu was incorrect when the SQL Server connection was not opened.
4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Crashed when running query in some cases.
2. Unable to use the Add Privilege button.
3. Connections moved out of the group after editing.
4. "Incorrect syntax near ','" occurred when importing accdb file to SQL Server.
5. Crashed when editing model in some cases.
6. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Empty tables were created when importing .accdb file.
2. Run Selected option did not run all highlighted text when using shortcut to select the SQL.
3. SSH connection dropped issue.
4. Unable to retain selected columns in Foreign Key Selection window.
5. Data Synchronization data grid UI issue in Dark Mode.
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. Missing "Tools" menu when running an infinite loop in Console.
2. Crashed when comparing databases in Structure Synchronization.
3. Login failed when connecting to Azure SQL Database.
4. Crashed when saving models.
5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Grid View and Form View menu options were flipped.
2. The row height of the object list did not match the font size.
3. Column order was incorrect when importing database to model.
4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Improvements:

1. Enter the datetime value directly in the Filter.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Main New Features:

1. 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. Unable to rename table with double-click in some cases.
2. Sorting Rows column on the Objects tab did not work properly.
3. Command-W shortcut did not close the active window in some cases.
4. Some menu items were missing in Table Designer.
5. Export Wizard did not add a leading zero to pad days and months to two digits.

To upgrade, please visit our Customer Center.

Improvements:

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

Bug Fixes:

1. Crashed when opening Navicat if invalid characters were used for the paths in Preferences.
2. Unable to execute Navicat commands using Automator.

To upgrade, please visit our Customer Center.

Improvements:

1. Supported coloring the Objects tab when a colored connection is selected.
2. Improved table mapping in Import Wizard.
3. Improved keyboard navigation with tab key in Import Wizard.

Bug Fixes:

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

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Crashed when starting Navicat.
2. Unable to edit query results when tables had alias.
3. Exported files were not attached to the notification email.
4. Procedure Parameters was missing when synchronizing structure.
5. Unable to filter connections in the Navigation Pane.
6. Profile icons did not have indicator after adding attachments in Batch Job.

To upgrade, please visit our Customer Center.

Bug Fixes:

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

To upgrade, please visit our Customer Center.

Bug Fixes:

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

To upgrade, please visit our Customer Center.

New Features:

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

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Failed to move procedures to a virtual group.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Unable to show errors when running query in some cases.
2. Failed to import JSON files in some cases.
3. Query Editor window has disappeared when it lost focus.
4. Some options were wrongly displayed in Essentials Edition.
5. Settings Location was wrongly copied when duplicating connection.

To upgrade, please visit our Customer Center.

Bug Fixes:

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

To upgrade, please visit our Customer Center.

Improvements:

1. Added some common keyboard shortcuts.

Bug Fixes:

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

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Crashed after exporting in some cases.
2. Crashed when importing files with long field name.
3. Column titles was unable to display properly in Form view when using large font size.
4. Crashed when deleting tables with relations in Diagram view.

To upgrade, please visit our Customer Center.

Improvements:

1. Support smart quotes in Query Builder.

Bug Fixes:

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

To upgrade, please visit our Customer Center.

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

To upgrade, please visit our Customer Center.

Bug Fixes:

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

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Crashed when running Data Transfer more than once on OS X 10.11.
2. Crashed when running stored procedures on OS X 10.11.
3. Crashed when running SQL multi times in Console.
4. Unable to login SQL Server with password contains ";".

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Showed wrong database in Connection Tree.
2. Execute SQL file did not output errors in some cases.
3. Lost local connections after Navicat crashed during synchronizing to Navicat Cloud.
4. App Store version: In-App Purchase did not work in Mac OS X 10.11.

To upgrade, please visit our Customer Center.

Improvements:

1. Supported format strings in Schedule email body.

Bug Fixes:

1. Unable to send notification email in Schedule.
2. Wrongly updated the SQL Server table identity columns in Import Wizard.
3. Created a new connection when previewing a view.
4. Syntax error occurred when updating SQL Server tables in Table Viewer.
5. Crashed when dumping SQL Server tables to a SQL file.
6. Lost connections in some cases.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Unable to show error messages when saving SQL Server procedures.
2. Crashed when importing connections.
3. SQL Server connection would hang when the connection was disconnected.
4. Crashed when reversing database to model.

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 adding shapes in Model.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Crashed when adding foreign key under Table Designer in Data Modeling Tool.
2. Paging buttons did not work after applied sorting in Table Viewer.

To upgrade, please visit our Customer Center.

Improvements:

1. Support length of SSH password/private key passphrase increased from 99 to 255.
2. Support to save name with "/" for Connection Save Path, Query, Import/Export/Backup profile, Backup, Schedule, Model, Data Transfer/Synchronization profile.

Bug Fixes:

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

To upgrade, please visit our Customer Center.

Bug Fixes:

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

To upgrade, please visit our Customer Center.

Improvements:

1. Allow drag to reorder field as default in Table Designer.

Bug Fixes:

1. Connection password was unable to be saved.
2. The state of running in full screen was unable to be saved, so that Navicat only started up in window mode.
3. Error message occured while viewing table structure to show the file path.
4. Disabled the vertical elastic effect to avoid wrong colour drawing for row index < 0 in Table Viewer.
5. The result dataset did not show warning messages for unknown type query in Query Viewer.
6. When previewed and enabled save queries to file, queries were not correctly written to the file in Data Synchronization.
7. The file and file size position in Model info view were wrong.
8. Crashed when right-clicked on an open area and seleted "Restore Backup".
9. The bookmark setting of saved path was incorrect in Backup schedule.

To upgrade, please visit our Customer Center.

Improvements:

1. Now only column titles of the first result included when exporting multi dataset to the same file using Export Wizard.

Bug Fixes:

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

To upgrade, please visit our Customer Center.

Improvements:

1. Improved connection tree behavior in main window.

Bug Fixes:

1. Database name was changed if failed to open it.
2. Popup menu was shown far away when clicking on Diagram View or Model Design in retina display.
3. Crashed when deleting active connection.
4. Crashed when typing single digit in hour/minute/second field and press OK in table viewer.
5. Unable to show error when getting database on open connection.
6. Crashed when closing the Export Wizard for exporting selected row in Table Viewer.
7. Limited the number of rows in the exported file when exporting SQL Server table.

To upgrade, please visit our Customer Center.

Improvements:

1. Disabled zooming by magic mouse in Query Editor.

Bug Fixes:

1. Failed to open table on Mac OS X 10.6.
2. Unable to add view's profile to the virtual group.
3. Unable to duplicate profiles.

To upgrade, please visit our Customer Center.

Improvements:

1. Added shortcut keys for "Save" and "Save As" in Data Synchronization.
2. Enhanced Data Synchronization.
3. Allow to select tag to identify data when exporting table to JSON format.
4. Saved field selection window size in Table Designer.

Bug Fixes:

1. Crashed when running Explain on Mac OS X 10.6.
2. Unable to close Server Monitor's popup dialog in Mac OS X 10.9.
3. Wrongly quoted the value in Export output file.
4. Failed to save connection order in main window.
5. Editor failed to show when first open the Table/View Viewer.
6. Unable to save the resultset's column width after re-run the query.
7. App Store version: Failed to list tables after connected.
8. Website version: Unable to send attachments in Schedule.

To upgrade, please visit our Customer Center.

Bug Fixes:

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

To upgrade, please visit our Customer Center.

Improvements:

1. Compatible with Mac OS X 10.9 Mavericks.

Bug Fixes:

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

To upgrade, please visit our Customer Center.

Improvements:

1. Suppport larger row limit for xlsx version, 1048576 rows in Export Wizard.

Bug Fixes:

1. No popup error showed in Table Viewer.
2. Failed to find the next match in Find Next action after selecting a cell in Table Viewer.
3. Crash occured in Query Editor.

To upgrade, please visit our Customer Center.

Improvements:

1. New tab window control.

Bug Fixes:

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

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Error not log during fetching rows in Data Transfer.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Crashed when set objects as auto-save.
2. Failed to save position and size when closing windows.

To upgrade, please visit our Customer Center.

Improvements:

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

Bug Fixes:

1. Crashed when opening server/catalog level export profiles.
2. Failed to set the string in Export Wizard's export file path text field.
3. Failed to open export profile as file in veriosn 11.0.5.
4. Failed to import number from Excel in Import Wizard.

To upgrade, please visit our Customer Center.

Improvements:

1. Updated libxl to 3.5.3.
2. Adjusted caret color same in Scintilla.
3. Support sorting items by name inside a virtual group.

Bug Fixes:

1. SSH connection random crashed.
2. Fixed number of virtual grouping issues.
3. Crashed in Query Viewer.
4. Select/Paste function did not work on the newly added rows in Table Viewer/Query Viewer.
5. Text/Blob Editor in Table Viewer was reallocated the data in selected cell after refreshed.
6. Values did not always change in Table Viewer if modified in Query Viewer.
7. Query not found error occured in Query Favorites feature.
8. When generating create table queries, all numeric fields came with IDENTITY in Data Modeling Tool.
9. Export failed in query result.
10. Crashed in Structure Synchronization.
11. App Store version: Error occured when adding images in Data Modeling Tool.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Bug fixed in other Navicat fmaily.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. SSH Public key settings was unable to be saved in duplicate connection.
2. Crashed occured when deleting objects from ER Diagram view.
3. Crashed occured when applying filter during the data loading process.
4. Crashed occured in Query Editor when running an empty query.
5. Progress indicator in Query viewer result kept spinning after rows inserted.
6. Infinite looping in Export Wizard while exporting selected rows.
7. Crashed occured in Server Monitor while getting the process list.
8. Data model files not opened while they were not saved in default folder.

To upgrade, please visit our Customer Center.

Bug Fixes:

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

To upgrade, please visit our Customer Center.

Major New Features:

Native 64-bit version

Interface

1. New User Interface
2. New docking system

Connection

1. New SSH Manager
2. Connection Tree Filter

Table Viewer

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

Table Designer

1. Search Columns
2. Field Type Prediction

Query

1. Support showing multiple results

Import Wizard

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

Export Wizard

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

Backup/Restore

1. SQL Server Backup

Others

1. New Registration and Activation System
2. New Updater

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Connection kept opening even the form was closed.
2. Table names in ER Disgram view could not be renamed.
3. Font size in SQL Editors were too large in retina display.
4. Crashed while opening DBF import profile with Field Delimiter = "" in Import Wizard.
5. "Disable foreign key checks" option in Data Synchronization was ignored in Schedule.

To upgrade, please visit our Customer Center.

Improvements:

1. Support Turkish char input in scintilla.
2. Allowed to save a export profile for a running query.

Bug Fixes:

1. Slow performance experienced when editing on grid due to allocation of field editor menu on demand.
2. Export file name with date format was excluded in the saved export profile.
3. Incorrect orientation and size were set while printing model in Data Modeling Tool.
4. Sorting columns with numeric values was not working properly in Server Monitor.
5. Crashed if Stored Procedure contained syntax error while connecting to server.

To upgrade, please visit our Customer Center.

Improvements:

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

Bug Fixes:

1. Scintilla font size doubled in Apple retina display.
2. Popup window did not show while clicking on Delete item button with no rows being selected in Table Designer.
3. Datetime value was not obtained correctly from ODBC in Import Wizard.
4. Index and unique were missing under Data Modeling Tool Table Designer.

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. Align/Distribute diagram objects.

To upgrade, please visit our Customer Center.

Improvements:

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

Bug Fixes:

1. Fixed a crash issue when re-running a query in Query Viewer.
2. Fixed the failure of sending email in Schedule.

To upgrade, please visit our Customer Center.

Bug Fixes:

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

To upgrade, please visit our Customer Center.

Bug Fixes:

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

To upgrade, please visit our Customer Center.

Improvements:

1. SQL scripts copy from Structure and Model Synchronization comparison results are now formatted properly.

Bug Fixes:

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

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Fixed the refresh problem after reordered the fields in ER diagram view.
2. Fixed the reload time issue after saving table.
3. Fixed the wrong listing for target tables in Data Synchronization.
4. Fixed the bug occurred when selecting weekday in Schedule setup panel.

To upgrade, please visit our Customer Center.

New Feature:

1. Support connection coloring.

Improvements:

1. Settings are now stored in ~/Application Support/PremiumSoft CyberTech folder instead of ~/Application Support/Navicat.
2. Support of dumping SQL file with selected tables.

Bug Fixes:

1. Fixed the missing Foreign Keys when reversing tables to model.
2. Fixed the issue of selecting wrong database type when reversing tables to model.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Fixed the problem of wrong encoding used when loading queries.
2. Fixed the issue of not saving a Data Synchronization advanced setting as profile.
3. Fixed the crash problem when started with the main toolbar hidden.

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.

Bug Fixes:

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

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Append/Update option did not work in Import Wizard.
2. Unable to list MSSQL 2000 objects for some users.
3. Unable to open SQL files with some encodings.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Failed to create new connection using Windows Authentication.
2. Failed to insert value 0 into numeric fields in servers.
3. High CPU usage when pausing the process of Data Transfer/Data Sync/Structure Sync/Execute SQL File.
4. Cmd-Shift + Arrow Key shortcut keys were improperly overwritten by the shortcut keys of the tabbed windows.

To upgrade, please visit our Customer Center.

New Feature:

1. Support of SQL Azure.

Improvements:

1. Elapsed time is now shown for each query in Query Viewer.
2. The first level tag in XML file is now recognized as the record indicator during Import Wizard.

Bug Fixes:

1. Queries list in main window was not refreshed after transferring queries.
2. Crashed when refreshing tables after Record per Page setting had changed in Table Viewer.
3. After deleting a record, the next record is now selected instead of the final record in Table Viewer.
4. Some value could not be displayed when switching from Grid View to Form View in Table Viewer.
5. Updating records improperly used extra fields as update criteria.
6. SQL results were unable to shown when some kinds of SQL statements were run in Query Viewer.
7. Mode selections were ignored under "Advanced Settings" tab in Data Synchronization.

To upgrade, please visit our Customer Center.

Bug Fixes:

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

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Crashed when trying to add row in Form Viewer.

To upgrade, please visit our Customer Center.

Main Features:

Common SQL Server support:

1. Support SQL Server 2000, 2005, 2008 and 2008R2.
2. Support of most SQL Server objects and subobjects
3. Support of character set and unicode.

Connection Management:

1. Multiple local/remote SQL Server server connections.
2. Connection to SQL Server through SSH.
3. Keep connection alive.
4. Import/Export connections settings.

Well-designed user interface:

1. Virtual Grouping for connections and objects.
2. Customize of connection order.
3. Grid View and Form View support.
4. Well-described Wizard System.
5. Provide well-vision for users in table grid.
6. Support dock windows.

Powerful data management tool:

1. Foreign Key Data Selection.
2. Supports Parameter Query.
3. Import and Export support.
4. Data Transfer support.
5. Data Synchronization support.
6. Structure Synchronization support.
7. Schedule for Batch Job.

Visual Designer:

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

Server Security and Maintenance Services:

1. Visual user/role management.
2. Visual privilege manager.
3. Maintance database / schema objects.
4. Server Monitor.

Additional features:

1. UUID/GUID generator.
2. Code outline.
3. Print Schema / Table Structure.
4. Support of setting global Row Height and Column Width in table grid.
5. Support of Word Wrap.
6. Provides a short-cut to terminate a running query.
7. Code Folding.
8. Matched Brace/Bracket Highlighting.
9. Parameter Tips.
10. Zoom In/Out for SQL editors.
11. SQL Beautifier.
12. Favorites.
13. Object Filter.
14. Auto save in Query, Function etc.
15. Custom sort in Tabler Viewer.
16. SQL Console.
17. History Log Viewer.

Download here

Bug-fixes:

1. Unable to scroll horizontally using mouse in data grid.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Crashed when closing tabs in some cases.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to open database connection after VPN disconnected/reconnected.
2. Crashed when starting Navicat in some cases.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. No tables listed when reverse engineering SQL Server databases to model.
2. Model diagram disappeared when hovering over.
3. Crashed when closing tab after idle.
4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Main New Features:

1. Support Visual Query Explain for SQL Server
2. Enhanced Query Editor
3. Enhanced BI Feature
4. New Filter & Sort Layout
5. 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. Unable to run schedule.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Main New Features:

1. All-New Model Workspace
2. Data Profiling
3. Data Dictionary
4. Query Pinned Result
5. Table Profile
6. Navicat URI
7. Manage Connection
8. Enhanced BI Feature
9. Focus Mode
10. Linux ARM Version
11. Many other new features and improvements

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Some labels disappeared after adding the chart to the dashboard.
2. Unable to display proportion percentages in the chart axis.
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.

Improvements:

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

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 using Structure Synchronization.
2. Crashed when changing data display in Charts.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Beautify SQL incorrectly added spaces between the function name and parentheses.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Main New Features:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Main New Features:

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

To upgrade, please visit our Customer Center.

Main New Features:

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

Additional Features:

1. Connection Profiles
2. Field Information Pane
3. 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. Unable to launch Navicat after upgrading the system to use GLib-2.70.0 .
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

1. The Stop button did not work when processing deletion in the table viewer.
2. Error occurred when editing data in query results.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Crashed when the query returned a large result set.
2. Not all matching data was highlighted when searching the query results.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Crashed after refreshing the table.
2. Hanged when dragging a table from the main window to the model window.
3. Incorrect default field size issue in Table Designer.
4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

1. 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. "IDENTITY_INSERT is already ON" error occurred when synchronizing SQL Server tables.
2. Crashed when using Charts in some cases.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

1. An empty diagram was created when reversing a database to a model.
2. Unable to change font for Editor and Records.
3. Unable to display special characters of SQL Server query results.
4. Query returned different results for an empty row.
5. Unable to copy the selected text with shortcut in Console.
6. Crashed when importing tables to a model.
7. Unable to add a table to the model using the mouse.
8. Delay when pasting with CTRL+V.
9. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.