Release Notes

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Crashed when sorting data.
2. Incorrect database name assigned when using "Synchronize Database To Model".
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to import all records from a file in some cases.
2. Crashed when generating data dictionary for SQLite.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Model diagram disappeared when hovering over.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Main New Features:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Keyboard support failure in Data Viewer.
2. The reference field was not updated when changing the primary key field in the model.
3. Non-filtering objects did not hide in the overview navigator of ER Diagram.
4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Main New Features:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

1. 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. Some labels disappeared after adding the chart to the dashboard.
4. Unable to display proportion percentages in the chart axis.
5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Crashed when opening Charts workspaces in some cases.
2. Crashed when scheduling import jobs.
3. Missing records when importing files in some cases.
4. Special characters were garbled when using double-click to add a snippet to the query.
5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Improvements:

1. Auto guess field types when importing xlsx files.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Cannot type a new name for the table in Import Wizard.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to display SQLite BLOB data.
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. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Query Builder window was larger than the screen in some cases.
2. Unable to display the data differences of TEXT fields in Data Synchronization.
3. The second field was selected when adding a sort condition in Table Viewer.
4. Crashed when stopping Data Transfer process.
5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

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. Data Synchronization did not work in Automation.
2. "Failed to send mail. Stream error." occurred when sending email.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Failed to transfer large tables.
2. Real data exported as text when exporting SQLite table to Excel.
3. Crashed when batch querying tables with FK dependency.
4. Unknown Internal Error occurred when exporting large amount of data.
5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Font size issue in Form View.
2. Field size was not retained in SQLite table designer.
3. Buttons in the lower right corner of the main window were missing in some cases.
4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to open the objects in the "Find in Database" window.
2. The first number of every value in the list was removed in the table filter.
3. Unknown Internal Error occurred when updating query results in some cases.
4. Unable to use "Copy As" in View results.
5. Crashed when opening functions in some cases.
6. Unknown Internal Error occurred when foreign key selection window popped up.
7. Crashed when clicking on the value box in table filter.
8. Decimal separator issue in SQLite.
9. Cannot retain the window size and position for existing objects.
10. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Main New Features:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to close the error dialog when changing field name in model canvas.
2. Unable to close the error dialog when editing chart y-axis range.
3. Failed to transfer large tables.
4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. The "Compare" button did not work in Data Synchronization in some cases.
2. 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. Connection password issue when updating connection in Navicat Cloud.
2. Error occurred when synchronizing to Navicat Cloud.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Notification Email authentication failed in some cases.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Main New Features:

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

Additional Features:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Double foreign key lines were printed when exporting a model to a PDF file.
2. Access violation error occurred when searching in the Backup's Object Selection tab.
3. No data value on the label when exporting a chart to a PDF file.
4. Unable to rename a view inside a group in Navicat Cloud.
5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Improvements:

1. Support tunneling on PHP 8.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Empty rows were added when exporting more than 1.05 M records to Excel file.
2. Hanged when designing a table with many fields.
3. Error occurred when copying tables from one SQLite database to another.
4. Unable to display the definition of SQLite View in some cases.
5. Relation lines were disappeared after saving and reopening Logical Model.
6. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Numeric data was shown as String in the chart datasource.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to change the label text color in Report's header.
2. Notification email subject was incorrect when the job finished unsuccessfully.
3. Cursor focusing issue when using Find feature in Table Viewer.
4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Flashed in dark mode.
2. "Unallowed argument in list..." error when running export / import schedule.
3. Unable to load version 10 data synchronization profiles.
4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to import MEMO data from DBF files.
2. Unable to display SQLite view definition in some cases.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to show records that had -1 data in Table Viewer.
2. "Drop target objects before create" option did not work in Data Transfer.
3. Memory leak issue when enabled code completion.
4. "Unknown Internal Error (A70529211102SE)" error occurred when exporting / importing data.
5. Slow issue when transferring large tables.
6. Unable to show the inputted text in Filter Wizard.
7. Error occurred when filtering data by right-clicking a cell in Table Viewer.
8. Inserted records to the wrong table when transferring data to the target table with a different name.
9. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Improvements:

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

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Invalid XML error occurred when importing connections.
2. Differences was detected in re-comparison in Synchronize to Database.
3. Incorrect data was updated when saving ; in a non-text field.
4. Incorrect items were displayed in suggestion list when using code completion with alias.
5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Query wrongly returned null results in some cases.
2. Datetime format issue when exporting to Excel files.
3. Query Results Text pane appended values of the selected cells.
4. "No such column" error when adding column to SQLite table.
5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Query wrongly returned null results in some cases.
2. "," was replaced by "." when using Custom Filter in Table Viewer.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Improvements:

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

Bug-fixes:

1. Unknown Internal Error occurred when starting Navicat in some cases.
2. Crashed when importing two XML files.
3. Differences were detected after synchronizing model to database.
4. Syntax error occurred when saving procedures in some cases.
5. Hanged when searching regular expression in Query Editor.
6. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Improvements:

1. Added "Keep Orthogonal Layout" to Model.

Bug-fixes:

1. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Improvements:

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

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Table name was changed in View definition when altering SQLite table structure.
2. Wrong options were selected when loading another Data Transfer profile.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

New Features:

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

To upgrade, please visit our Customer Center.

Improvements:

