Bug-fixes:

1. Incorrect CREATE INDEX statements were generated when comparing PostgreSQL model.
2. MySQL/MariaDB connection encoding issue.
3. Error occurred when debugging PostgreSQL functions.
4. Wrong MySQL version was detected for Microsoft Azure connection.
5. Numeric data was shown as String in the chart data source.
6. Unable to change the owners of PostgreSQL functions.
7. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to show user's database privileges in MySQL 5.0.
2. Unable to change the label text color in Report's header.
3. Incorrect default value was displayed for BIT field in a new record.
4. Incorrect Foreign Key ALTER statements were generated when synchronizing PostgreSQL table structures.
5. Notification email subject was incorrect when the job finished unsuccessfully.
6. Cursor focusing issue when using Find feature in Table Viewer.
7. 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. Slow response when querying the full collection count.
2. Flashed in dark mode.
3. 'Unallowed argument in list...' error when running export / import schedule.
4. Error occurred when modifying the value in a DateTimeOffset field.
5. Unable to load version 10 data synchronization profiles.
6. Differences were incorrectly detected in Synchronize to Database.
7. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to import MEMO data from DBF files.
2. Unable to reconnect SSH connection after the PC woke up.
3. Unable to display SQLite view definition in some cases.
4. Unknown Internal Error occurred when executing Oracle's package body.
5. Crashed when setting multiple cells to NULL in Table Viewer.
6. ORA-01002 error occurred when migrating data from Oracle to PostgreSQL.
7. Unable to display full Oracle view definition in some cases.
8. Incorrect PostgreSQL function definition was displayed in some cases.
9. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. 'IDENTITY_INSERT is already ON' error occurred when synchronizing SQL Server tables.
2. Unable to show records that had -1 data in Table Viewer.
3. 'Drop target objects before create' option did not work in Data Transfer.
4. Memory leak issue when enabled code completion.
5. 'Relation does not exist' error occurred when debugging a function in a schema other than the 'public' schema.
6. 'Unknown Internal Error (A70529211102SE)' error occurred when exporting / importing data.
7. Slow issue when transferring large tables.
8. Unable to show the inputted text in Filter Wizard.
9. Error occurred when filtering data by right-clicking a cell in Table Viewer.
10. 'Cannot insert into column' error occurred when transferring PostgreSQL tables.
11. Inserted records to the wrong table when transferring data to the target table with a different name.
12. 'Debugger Plugin is not installed or enabled' error occurred when the extension was installed in another schema.
13. Unable to connect MySQL server when using TLSv1.2.
14. 'COMMENT ON FUNCTION' clause was mistakenly generated when synchronizing PostgreSQL procedures.
15. 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. Unable to show users' database privileges in MySQL 5.0.
4. Negative default value displayed as '-' in MariaDB.
5. Drop-down list was blank in Table Designer.
6. Unable to scroll after switching the query results to Form view.
7. Wrong SQL generated when adding aggregates using Query Builder in SQL Server.
8. Double quotes were added to the fields of a compound index in Oracle.
9. Syntax error occurred when transferring data between two MySQL 8 servers.
10. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

New Features:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Improvements:

1. Set the values of a column to NULL.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Improvements:

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

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Improvements:

1. Improvement on resizing Information pane.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

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. Unable to export the fractional part when the decimal separator was comma.
2. Unable to select privileges in the 'Add Privilege' window by using the Space key.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Crashed when restoring the backup file to another database.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. 'IDENTITY_INSERT is already ON' error occurred when synchronizing SQL Server tables.
2. Crashed when using Charts in some cases.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

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

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Negative default value displayed as '-' in MariaDB.
2. An empty diagram was created when reversing a database to a model.
3. Unable to change font for Editor and Records.
4. Unable to display special characters of SQL Server query results.
5. The selected privileges were inverted when adding database privileges.
6. Error occurred when changing user password in MySQL 5.6.
7. CREATE USER statement on the SQL Preview tab was wrong.
8. Query returned different results for an empty row.
9. DROP DEFAULT clause was incorrectly added to the statement when opening PostgreSQL table designer.
10. Unable to copy the selected text with shortcut in Console.
11. Crashed when importing tables to a model.
12. Unable to add a table to the model using the mouse.
13. Delay when pasting with CTRL+V.
14. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

New Features:

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

To upgrade, please visit our Customer Center.