1. SQLite library is updated.
2. Support SQLite Windows Functions.

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. Synchronize to Database feature wrongly detected differences of unique constraints.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Code Completion did not work in some cases.
2. Unable to import signed numbers when there was spaces between the sign and the number.
3. Unable to map a source field to multiple target fields in Import Wizard.
4. "Cannot open file" error occurred when scheduling export profiles in some cases.
5. Unable to show empty fields in query result sets.
6. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. "Unknown Internal Error" occurred when opening Table Designer.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Primary Key checkbox was deselected when tabbing to the next field in Table Designer.
2. "Unknown Internal" error occurred when importing data.
3. "Access Violation" error occurred after editing the data pipeline in Report.
4. "Unknown Internal" error occurred when using Automation.
5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. SQLite table structure cannot be modified when using an HTTP tunnel.
2. Query result pane size did not retain after minimizing the window.
3. Paradox tables cannot be imported.
4. Unknown Internal error occurred when importing data.
5. Column order was incorrect when importing database to model.
6. 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. Console window was not colored when connection coloring were set.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. List index out of bounds error occurred when inserting data in Table Viewer.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

<
1. "SQLite function XXX cannot linked" error occurred after replacing the sqlite3.dll file.
2. Floating point numbers were rounded to decimals when import.
3. <html> tag was repeated twice when exporting HTML files.
4. "Add Database to List" button was enabled when the "Use custom database list" option was not checked.

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Improvements:

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

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Main New Features:

1. Brand new Filter Wizard
2. UI and UX Improvement
3. MongoDB is added in Navicat Premium
4. Navicat for MongoDB is released

To upgrade, please visit our Customer Center.

Bug Fixes:

1. File encoding was incorrect when transferring database to SQL file.
2. Incorrect unique values were imported from .dbf file.
3. Crashed when saving the modified field names in some cases.
4. Extra "(" was added to INSERT statements when deploying scripts in Data Synchronization.
5. .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. Transaction did not end after closing the table in some cases.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Zero decimal place digits were not displayed in Table Viewer.
2. Exported SQL file did not have table name when exporting an unsaved query.
3. Unknown Internal Error occurred when importing from ODBC.
4. Syntax error occurred when importing CSV files in some cases.
5. Unable to change the Tab Width in Query Editor.
6. Unable to edit query results when tables had alias.
7. Unknown Internal Error occurred when Automation ran.
8. Unable to transfer tables with HEX format.
9. Encoding issue of the exported text file.
10. Unable to show the SQLite CTE based view definition in View Designer.

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. "SQL Logic" error occurred when loading SQLite extension.
6. Unable to edit query results in some cases.
7. Unable to disable Foreign Key constraint in Data Synchronization.
8. Crashed when dumping table to sql file in some cases.
9. Foreign Key constraint didn't work when the constraint name was empty in SQLite.
10. Some setting values was missing in SQLite Trigger Designer.
11. Foreign Key constraint issue in Import Wizard.
12. Unable to show the SQLite CTE based view definition in View Designer.
13. SQLite connections was missing in Model's Import from Database feature.
14. Code completion replaced the text after caret.
15. Exported files or reports were not attached to the notification email.
16. If a query was opened, abnormal behavior happened when closing Navicat.
17. 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. Added records showed wrong values until refreshing SQLite table grid.
6. Slow issue when searching in Table Viewer.
7. Unable to move functions into a group.
8. Syntax error occurred when running query in some cases.
9. "Unknown Internal Error" occurred when opening SQLite tables.
10. Unable to synchronize models/queries in Navicat Cloud.
11. Exported Excel files were corrupted in some cases.
12. "Access is denied" error occurred when setting schedule.

To upgrade, please visit our Customer Center.

Improvements:

1. Updated SQLite library version to support more JSON functions.

Bug Fixes:

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

To upgrade, please visit our Customer Center.

Bug Fixes:

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

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Out of memory issue when running Data Transfer.
2. Export Float data to csv files issue.
3. Crashed when importing Excel or Text files in some cases.
4. Opening large databases in List View took long time.
5. Unable to show query files with ".SQL" extension in Objects tab.
6. CTRL+SPACE shortcut were missing in Query Editor.
7. Print report to PDF command wrongly sent the report to printer.
8. Null date values were exported wrongly as "1900-01-00" in Excel files.
9. Tables Viewer displayed wrong number of digits.
10. Input parameter window did not pop up when exporting query.
11. High CPU usage issue.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Unable to zoom in/out Query Editor using mouse wheel.
2. Swapping connections did not work when re-comparing in Data Synchronization.
3. Syntax errors occurred when running query in some cases.
4. No records was transferred when the target connection was using HTTP Tunnel.
5. Query syntax highlight was wrong after switching tabs.
6. DateTime field Not Null checkbox unchecked wrongly in Table Designer.
7. Unable to export table to xlsx with name longer than 31 characters.
8. Hanged when searching in Table Viewer in some cases.
9. Unable to open connection by double-clicking the SQLite database file.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. The database/schema combo-box did not work in Query.

To upgrade, please visit our Customer Center.

Bug Fixes:

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

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Record delimiter was wrong when exporting to text file using Automation.
2. Table Viewer moved back to the first page when refreshing a table.
3. Characters displayed wrongly in Table Viewer.
4. Unable to select fields when exporting to Excel file.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Unknown Internal Error occurred when starting Navicat for SQLite.
2. Error occurred when deleting INT field value in Table Viewer.

To upgrade, please visit our Customer Center.

Bug Fixes:

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

To upgrade, please visit our Customer Center.

Bug Fixes:

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

To upgrade, please visit our Customer Center.

Bug Fixes:

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

To upgrade, please visit our Customer Center.

Bug Fixes:

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

To upgrade, please visit our Customer Center.

Bug Fixes:

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

To upgrade, please visit our Customer Center.

Bug Fixes:

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

To upgrade, please visit our Customer Center.

Bug Fixes:

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

To upgrade, please visit our Customer Center.

Bug Fixes:

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

To upgrade, please visit our Customer Center.

New Features:

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

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Error occurred when exporting with Time field type.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Crashed when using Query in some cases.
2. Query auto-save feature did not work in some cases.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Fixed the sorting issue in Table Viewer.

To upgrade, please visit our Customer Center.

Improvements:

1. Increase the number of databases that can be attached to a SQLite database.

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. Foreign keys check SQL was missing at the end of the dumped SQL file.
4. Crashed when synchronizing model to database in some cases.
5. 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.

Improvements:

1. Support SQLite JSON1 extension.

Bug Fixes:

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

To upgrade, please visit our Customer Center.

Bug Fixes:

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

To upgrade, please visit our Customer Center.

Bug Fixes:

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

To upgrade, please visit our Customer Center.

Bug Fixes:

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

To upgrade, please visit our Customer Center.

Bug Fixes:

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

To upgrade, please visit our Customer Center.

Bug Fixes:

1. "Argument out of range" error occurred when using "Find in Database/Schema".
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Major New Features:

Navicat Cloud Collaboration

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

Data Modeling Tool

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

Others

1. SQLite Users Management.
2. Enhanced Connection Coloring.
3. Search database object structure.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Exported result incorrect for TIME field type in Export Wizard.
2. File name with appended timestamp issue in Export Wizard.
3. Slow performance when showing/hiding column with Memo editor opened.
4. SSH protocol error issue.

To upgrade, please visit our Customer Center.

Bug Fixes:

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

To upgrade, please visit our Customer Center.

Improvements:

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

Bug Fixes:

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

To upgrade, please visit our Customer Center.

Improvements:

1. Improved the Message Log information.

Bug Fixes:

1. Unable to convert object names in Data Transfer when using Schedule.

To upgrade, please visit our Customer Center.

Improvements:

1. Support "WITH" clause for SQLite 3.8.3.
2. Support double-click to open database file.

Bug Fixes:

1. Unable to run in Windows Server 2003.
2. Fixed the color issue in the connection tree.
3. Exception error occurred while running synchronize to database with different number of source and target relations in Data Modeling Tool.

To upgrade, please visit our Customer Center.

Improvements:

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

Bug Fixes:

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

To upgrade, please visit our Customer Center.

Improvements:

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

Bug Fixes:

1. Navicat got hang after running certain SQLite SQL in Query.
2. Unable to select new mode in connection tree using Alt+MouseDown.
3. Access Violation error occurred when exporting single column to Word.
4. Duplicated foreign key names issue in Model.
5. Unable to recognize the Row Delimiter when importing from CSV files.
6. Import Wizard was unable to import currency data from DBF files.
7. Advanced settings were saved incorrectly in Data Transfer profiles.

To upgrade, please visit our Customer Center.

Bug Fixes:

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

To upgrade, please visit our Customer Center.

Improvements:

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

Bug Fixes:

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

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Data started with single quote issue in exported Excel file.

To upgrade, please visit our Customer Center.

New Features:

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

Improvements:

1. Support SQLite 3.8 WITHOUT ROWID.
2. Support parameter in Report command line.

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. Crashed when loading and parsing a long incorrect syntax SQL in Query.
3. After adding a new row, pressing next/last button would freeze the Form View in Table Viewer.
4. Number of rows selected incorrectly when using shift+up/down keys in Table Viewer.
5. Multiple selection not working properly with shift+keys in Table Viewer.
6. When using CTRL+A to select text inside a data cell, all cells were incorrectly selected in Table Viewer.
7. Import Paradox not able to import data properly in Navicat 64bits.
8. Wrong NullsOrder setting was shown for foreign key fields under Table Designer in Data Modeling Tool.
9. 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. 'Table does not exist' error occured while opening an export profile.
4. 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.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Failed to check/uncheck column fields in Show/Hide Columns using space key in Tabler Viewer.
2. Failed to scroll horizontally for wide content after applying Filter Wizard in Table Viewer.

To upgrade, please visit our Customer Center.

Bug Fixes:

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

To upgrade, please visit our Customer Center.

Bug Fixes:

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

To upgrade, please visit our Customer Center.

Bug Fixes:

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

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Fixed "Keyboard Interactive Failed" error for SSH tunnel connection.
2. Crashed while using SSH tunnel connection for both source and target servers in Data Transfer.
3. Query result table not able to update while having zero and padding integer.
4. 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

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. Transaction did not work properly in Table Designer while using HTTP Connection.
2. Table Viewer could not allow to edit while using HTTP Connection.
3. "Access violation" error occurred while applying an existing table name on a new table in Data Modeling Tool.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Synchronize to Database function in Data Modeling Tool genarated incorrect comparison result for equivalent source and target foreign keys.
2. Synchronize to Database function in Data Modeling Tool failed to synchronize tables with changed fields.
3. "List index out of bounds" error occurred when some source fields were removed after import profile were created during Import Wizard.
4. Binary data from Access/ODBC was imported incorrectly during 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 was unable to handle NOT NULL ON CONFLICT field property.
3. Table Designer in Data Modeling Tool was unable to save newly added index and foreign key.
4. Synchronize to Database function in Data Modeling Tool was unable to generate the referencing table schema name in the SQL scripts.

To upgrade, please visit our Customer Center.

Bug Fixes:

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

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Minimized docked window could not restore normally.

To upgrade, please visit our Customer Center.

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. Empty string was identified as Null.

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.

To upgrade, please visit our Customer Center.

Improvement:

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

Bug Fixes:

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

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Crash occurred when closing Synchronize to Database in Modeler during the comparison in progress.
2. Synchronize to Database in Modeler did not generate index SQL properly.
3. Crash occurred while renaming table failed with server error in ER-diagram view.
4. Data Transfer would hang in Navicat Scheduler.

To upgrade, please visit our Customer Center.

Bug Fixes:

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

To upgrade, please visit our Customer Center.

Improvement:

1. Columns with undefined data type is now able to be searched in "Find in Database" feature.

Bug Fixes:

1. Incorrect field type showed in ER Diagram.
2. Fixed-width and row delimiter were unable to retrieve from a profile in Import Wizard.
3. 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. The highlighted items from the previous searching results in Table Designer was failed to clear for the next searching.
2. Field name with over 30 characters long was unacceptable in Table Designer.
3. INDEX definitions did not include in SQL Dump File and Data Transfer feature. And database name referenced was missed in the INSERT commands.
4. Data with #10 or #13 would be determined as BLOB type during Export 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.

Major New Features:

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

Improvements:

1. Added object list in Query Editor.
2. Added DDL tab in Object Information.

To upgrade, please visit our Customer Center.

Improvements:

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

Bug Fixes:

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

To upgrade, please visit our Customer Center.

Bug Fixes:

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

To upgrade, please visit our Customer Center.

Bug Fixes:

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

To upgrade, please visit our Customer Center.

Improvements:

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

Bug Fixes:

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

To upgrade, please visit our Customer Center.

Improvements:

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

Bug Fixes:

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

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Table Viewer treated e.g. "2010-12-14" as number format instead of text format.
2. DBF character field length would be set to 254 if table field length is 0 while exporting to DBF file.
3. 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. Table Viewer is now able to handle numeric value in Update/Insert statement.

Bug Fixes:

1. Any unique constraints set at a column level were lost if a previously created table was opened.
2. When adding fields in a table with foreign key constraint in Table Designer, the reference table field would be renamed.
3. 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).
4. Code Completion did not work properly with field name if tables were from different database.
5. Exported data (string) to Excel file did not work properly, e.g. value of '1E' would being exported as 1.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Data was truncated with VARCHAR as data type.

To upgrade, please visit our Customer Center.

Major New Features:

1. Data Synchronization performance improved with new engine.
2. Connection Coloring.

To upgrade, please visit our Customer Center.

Bug Fixes:

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

Upgrade Procedure : click here to upgrade

Bug Fixes:

1. Table Designer did not allow to create data type TEXT, BLOB, REAL, etc with length, precision and scale.
2. Indexes were unable to be removed from Table Designer.
3. When pasting an enum type value using CTRL+V in Tabler Viewer, the drop down list box would be shown in wrong position.
4. "Access violation" error occurred when running an invalid SQL syntax in Query Builder, e.g. select ... from ,table01.
5. Imported string data as blob data incorrectly to database using Import Wizard.
6. In Structure Synchronization, when the queries generated in the "Queries for Modification" list were too long (e.g. 8000 characters), the whole line would become blank.
7. Field names for some tables with special names were unable to be listed in Report Builder.

Upgrade Procedure : click here to upgrade

Improvements:

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

Bug Fixes:

1. Index/trigger was unable to be removed from the Navicat main window.
2. "Access violation" error sometimes occurred when running an invalid syntax in Query Editor.

Upgrade Procedure : click here to upgrade

Bug Fixes:

1. Brackets in FROM clause could not be parsed between Query Editor and Query Builder.
2. When exporting numeric data with comma as decimal seperator to access file, the numbers were displayed without the comma.
3. When exporting numeric data to excel file, it would be exported as string type.

Upgrade Procedure : click here to upgrade

Bug Fixes:

1. "Access Violation" error occured when printing database/table structure to PDF, HTML etc.
2. "List Index our of bounds (58)" error occured when trying to enter/edit SQL in query Definition tab.
3. Foreign Key link position in Visual Builder were not accurate enough.
4. Fixed bug when parsing FROM clause with brackets in Visual Builder, e.g. select ... from ((...)).
5. Server Monitor would crash if being opened for a while.
6. The info column in Server Monitor only showed (WIDEMEMO).
7. Object Selection in Restore window wrongly displayed items "Indexes" and "Triggers".

Upgrade Procedure : click here to upgrade

Bug Fixes:

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

Upgrade Procedure : click here to upgrade

Bug Fixes:

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

Upgrade Procedure : click here to upgrade

Improvements:

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

Bug Fixes:

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

Upgrade Procedure : click here to upgrade

Improvements:

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

Bug Fixes:

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

Upgrade Procedure : click here to upgrade

Improvements:

1. Support Cancel action in copying SQLite objects, table and query.

Bug Fixes:

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

Upgrade Procedure : click here to upgrade

Improvements:

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

Bug Fixes:

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

Upgrade Procedure : click here to upgrade

Improvements:

1. Better handle case sensitive of object identifier for Query Builder.
2. Support "select ... from ... group by left(..., ...)" when switching from Query Editor to Query Builder.
3. Improved keywords list for Code/Word Completion.
4. Attached hot keys to the navigation bar in Table Viewer.

Bug Fixes:

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

Upgrade Procedure : click here to upgrade

Main Features:

Common SQLite support:

1. Work with SQLite 2 and SQLite 3.
2. Support of all SQLite objects and subobjects
3. Support of character set and unicode.

Connection Management:

1. Multiple local/remote SQLite server connections.
2. Connection to SQLite database through HTTP.
3. 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. Support of Backup and Restore.

Visual Designer:

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

Additional features:

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

Download here

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to show the trigger definition after reordering the trigger in Table Designer.
2. 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. 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. Enhanced Query Editor
2. Enhanced BI Feature
3. New Filter & Sort Layout
4. Many other new features and improvements

To upgrade, please visit our Customer Center.

Bug-fixes:

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

Bug-fixes:

1. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

1. The pop-up menu in the navigation pane was missing options.
2. Crashed when creating relations in ER diagram.
3. Unable to delete the first record in the data grid.
4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Crashed when designing tables.
2. Form View did not display the current record selected in Grid View.
3. The reference field was not updated when changing the primary key field in the model.
4. Crashed when performing Forward Engineering.
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. SHIFT-TAB shortcut did not work in the data viewer.
2. Data edit mode did not work in some cases.
3. Crashed when reversing SQLite database to model.
4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Main New Features:

1. All-New Model Workspace
2. Data Profiling
3. Data Dictionary
4. Query Pinned Result
5. 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. The screen scrolled to the left after refreshing the data in Data Viewer.
2. 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. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

1. The percentage values shown in the chart were incorrect.
2. 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. Text in the Search box was hidden in some cases.
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. Crashed on macOS 14.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Beautify SQL incorrectly added spaces between the function name and parentheses.
2. 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. Copy and paste shortcuts did not work in Navigation pane.
2. The focus jumped to the top level after renaming an object in Navigation pane.
3. Table tree loading issue in Navigation Pane.
4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

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. Unable to save the schedule changes.
2. TAB key did not work when adding field.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Crashed when opening Preferences in some cases.
2. Crashed when importing database to model in some cases.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to backup if database folder did not exist.
2. Unable to load cloud connection info when opening data transfer profile.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Bar chart label display issue.
2. BLOB data was truncated in Console.
3. Table columns were not aligned in Console.
4. Chart value labels disappeared after reopening Navicat in dark mode.
5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Query Builder did not recognize the selected fields.
2. "Incomplete Input" error occurred when editing SQLite table.
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 open the objects in the "Find in Database" window.
2. Crashed when renaming a connection in a group.
3. Cannot show the new group unless Navicat was restarted.
4. Checks were not imported when using "Reverse Database to Model".
5. Unable to sort columns in table viewer.
6. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Main New Features:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Crashed when closing Navicat in some cases.
2. Hanged when designing table.
3. Unable to scroll through the fields with the mouse wheel in Query Builder.
4. Connection coloring did not work on subtabs.
5. Crashed when importing invalid json files.
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. 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. Line numbers disappeared when scrolling in Query Editor.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Crashed when opening query on macOS 10.14 .
2. Missing zero padding in year when exporting data to CSV / TXT file.
3. Missing menu items when opening query in new window.
4. Crashed when importing connections.
5. 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 running scripts in some cases.
2. Crashed when copying records in some cases.
3. The TEXT pane did not retain when running queries.
4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

1. 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. The modified dates of backup files were incorrect.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Improvements:

1. Improvement on resizing Information pane.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Jumped to the first record when refreshing in Form View.
2. The list of the reference tables for foreign key was empty in Model.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Console was missing in Standard eidtion.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Crashed when starting Navicat.
2. Crashed when running Data Transfer in some cases.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Improvements:

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

Bug-fixes:

1. Unable to run selected query in some cases.
2. Crashed when using Data Transfer.
3. Unable to show which database is active.
4. 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. "Option" button was missing in the file selection window of Import Wizard.
3. 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. Auto Layout feature separated notes and labels from layers.

To upgrade, please visit our Customer Center.

New Features:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. 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. 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. List View was not retained in the main window after restarting Navicat.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Crashed when running query in some cases.
2. Connections moved out of the group after editing.
3. Crashed when editing model in some cases.
4. 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. Unable to retain selected columns in Foreign Key Selection window.
4. Data Synchronization data grid UI issue in Dark Mode.
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 saving models.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Grid View and Form View menu options were flipped.
2. SQLite table structure cannot be modified when using an HTTP tunnel.
3. The row height of the object list did not match the font size.
4. Column order was incorrect when importing database to model.
5. 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. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Crashed when opening Navicat if logged in Navicat Cloud.
2. Crashed when clicking Views in some cases.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

1. "<html>" tag was repeated twice when exporting HTML file.
2. Crashed when starting Navicat in some cases.
3. Foreign key data selection did not work.
4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. HTML export did not specify charset.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Available Jobs list did not sort alphabetically in Automation.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Crash occurred when adding export profile to a batch job in some cases.
2. Navicat got hanged when viewing SQL Preview in new function.
3. Crash occurred when saving new function.
4. Unable to scroll horizontally in the comparison step of Data Synchronization.
5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. COMMAND-N new object shortcut did not work.
2. Not Null checkbox state was wrong in Table Designer.
3. Crashed when creating new connection in some cases.
4. Import Target and Field Mapping changed after changing the source file in profile.
5. Crashed when closing window in some cases.
6. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to map fields in Import Wizard.
2. New Query shortcut and menu item did not work.
3. Crashed when clicking New Query button in some cases.
4. Crashed when typing in Query Editor in some cases.
5. 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. Unable to filter connections in the Navigation Pane.
5. 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. Added records showed wrong values until refreshing SQLite table grid.
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.

Bug Fixes:

1. Exported Excel files were corrupted 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. Unable to open a table twice.
2. Running multi-statement SQLs with delimiters issue.
3. Crashed when adding default value in Table Designer.
4. Find feature in Table Viewer was not function correctly.
5. Target object name was garbled when copying object named with non-ascii characters.
6. Crashed when executing SQL to insert emoji to table.
7. Crashed when performing Data Transfer in some cases.
8. Navicat hanged when executing scripts in Data Synchronization.
9. Unable to hide the Information pane permanently in Query.
10. Preferences settings reset when Navicat started.

To upgrade, please visit our Customer Center.

Bug Fixes:

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

To upgrade, please visit our Customer Center.

Bug Fixes:

1. The database/schema combo-box did not work in Query.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Information panel retained when opening Navicat.
2. Fixed importing connections with Settings Location issue.
3. Error occurred when modifying SQLite schema or data in App Store version.
4. Command-D shortcut did not open Design form when viewing View data.
5. Unable to resize the assistant editor in Table Viewer.
6. Fixed cursor focus issue in Console.

To upgrade, please visit our Customer Center.

Bug Fixes:

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

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Save dialog prompted even no changes made in Table Designer.
2. Query Builder loading was slow.
3. Unable to execute query in some cases.
4. Data synchronization crashed when HTTP connection was used.
5. Unable to export views on High Sierra.

To upgrade, please visit our Customer Center.

Bug Fixes:

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

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Auto increment field was ignored when importing
2. Navicat hanged when running a query export profile in some cases.
3. Code completion displayed unrelated items.

To upgrade, please visit our Customer Center.

Bug Fixes:

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

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Crashed when executing query in some cases.
2. Failed to sort by Modified Time, Created Time or Data Length in Detail view.
3. Launching Import Wizard was slow.
4. The month and day values were transposed when importing Date fields.
5. Copy/Paste context menu was missing in Table Viewer.
6. Crashed when creating new query without selecting a connection in Navigation pane.
7. Crashed when apply changes for SQLite in Table Viewer.
8. Table mapping was not in alphabetic order in Data Synchronization.
9. Crashed when adding records in Table Viewer.
10. Exported file name did not add timestamp when using Automation.
11. Unable to synchronize queries for SQLite connections in Navicat Cloud.
12. In-App Purchases did not stay activated after restart the app.

To upgrade, please visit our Customer Center.

1. Crashed when exporting query result in some cases.
2. Field names were not shown for SQLite in Query Builder.
3. Lost focus when inputting auto increment value in Table Designer.
4. Table list was not sorted in Export Wizard.
5. Backup object list in the Objects tab was not refreshed after finishing backup.
6. Progress bar did not update when importing.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Unable to copy SQL in the bottom navigation bar of Table Viewer.
2. Crashed when pasting SQL in Query Editor.
3. End Process item in the context menu was disabled in Server Monitor.
4. Incorrect field names were shown in code completion suggestion list.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Fixed displaying object list slow issue.
2. Fixed selecting user slow issue.
3. Fixed the query builder window resize issue.
4. Unable to show users in the Objects tab in some cases.
5. Foreign key's Source Fields list was empty in Table Viewer.
6. The Identifiers list in Query Editor did not show items.
7. "Name" column width was too narrow in Detail view.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Unable to restore in some cases.
2. Query Table shortcut was missing in Table Viewer.
3. Foreign Key's reference database was not changed after transferring to other database.
4. Crashed when launching the application.
5. Unable to set range in Schedule Setup.
6. Memory leak issue in SQL Editor.
7. Current active server/database was not selected when using CMD-Y shortcut to open New Query window.
8. Syntax error occurred in Data Transfer.
9. Sorting by modified/create date did not work for details view in main window.
10. Unable to copy and paste data in Table Viewer.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Shift-Option-Arrow did not work for selecting a word in SQL Editor.
2. Command-R did not refresh the list when database was selected.
3. Unable to resize window in some cases.
4. Unable to type some characters in editor when using international keyboard.
5. Unable to sort the object list in the main window.
6. Unable to log in Oracle server using lower case username.
7. Exporting data with commas to CSV file issue.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Crashed when exporting large query results.
2. Connection name was missing on the tab of Table Viewer.
3. Crashed when exporting query results to CSV file.
4. Query prompted for inputting the same parameter for every occurrence.
5. Unable to accept Terms and Conditions when first login Navicat Cloud.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Wrongly showed primary key warning in View Viewer.
2. Query did not pop up Input Parameter dialog in some cases.
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.

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 Data Synchronization: show particular status to distinguish the differences between records easily.
6. New Automation: easy to find desired profiles and create automated batch jobs.
7. Responsiveness and performance improved.
8. Many other new features and improvements.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Failed to export SQLite views with alias field names.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Unable to show 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. Progress bar did not update in Data Transfer.
2. Unable to expand connection tree in some case if the corresponding tab was not selected.
3. Crashed while working with a profile in a virtual group.
4. Unable to perform data synchronization using command line.
5. Crashed when inserting record with RAW mode in Table Viewer.
6. Failed to move multiple objects into a virtual group by right-click menu in Navicat Cloud connections.

To upgrade, please visit our Customer Center.

Bug Fixes:

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

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Fixed the column order issue when using Copy As Insert/Update in Table Viewer.
2. Failed to close the parameter window after opening in Function Designer.
3. App Store Essentials version: Failed to keep the "Show Object List" state in Query.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Functions were removed after editing the query in Query Builder.
2. Unable to remember the file path if the path contains space in Export Wizard.
3. Model History pane showed many changing color histories in some cases.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Background color of keyword "SUM" did not change with non-white background in Query Editor.
2. Auto-completion did not work for 1 char alias in Query Editor.
3. Extra database name was added when drag and drop a table to Query Builder.
4. Crashed when creating backup in Cloud connections.
5. Crashed when double-clicking the "Find in Database" result in some cases.
6. Queries with "JOIN" was not parsed correctly in some case in Query Editor.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Wrongly added extra " char in the exported data when the data contained " char.
2. Unable to open the Find result in "Find in Database".
3. Unable to change the field order by dragging in the SELECT tab of View Builder.
4. "Show Result" setting of Query was not saved immediately.
5. No response after clicking "User" button for SQLite.
6. Wrongly deleted the edited SQLite view after saving the modification.
7. Unable to disable the folding setting of Query Editor in Preferences.
8. Unable to show column names for SQLite in Query Builder.
9. Crashed when double-click to select the query and run selected.
10. Crashed when loading server preferences from preference.plist file on launching Navicat.
11. Unable to open the saved import profile.
12. Unable to show [] with black background in Query Editor.
13. Shortcuts CTRL-A, CTRL-E were missing in Query Editor.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Adding multiple relations issue in Model's Table Designer.
2. Unable to uncheck the "Limit records per page" box in Table Viewer.
3. Crashed when pasting SQL to Query Editor.
4. Detaching database file from SQLite connection corrupted connections in the Connection pane.
5. Error occurred when saving views after applying Beautify SQL.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Unable to save the "Show Object List" option in Query.
2. There was no syntax highlight in the SQL Preview tab.
3. Unable to show the cursor in Query Editor with black background.
4. Failed to drag and drop connection in some cases.
5. Smart quote issue in Query Editor.
6. Font issue in Query Editor.
7. Find feature issue in Query Editor.
8. Unable to copy more than 30 rows in Table/Query Viewer.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Pop-up options of selected cell were missing in Table Viewer.
2. Objects tab was not selected when clicking an item in the Connection pane.
3. Unable to resize the width of main window as Version 11.1.
4. All field names were placed on the same line after applying Beautify SQL.
5. Unable to show the column list of "Show/Hide Columns" in Table Viewer on Mac OS X 10.10.
6. CMD+F shortcut did not work in the main window on Mac OSX 10.11.

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. SQLite Users Management.
2. Enhanced Filter Wizard.
3. Enhanced Query Designer.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Failed to log in Navicat Cloud in some cases.
2. Crashed when running Structure Synchronization.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Unable to copy backup files to another database by drag and drop method.
2. Crashed when running Data Transfer more than once on OS X 10.11.
3. Crashed when running SQL multi times in Console.

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. "Database file path is not correct" error occurred when opening SQLite database files from finder.
3. Unable to change the case of the backup file name.
4. Lost connections in some cases.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Crashed when importing connections.
2. Crashed when reversing database to model.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Object List tab did not change when selecting nodes from connection tree.
2. Unable to send email when running batch jobs using Command Line.
3. Failed to save the order of connections in Navicat Cloud.

To upgrade, please visit our Customer Center.

Bug Fixes:

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

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Fixed import DBF file with empty datetime value issue.
2. Error occurred when opening SQLite files with the same name by double-clicking the database files.

To upgrade, please visit our Customer Center.

Improvements:

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

Bug Fixes:

1. Fixed the time interval setting issue in Schedule.
2. Fixed the multi headers issue when exporting multi SELECT query to XML file.
3. Fixed the warning issue when renaming query.

To upgrade, please visit our Customer Center.

Improvements:

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

Bug Fixes:

1. Crashed in SSH re-connection.
2. Fixed the smart quotes/dashes issue in Query Builder.
3. Fixed the data type issue when importing xlsx in Import Wizard.

To upgrade, please visit our Customer Center.

Improvements:

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

Bug Fixes:

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

To upgrade, please visit our Customer Center.

Improvements:

1. Supported copy data as INSERT/UPDATE statements in Table Viewer.

Bug Fixes:

1. Unable to copy data of unknown SQLite field type in Table Viewer.
2. Error occurred when changing the case of the connection name.
3. Crashed when importing database/schema to Model.
4. Crashed when creating Navicat Cloud account.
5. Wrongly applied "Use smart quotes and dashes" setting in Console.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Navicat Cloud login checking restriction.
2. The Select/Where/Group By/Having/Order By clasue bar disappeared in Query/View Builder.
3. Connections are moved out from virtual groups after upgrading from version 11.0.
4. Crashed when saving profiles.
5. Select fields panel in Table Designer did not update after the table was saved.
6. INT type values were rounded up when importing XLS files.
7. Table Designer view was not displayed corrently in HTTP connections.

To upgrade, please visit our Customer Center.

Improvements:

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

Bug Fixes:

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

To upgrade, please visit our Customer Center.

Bug Fixes:

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

To upgrade, please visit our Customer Center.

Improvements:

1. Added Show in Finder feature for Query, Backup and Model.
2. Added Open with External Editor feature for Query.

Bug Fixes:

1. Press CMD-F again did not highlight the text of the search field in Table Viewer.
2. Crash when control-click a database in connection tree on OS X 10.9 below in Essentials version.
3. Failed to save SSH password for Navicat Cloud connection.
4. Unable to close Navicat with CMD-Q when opened more than one tabbed windows.
5. Unable to perform data synchronization for SQLite databases.

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. Crashed when opening a table which contained a self referenced foreign key without the referenced field.

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.

To upgrade, please visit our Customer Center.

Bug Fixes:

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

To upgrade, please visit our Customer Center.

Improvements:

1. Update SQLite to 3.8.4.
2. Allow drag to reorder field as default in Table Designer.

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. When previewed and enabled save queries to file, queries were not correctly written to the file in Data Synchronization.
6. The file and file size position in Model info view were wrong.
7. Crashed when right-clicked on an open area and seleted "Restore Backup".
8. The bookmark setting of saved path was incorrect in Backup schedule.

To upgrade, please visit our Customer Center.

Improvements:

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

Bug Fixes:

1. Tab was unable to be dragged and reordered in full screen mode.
2. Crashed when using Find function in Table Viewer.
3. Copy and Paste did not work on tables with auto-incremented columns while saving a record by clicking "tick" icon in the Table Viewer.
4. Crashed when selecting a suggested word that required quoting in Scintilla auto completion.
5. Crashed while scrolling table in Query Builder and exited Navicat.
6. int with "." as Thousand Separator did not import correctly in Import Wizard.
7. The datetime format showed in the export profile did not match the format used in the original table.
8. Date and time were exported incorrectly while using a EDT time zone.
9. Message Log was unable to save correctly for the Preview function in Data Synchronization.
10. 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.
11. Crashed when double-clicking the connection tree under Synchronize to Database in Data Modeling Tool.
12. Schedele helper did not work although jobs still run in old version.
13. Website version: Typed in the export queries filepath directly would cause file creation error in Data Synchronization.
14. App Store Essentials version: Crashed when purchasing Code Completion feature without SQL Builder in View Designer.

To upgrade, please visit our Customer Center.

Improvements:

1. Improved connection tree behavior in main window.

Bug Fixes:

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

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. Identifier name quoting problem in SQLite.
4. 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. Allow to select tag to identify data when exporting table to JSON format.
3. Improved the update statement when editing SQLite table with rowid primary key in Table Viewer.
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. Enabled Open button and Restore Backup menu item when no backup profile is selected.
4. Wrongly quoted the value in Export output file.
5. Failed to save connection order in main window.
6. Editor failed to show when first open the Table/View Viewer.
7. Unable to save the resultset's column width after re-run the query.
8. App Store version: Failed to list tables after connected.
9. 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. App Store version: Failed to open database file.

To upgrade, please visit our Customer Center.

Improvements:

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

Bug Fixes:

1. Crash occured while deleting tables with foreign keys on ER diagram.
2. Options missing in Export profile.
3. Fixed support "," in schedule time setup.
4. The text colour in Text Editor did not follow the "Common" colour in Preferences.
5. 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 SQLite to 3.7.17.
2. Updated libxl to 3.5.3.
3. Adjusted caret color same in Scintilla.
4. Support sorting items by name inside a virtual group.

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. Export failed in query result.
9. Crashed in Structure Synchronization.
10. App Store version: "Database file path not correct" error occured for new database file connection.
11. App Store version: Created SQLite database file got removed upon clicking "OK" on connection panel.
12. App Store version: Error occured when adding images in Data Modeling Tool.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Junk data inserted into Table and Query viewer while having columns of unknown data type in Find and replace feature.

To upgrade, please visit our Customer Center.

Bug Fixes:

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

To upgrade, please visit our Customer Center.

Bug Fixes:

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

To upgrade, please visit our Customer Center.

Improvements:

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

Bug Fixes:

1. Crashed in Table Designer with HTTP connection established.
2. Sorting function did not work properly.
3. Find Next/Previous in Find and Replace function went wrong after drag and drop column.
4. The result range not highlighted in Find function.
5. Blank page appeared in Table Viewer while scrollling down to the end of the page and switching to the last page, when the table contained more than 1000 rows.
6. Links between join tables would lost in Query/View Builder.
7. Query was unable to parse the delimiter properly.
8. Duplicated queries were run when exporting result set in Query Viewer.

To upgrade, please visit our Customer Center.

Improvements:

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

Bug Fixes:

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

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)

Others

1. New Registration and Activation System
2. New Updater

To upgrade, please visit our Customer Center.

Bug Fixes:

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

To upgrade, please visit our Customer Center.

Improvements:

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

Bug Fixes:

1. Slow performance experienced when editing on grid due to allocation of field editor menu on demand.
2. Export file name with date format was excluded in the saved export profile.
3. Tables with changed fields were unable to synchronize in Synchronize to Database function under Data Modeling Tool.
4. Incorrect orientation and size were set while printing model in Data Modeling Tool.
5. Sorting columns with numeric values was not working properly in Server Monitor.
6. When scheduling an export job with sending mail attachment, the attachment failed when the exported file name contained datetime.
7. Close bracket problem in XML export file.
8. Numeric type fields did not accept non-BLOB values in Table Viewer.

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. Remote connection failed.
2. Scintilla font size doubled in Apple retina display.
3. Popup window did not show while clicking on Delete item button with no rows being selected in Table Designer.
4. Datetime value was not obtained correctly from ODBC in Import Wizard.
5. Index and unique were missing under Data Modeling Tool Table Designer.