Softpedia >Windows >Internet >Servers >Database Utils >Navicat Premium Essentials >  Changelog

Navicat Premium Essentials Changelog

What's new in Navicat Premium Essentials 16.3.9

Apr 16, 2024
  • Bug-fixes:
  • Incorrect SQL format when dumping Mariadb table.
  • Syntax error occurred when transferring tables with escape characters.
  • Unable to show data in some cases.
  • Unable to connect Azure CosmosDB using SSH tunnel.
  • Unable to connect PostgreSQL in some cases.
  • Minor bug fixes and improvements.

New in Navicat Premium Essentials 16.3.8 (Feb 29, 2024)

  • Bug-fixes:
  • Crashed when PostgreSQL connection was lost.
  • Primary key index incorrectly displayed when data type was citext.
  • Minor bug fixes and improvements.

New in Navicat Premium Essentials 16.3.7 (Feb 21, 2024)

  • Bug-fixes:
  • Importing data to Redshift was slow.
  • Crashed when importing paradox files.
  • Failed to import JSON file from web service.
  • Unable to transfer data from Redshift.
  • Refresh button did not work in Server Monitor.
  • Some labels disappeared after adding the chart to the dashboard.
  • Unable to display proportion percentages in the chart axis.
  • Minor bug fixes and improvements.

New in Navicat Premium Essentials 16.3.5 (Jan 11, 2024)

  • Bug-fixes:
  • The percentage values shown in the chart were incorrect.
  • Not all data was imported when scheduling import.
  • Unknown Internal Error occurred when importing data.
  • The comment code shortcut did not work in some cases.
  • Unknown Internal Error occurred when transferring data.
  • Minor bug fixes and improvements.

New in Navicat Premium Essentials 16.3.3 (Dec 1, 2023)

  • Improvements:
  • Support Huawei Cloud GaussDB Distributed.
  • Support enabling or disabling "Detect Data Types" in Import Wizard.
  • Support ssh agent using pageant unix mode.
  • Bug-fixes:
  • Primary keys were not displayed for PostgreSQL partitioned tables.
  • Minor bug fixes and improvements.

New in Navicat Premium Essentials 16.3.2 (Nov 7, 2023)

  • Unable to show the privileges of "public" in PostgreSQL Privilege Manager.
  • Minor bug fixes and improvements.

New in Navicat Premium Essentials 16.3.0 (Oct 17, 2023)

  • Improvements:
  • Support setting MySQL descending primary key.
  • Bug-fixes:
  • Minor bug fixes and improvements.

New in Navicat Premium Essentials 16.2.11 (Oct 4, 2023)

  • Bug-fixes:
  • Crashed when opening Charts workspaces in some cases.
  • "The number of row value expressions in the INSERT statement exceeds the maximum allowed number of 1000 row values." error occurred when importing data to SQL Server.
  • Unable to show all documents in Serverless MongoDB Atlas.
  • Missing parameters when transferring MariaDB Functions.
  • Crashed when scheduling import jobs.
  • 1064 error occurred when running query to create stored procedure in some cases.
  • Missing records when importing files in some cases.
  • Special characters were garbled when using double-click to add a snippet to the query.
  • Minor bug fixes and improvements.

New in Navicat Premium Essentials 16.2.10 (Sep 7, 2023)

  • Crashed when importing Access files.
  • Minor bug fixes and improvements.

New in Navicat Premium Essentials 16.2.8 (Aug 29, 2023)

  • Improvements:
  • Auto guess field types when importing xlsx files.
  • Bug-fixes:
  • Beautify SQL incorrectly added spaces between the function name and parentheses.
  • Dump SQL File did not correctly generate DEFAULT PARTITION.
  • Minor bug fixes and improvements.

New in Navicat Premium Essentials 16.2.7 (Aug 14, 2023)

  • Bug-fixes:
  • Incorrectly triggering code completion when pressing ENTER in Query Editor.
  • Minor bug fixes and improvements.

New in Navicat Premium Essentials 16.2.6 (Aug 8, 2023)

  • Improvements:
  • Support JSON key type for Redis.
  • Bug-fixes:
  • Unable to close tabs in some cases.
  • Slashes () were removed from triggers when synchronizing MariaDB structures.
  • Minor bug fixes and improvements.

New in Navicat Premium Essentials 16.2.5 (Jul 14, 2023)

  • Bug fixes:
  • "Implicit conversion from data type" error occurred when synchronizing SQL Server data.
  • The default directory of new SQL Server database was incorrect.
  • Unknown Internal Error occurred when connecting to Redis.
  • Cannot type a new name for the table in Import Wizard.
  • Minor bug fixes and improvements.

New in Navicat Premium Essentials 16.2.3 (Jun 20, 2023)

  • Expressions for virtual columns were truncated.
  • Unable to display SQLite BLOB data.
  • Minor bug fixes and improvements.

New in Navicat Premium Essentials 16.2.2 (Jun 9, 2023)

  • Improvements:
  • Support unix socket forwarding in SSH.
  • Bug-fixes:
  • Unable to connect SQL Server using the Encrypted option.
  • Minor bug fixes and improvements.

New in Navicat Premium Essentials 16.2.1 (May 31, 2023)

  • Main New Features:
  • Support Redis connections.
  • View, edit, search and sort Redis keys and data with Data View.
  • Capture and analyze Redis Pub/Sub messages in real-time.
  • Support local backup and restore of Redis databases.
  • Intuitive interface for editing Redis users and ACLs.
  • Redis Console with syntax highlight and code completion.
  • Well-formatted Redis query results.
  • Automate Redis backup and query execution.
  • Command Monitor and Server Monitor for real-time monitoring of Redis.
  • Support sequence design for MariaDB.
  • Show fields, indexes and more under tables in Navigation Pane.
  • Minor bug fixes and improvements.
  • Navicat for Redis is released.

New in Navicat Premium Essentials 16.1.15 (Apr 26, 2023)

  • Bug-fixes:
  • High CPU usage when using SSH connection.
  • "permission denied for view geometry_columns" error occurred when opening PostgreSQL table.
  • Minor bug fixes and improvements.

New in Navicat Premium Essentials 16.1.12 (Apr 17, 2023)

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

New in Navicat Premium Essentials 16.1.11 (Mar 14, 2023)

  • Minor bug fixes and improvements.

New in Navicat Premium Essentials 15.0.29 (Dec 5, 2022)

  • Bug-fixes:
  • Failed to transfer large tables.
  • Real data exported as text when exporting SQLite table to Excel.
  • Crashed when batch querying tables with FK dependency.
  • Unknown Internal Error occurred when exporting large amount of data.
  • SQL Server datetimeoddset column did not display the timezone offset.
  • Minor bug fixes and improvements.

New in Navicat Premium Essentials 16.1.4 (Nov 21, 2022)

  • Bug-fixes:
  • 1267 error occurred when clicking the "Users" button.
  • Unable to connect Azure Database for PostgreSQL with Azure Active Directory Authentication.
  • Bar chart label display issue.
  • Unable to export Excel file in some cases.
  • Hanged when transferring tables.
  • Unable to connect CockroachDB Serverless.
  • Minor bug fixes and improvements.

New in Navicat Premium Essentials 16.1.3 (Sep 28, 2022)

  • Bug-fixes:
  • Unable to connect server using HTTP tunnel in some cases.
  • Font size issue in Form View.
  • Unknown Internal Error occurred when adding records in SQL Server Views.
  • Field size was not retained in SQLite table designer.
  • Buttons in the lower right corner of the main window were missing in some cases.
  • Minor bug fixes and improvements.

New in Navicat Premium Essentials 16.1.2 (Aug 31, 2022)

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

New in Navicat Premium Essentials 16.1.1 (Aug 16, 2022)

  • Bug fixes:
  • Unable to open the objects in the "Find in Database" window.
  • The first number of every value in the list was removed in the table filter.
  • Unknown Internal Error occurred when updating query results in some cases.
  • Unable to use "Copy As" in View results.
  • Crashed when opening functions in some cases.
  • Unknown Internal Error occurred when foreign key selection window popped up.
  • Unable to open schema in Azure SQL.
  • Crashed when clicking on the value box in table filter.
  • Decimal separator issue in SQLite.
  • Cannot retain the window size and position for existing objects.
  • Minor bug fixes and improvements.

New in Navicat Premium Essentials 16.1.0 (Jul 21, 2022)

  • Support OceanBase Community Edition.
  • Support Trend Line for several chart types.
  • Support adding On-Prem Server with URI.
  • Allow skip preview of changes in data sync.
  • Enhanced responsiveness and performance.
  • Improved UI/UX.
  • Minor bug fixes and improvements.

New in Navicat Premium Essentials 16.0.14 (Jun 14, 2022)

  • Bug-fixes:
  • Query parameters did not work in some cases.
  • Unable to synchronize PostgreSQL data in some cases.
  • Decimal precision issue when importing from Excel files.
  • Minor bug fixes and improvements.

New in Navicat Premium Essentials 16.0.13 (May 16, 2022)

  • Bug-fixes:
  • Crashed when opening large tables.
  • Incorrect MySQL auto increment value in Table Designer.
  • SQL Server datetimeoddset column did not display the timezone offset.
  • Minor bug fixes and improvements.

New in Navicat Premium Essentials 16.0.9 (Jan 13, 2022)

  • Bug-fixes:
  • The "Compare" button did not work in Data Synchronization in some cases.
  • "Couldn't open known_hosts file" error occurred when the SSH path contained Chinese characters.
  • Minor bug fixes and improvements.

New in Navicat Premium Essentials 16.0.7 (Jan 3, 2022)

  • Bug-fixes:
  • Unable to show data when using HTTP tunnel.
  • Unable to show utf8mb4 data.
  • Minor bug fixes and improvements.

New in Navicat Premium Essentials 16.0.6 (Dec 15, 2021)

  • Bug-fixes:
  • Connection encoding issue in Navicat Cloud.
  • Connection password issue when updating connection in Navicat Cloud.
  • Error occurred when synchronizing to Navicat Cloud.
  • Unknown Internal Error occurred when designing PostgreSQL table.
  • Minor bug fixes and improvements.

New in Navicat Premium Essentials 16.0.4 (Dec 7, 2021)

  • Bug-fixes:
  • Syntax error occurred when importing data to MySQL table.
  • Notification Email authentication failed in some cases.
  • Minor bug fixes and improvements.

New in Navicat Premium Essentials 15.0.26 (Jul 28, 2021)

  • Improvements:
  • Support Retryable Writes and Retryable Reads for MongoDB.
  • Support tunneling on PHP 8.
  • Bug-fixes:
  • Unable to show accurate value of Oracle BINARY_DOUBLE type.
  • Unknown Internal Error occurred when importing Excel file in some cases.
  • Wrong SQL generated when comparing SQL Server tables with different constraint names.
  • An empty string was not quoted when exporting to a text file.
  • Query was garbled when the system locale set to Japanese.
  • Export/Import profile did not work if it was copied to Desktop.
  • Minor bug fixes and improvements.

New in Navicat Premium Essentials 15.0.22 (Jan 13, 2021)

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

New in Navicat Premium Essentials 15.0.17 (Sep 14, 2020)

  • Bug-fixes:
  • Differences were detected when re-comparing the model and the database.
  • Unable to synchronize large ndm2 model files to Navicat Cloud.
  • Unable to show users' database privileges in MySQL 5.0.
  • Negative default value displayed as "-" in MariaDB.
  • Drop-down list was blank in Table Designer.
  • Unable to scroll after switching the query results to Form view.
  • Wrong SQL generated when adding aggregates using Query Builder in SQL Server.
  • Double quotes were added to the fields of a compound index in Oracle.
  • Syntax error occurred when transferring data between two MySQL 8 servers.
  • Minor bug fixes and improvements.

New in Navicat Premium Essentials 15.0.13 (May 5, 2020)

  • Bug-fixes:
  • MySQL table row format reverted to Compact after editing.
  • Unknown Internal error occurred when opening Oracle tables.
  • Syntax error occurred when creating events.
  • Unable to set default value for fields in Table Designer.
  • Unable to show SUPER privilege for MariaDB 10.4 in the user object list.
  • Foreign key was dropped and added when re-comparing the model.
  • Data Pump Import's Table Exists Action drop-down list options were incorrect.
  • Minor bug fixes and improvements.

New in Navicat Premium Essentials 15.0.13 (Apr 15, 2020)

  • MySQL table row format reverted to Compact after editing
  • Unknown Internal error occurred when opening Oracle tables
  • Syntax error occurred when creating events
  • Unable to set default value for fields in Table Designer
  • Unable to show SUPER privilege for MariaDB 104 in the user object list
  • Foreign key was dropped and added when re-comparing the model
  • Data Pump Import's Table Exists Action drop-down list options were incorrect
  • Minor bug fixes and improvements

New in Navicat Premium Essentials 15.0.12 (Mar 24, 2020)

  • Bug-fixes:
  • Query wrongly returned null results in some cases.
  • Unable to update bit type data.
  • Datetime format issue when exporting to Excel files.
  • Query Results Text pane appended values of the selected cells.
  • Syntax error occurred when renaming an index in MariaDB table.
  • "No such column" error when adding column to SQLite table.
  • Minor bug fixes and improvements.

New in Navicat Premium Essentials 15.0.11 (Mar 24, 2020)

  • Bug-fixes:
  • Query wrongly returned null results in some cases.
  • "," was replaced by "." when using Custom Filter in Table Viewer.
  • Relation attributes were wrong after reopening the logical model.
  • Minor bug fixes and improvements.

New in Navicat Premium Essentials 15.0.10 (Feb 19, 2020)

  • Improvements:
  • Added "Table Relation" and "Field Relation" options to Query Builder
  • Added Connection Coloring to Query windows
  • Bug-fixes:
  • Unknown Internal Error occurred when starting Navicat in some cases
  • Crashed when importing two XML files
  • Popup menu was missing when right-clicking on stored procedure results
  • The performance of Privilege Manager was slow
  • Unable to synchronize decimal data from MariaDB to MySQL 80
  • Refresh button in Privilege Manager did not pull the latest privileges
  • Differences were detected after synchronizing model to database
  • Syntax error occurred when saving procedures in some cases
  • Datetime functions generated text in exported Excel files
  • Hanged when searching regular expression in Query Editor
  • Error occurred when transferring computed columns from SQL Server to another SQL Server
  • Minor bug fixes and improvements

New in Navicat Premium Essentials 15.0.6 (Jan 6, 2020)

  • Improvements:
  • Added shortcuts for "Run Current Statement" and "Select Current Statement" in Query Editor.
  • Bug-fixes:
  • "Unknown Internal Error" occurred when modeling databases.
  • Find bar UI issue in Data Viewer.
  • Unable to print table when using popup menu on Navigation pane.
  • Syntax error occurred when renaming index in MariaDB table.
  • "No such column" error occurred when adding field to SQLite table.
  • Explain feature did not work with query parameters.
  • Interval type was not supported in Charts.
  • Highlight color issue in Filter wizard when using Dark mode.
  • Minor bug fixes and improvements.

New in Navicat Premium Essentials 15.0.4 (Dec 9, 2019)

  • Bug-fixes:
  • Access violation error occurred when adding users to Navicat Cloud project.
  • Access Denied error occurred when designing table.
  • Unable to highlight field when typing in Filter's field selection list.
  • Wrong fields are exported to the SQL file when not all fields are selected.
  • Dark theme kept reverting back to Normal theme.
  • Wrong CREATE INDEX was generated in Model.
  • MySQL JSON data was truncated in Table Viewer.
  • Empty value was exported as **** when exporting DBF file.
  • Data Transfer high memory consumption issue.
  • Unable to connect Azure Database for MariaDB.
  • Run queries slow issue.
  • Unable to set Numeric field without precision in PostgreSQL server.
  • "List index out of bounds (-1)" error occurred when editing role privileges.
  • "Last Tab Window" option was missing.

New in Navicat Premium Essentials 15.0.3 (Nov 26, 2019)

  • Navicat 15 comes with numerous improvements and features to address your database development needs. With over 100 enhancements, Navicat gives you new ways to build, manage, and maintain your databases.
  • Smart Charts:
  • Understand your data better.
  • Our new data visualization tool enables you to transform your data into effective visualizations to identify trends, patterns and outliers. Simplify data analysis and share your workspaces to colleagues for better support your business decisions and strategies.
  • Dashboard:
  • Build an interactive dashboard to display a collection of your charts. Combine multiple views of data to get richer insight. You can also create separate dashboards for different topics that you would like to track.
  • Advanced Charts:
  • Navicat 15 supports 20 chart types. Pick the best-fitting one to ensure your data is clear and accurate presented.
  • Powerful Data Transfer:
  • Send large files to anyone.
  • We are bringing a new experience along with a number of new functions to Data Transfer. Our new design comes with an intuitive interface for customizing the fields and specifying the number of rows you wish to transfer. More importantly, Navicat 15 can robustly and quickly transfers massive amounts of data. So you can accomplish complex transfers faster than ever before.
  • Query Builder:
  • Build your queries faster and visually in new UI.
  • A new approach for SQL writing is released in Navicat 15. Our new SQL Builder embeds an incredibly easy-to-use and an even more intuitive syntax panel for constructing your SQL statement. Navicat 15 not only allow to add subquery to further limit your query results, but also preview the query you are working on and make modification once you locate any syntax errors are made.
  • New Data Modeling Tool:
  • Compare objects before syncing your databases.
  • Navicat 15 introduces a new mechanism for Synchronize to Database function. It provides an easier and more intuitive way to visually compare and identify the differences between model and database. And it shows side-by-side DDL comparison that makes it easy to locate all the object differences. Choose and reorder your synchronization scripts to update the destination database.

New in Navicat Premium Essentials 12.1.24 (Oct 30, 2019)

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

New in Navicat Premium Essentials 12.1.23 (Sep 17, 2019)

  • Bug-fixes:
  • Export process was slow.
  • Unable to dump the default value of TIMESTAMP field.
  • Synchronize to Database feature wrongly detected differences of unique constraints.
  • Minor bug fixes and improvements.

New in Navicat Premium Essentials 12.1.19 (Jun 10, 2019)

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

New in Navicat Premium Essentials 12.1.18 (Apr 18, 2019)

  • Error occurred when connecting to MySQL 4.0.
  • Unable to execute SQL files that contain "NaN" values.
  • Primary Key checkbox was deselected when tabbing to the next field in Table Designer.
  • "Unknown Internal" error occurred when importing data.
  • The DDL of PostgreSQL tables with "tstzrange" data type was incorrect.
  • Table Designer cannot show the definition of MySQL 5.0 triggers.
  • Unable to set the precision of "datetime2" data type to 0 in Table Designer.
  • The deployment scripts generated incorrect default value in Structure Synchronization.
  • "Access Violation" error occurred after editing the data pipeline in Report.
  • "Unknown Internal" error occurred when using Automation.
  • Minor bug fixes and improvements.

New in Navicat Premium Essentials 12.1.17 (Mar 21, 2019)

  • Bug-fixes:
  • SQLite table structure cannot be modified when using an HTTP tunnel.
  • Query result pane size did not retain after minimizing the window.
  • Paradox tables cannot be imported.
  • Unknown Internal error occurred when importing data.
  • Unknown Internal error occurred when opening GridFS Buckets.
  • "On Update Current Timestamp" option did not reflect the settings when using ANSI_QUOTES SQL mode.
  • Column order was incorrect when importing database to model.
  • Minor bug fixes and improvements.

New in Navicat Premium Essentials 12.1.16 (Feb 26, 2019)

  • "Replace All" button was unable to replace the last occurrence in Query Editor
  • Code completion suggestion list did not show on the same screen as the editor
  • Crashed when opening Oracle table with Spatial data
  • A table was mistakenly transferred even it was not selected
  • Incorrect syntax highlighting issue in Query Editor
  • MySQL trigger definition displayed \ as
  • Unable to transfer unique index from MySQL to SQLite
  • Filter criteria input box was not retained when switching applications
  • Drag and drop selected text on Query Editor did not move the text
  • JSON expression did not display correctly in Table Designer
  • Minor bug fixes and improvements

New in Navicat Premium Essentials 12.1.12 (Jan 10, 2019)

  • Console window was not colored when connection coloring were set.
  • Minor bug fixes and improvements.

New in Navicat Premium Essentials 12.1.9 (Nov 23, 2018)

  • Improvements:
  • Added the "PostgreSQL 11" option in Model.
  • Added the "Compare owners" option in Structure Synchronization.
  • Bug-fixes:
  • Slow performance when editing users and roles.
  • Structure Synchronization detected differences for identical SQL Server tables.
  • "SQLite function XXX cannot linked" error occurred after replacing the sqlite3.dll file.
  • Unable to show the ROWID column when running Oracle queries.
  • RAISE NOTICE output was not printed.
  • Unable to connect SQL Server when VPN connection was active.
  • Floating point numbers were rounded to decimals when import.
  • <html> tag was repeated twice when exporting HTML files.
  • "Add Database to List" button was enabled when the "Use custom database list" option was not checked.
  • Only the last output was printed when running multiple SQL Server Print() commands.
  • SQL Server MERGE statement only can terminated by a semi-colon (;).

New in Navicat Premium Essentials 12.1.7 (Sep 10, 2018)

  • "SQLite function sqlite_libversion cannot linked" error occurred when starting Navicat.
  • Unknown Internal Error occurred when using foreign key data selection feature in SQL Server.
  • Unable to scroll inside the text box in Form View.
  • Slow issue when managing PostgreSQL Role.
  • "is in list" operator in Filter Wizard did not working correctly.
  • Structure Synchronization compared table options.
  • Minor bug fixes and improvements.

New in Navicat Premium Essentials 12.1.6 (Aug 21, 2018)

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

New in Navicat Premium Essentials 12.1.5 (Jul 31, 2018)

  • Improvements:
  • Improved Filter Wizard.
  • Supported expression for default field value in Table Designer.
  • Bug-fixes:
  • Crashed when applying filter in Foreign Key Selection window.
  • Error occurred when synchronizing PostgreSQL structure.
  • Minor bug fixes and improvements.

New in Navicat Premium Essentials 12.1.4 (Jul 26, 2018)

  • Support of MongoDB
  • Support Roles for MySQL 8
  • Support Roles for MariaDB 10
  • Support Partitioned Table for PostgreSQL 10
  • Brand new Filter Wizard
  • UI and UX Improvement
  • Navicat for MongoDB is released

New in Navicat Premium Essentials 12.0.28 (May 8, 2018)

  • Bug Fixes:
  • 80041318 error occurred when saving a task schedule.
  • The cursor position row moved to the bottom line after saved the procedure/function.
  • "XXX is not a valid value" error occurred when editing a PostgreSQL model table in some cases.
  • Syntax error occurred when updating MySQL user password.
  • Transaction did not end after closing the table in some cases.
  • Error occurred when there was a "CRLF" character in Oracle procedure.

New in Navicat Premium Essentials 12.0.27 (Apr 26, 2018)

  • Unable to transfer objects between different server types by drag-and-drop.
  • Zero decimal place digits were not displayed in Table Viewer.
  • "Double" format issue for SQL Server in Table Viewer.
  • Exported SQL file did not have table name when exporting an unsaved query.
  • Incorrect SQL "ON UPDATE CURRENT_TIMESTAMP(0)" was dumped for MariaDB 5.5 tables.
  • The privileges of PostgreSQL functions with parameters were not visible in Privilege Manager.
  • Error occurred when transferring BLOB data from MySQL to SQL Server.
  • Unknown Internal Error occurred when importing from ODBC.
  • Incorrect dates were exported when exporting PostgreSQL tables to Excel files.
  • Syntax error occurred when importing CSV files in some cases.
  • Database names were missing in the Drop SQL generated by Structure Synchronization.
  • ORA-01830 error occurred when transferring tables to Oracle server in some cases.
  • Unable to change the Tab Width in Query Editor.
  • Unable to edit query results when tables had alias.
  • Procedure parameters were missing in the scripts generated by Structure Synchronization.
  • Unknown Internal Error occurred when Automation ran.
  • Unable to transfer tables with HEX format.
  • Default parameter syntax was stripped after saving PostgreSQL function.
  • Syntax error occurred when creating PostgreSQL function with array parameters.
  • Encoding issue of the exported text file.
  • Unable to show the SQLite CTE based view definition in View Designer.

New in Navicat Premium Essentials 12.0.26 (Apr 26, 2018)

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

New in Navicat Premium Essentials 12.0.25 (Mar 28, 2018)

  • Bug Fixes:
  • Unable to create a query inside a group.
  • The color of function keywords did not change according to the Font Color settings in Options.
  • Column width did not retain after hide and show the column in Table Viewer.
  • Unable to drag and drop a query into a group in some cases.
  • "SQL Logic" error occurred when loading SQLite extension.
  • Unable to edit query results in some cases.
  • Unable to disable Foreign Key constraint in Data Synchronization.
  • Crashed when dumping table to sql file in some cases.
  • Foreign Key constraint didn't work when the constraint name was empty in SQLite.
  • DROP PROCEDURE statements in Structure Synchronization did not include the schema name.
  • Some setting values was missing in SQLite Trigger Designer.
  • Foreign Key constraint issue in Import Wizard.
  • Unable to show the SQLite CTE based view definition in View Designer.
  • SQLite connections was missing in Model's Import from Database feature.
  • Code completion replaced the text after caret.
  • Exported files or reports were not attached to the notification email.
  • Plugin error occurred when using RSA/PAM authentication for MariaDB connections.
  • Keepalive Interval setting attempted to connect continuously even the database was down.
  • If a query was opened, abnormal behavior happened when closing Navicat.
  • Automation did not start when the computer was logged out.
  • Unable to create new table with primary key settings in Import Wizard.

New in Navicat Premium Essentials 12.0.24 (Mar 27, 2018)

  • Improvements:
  • Supported creating PostgreSQL 10 Models.
  • Supported Microsoft Azure Database for MySQL.
  • Bug Fixes:
  • RAISE NOTICE events did not show in Message Log.
  • Spaces were missing in the SQL exported from Model.
  • Extra newlines were added to the SQL exported from Model.
  • Unable to change the comment of PostgreSQL functions with named parameters.
  • "Hourly" option was missing on Task Schedule's Trigger tab.
  • Wrong datestamp was appended to the exported files.
  • Added records showed wrong values until refreshing SQLite table grid.
  • Slow issue when searching in Table Viewer.
  • Unable to move functions into a group.
  • Syntax error occurred when running query in some cases.
  • Unable to select Enum data in query results.
  • "Unknown Internal Error" occurred when opening SQLite tables.
  • "Invalid byte sequence for encoding" error occurred when opening PostgreSQL tables.
  • Target functions/procedures were not dropped before create when synchronizing structure.
  • Unable to synchronize models/queries in Navicat Cloud.
  • Exported Excel files were corrupted in some cases.
  • "Access is denied" error occurred when setting schedule.

New in Navicat Premium Essentials 12.0.23 (Jan 22, 2018)

  • Bug Fixes:
  • Unknown Internal error occurred when editing/adding connections.
  • Adding self-referencing table issue in Query Builder.
  • Minor bug fixes and improvements.

New in Navicat Premium Essentials 12.0.21 (Jan 15, 2018)

  • Bug Fixes:
  • Out of memory issue when running Data Transfer.
  • Unable to add Identify column in existing SQL Server tables.
  • "Unknown Internal Error" occurred when loading profiles in Structure Synchronization.
  • Export Float data to csv files issue.
  • No scripts were deployed when synchronizing SQL Server functions.
  • Syntax error occurred when synchronizing MySQL functions.
  • Unable to display Oracle Chinese data in some cases.
  • Crashed when importing Excel or Text files in some cases.
  • Opening large databases in List View took long time.
  • Unable to show query files with ".SQL" extension in Objects tab.
  • The length of NVARCHAR fields were missing when exporting models to SQL files.
  • Errors occurred when executing MySQL Dump files.
  • CTRL+SPACE shortcut were missing in Query Editor.
  • Target's default Tablespace were not used in Data Transfer.
  • Unable to connect PostgreSQL 10 with scram-sha-265 Auth-Method.
  • Print report to PDF command wrongly sent the report to printer.
  • Null date values were exported wrongly as "1900-01-00" in Excel files.
  • Tables Viewer displayed wrong number of digits.
  • Input parameter window did not pop up when exporting query.
  • "Invalid Stored Procedure Syntax" error occurred when saving PostgreSQL functions.
  • High CPU usage issue.

New in Navicat Premium Essentials 12.0.20 (Jan 11, 2018)

  • Unable to sort by JSON type fields in Table Viewer.
  • Unable to connect SQL Server instances.
  • Unable to transfer POINT data type from MySQL to MariaDB.
  • Minor bug fixes and improvements.

New in Navicat Premium Essentials 12.0.19 (Dec 1, 2017)

  • Bug Fixes:
  • Unable to zoom in/out Query Editor using mouse wheel.
  • "operator does not exist" error occurred when editing JSON data.
  • "column c.reltriggers does not exist" error occurred when accessing PostgreSQL 10.1 tables.
  • Unable to connect Sphinx servers.
  • Swapping connections did not work when re-comparing in Data Synchronization.
  • Code Completion did not work when logged in with non DBA users.
  • Syntax errors occurred when running query in some cases.
  • Unknown Internal error occurred when performing Structure Synchronization.
  • No records was transferred when the target connection was using HTTP Tunnel.
  • Query syntax highlight was wrong after switching tabs.
  • DateTime field Not Null checkbox unchecked wrongly in Table Designer.
  • Unable to export table to xlsx with name longer than 31 characters.
  • Hanged when searching in Table Viewer in some cases.
  • Unable to open connection by double-clicking the SQLite database file.
  • "identity column" error occurred when importing to SQL Server.

New in Navicat Premium Essentials 12.0.18 (Nov 13, 2017)

  • Bug Fixes:
  • The database/schema combo-box did not work in Query.
  • Manual refresh did not work in Server Monitor when auto-refresh was enabled.
  • Oracle connection's Service Name setting reset after re-login Navicat Cloud.
  • Unknown Internal Error occurred when performing Structure Synchronization.

New in Navicat Premium Essentials 12.0.17 (Nov 13, 2017)

  • Bug Fixes:
  • Indexes were not displayed on the DDL panel when selecting PostgreSQL Materialized Views.
  • Supported refresh PostgreSQL Materialized Views with CONCURRENTLY option.
  • Fixed exporting numbers to Excel issue.
  • "column "start_value" does not exist" error occurred when accessing PostgreSQL 10 Sequences.
  • Fixed importing connections with Settings Location issue.
  • Fixed ER diagram layout issue.
  • Table groups were not synchronized to other members in Navicat Cloud.
  • Add Index statements were generated wrongly when opening Table Designer.
  • Unable to show errors when running queries in SQL Server.
  • Wrong SQLs were generated when inserting fields in Table Designer.
  • Unable to run CREATE PROCEDURE statements in Query Editor.
  • Unable to save function after changing parameter names.
  • Unable to import DBF files.
  • Identifiers panel retained when opening new query window.
  • Access denied error occurred when transferring tables with triggers in some cases.
  • The Stop button in Export Wizard did not work properly.
  • Unknown Internal Error occurred when typing in Query Editor

New in Navicat Premium Essentials 12.0.16 (Nov 13, 2017)

  • Bug Fixes:
  • Structure Synchronization detected differences wrongly in some cases.
  • Record delimiter was wrong when exporting to text file using Automation.
  • Breakpoints was not recognized in PostgreSQL Debugger.
  • Table Viewer moved back to the first page when refreshing a table.
  • Unable to dump Oracle tables to SQL files.
  • Unable to show synonyms in the Objects tab.
  • Characters displayed wrongly in Table Viewer.
  • Error occurred when adding fields in Oracle table.
  • Unable to select fields when exporting to Excel file.
  • Hanged when closing connection on less session environment.

New in Navicat Premium Essentials 12.0.15 (Sep 27, 2017)

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

New in Navicat Premium Essentials 12.0.14 (Sep 26, 2017)

  • Bug Fixes:
  • Wrongly shown differences when synchronizing structure.
  • Unable to debug PostgreSQL function in some cases.
  • The DDL tab in Information pane did not updated after saving changes in sub forms.
  • Unknown Internal Error occurred when synchronizing structure/data in some cases.
  • Unable to schedule Data Synchronization profiles.
  • Syntax error occurred when filtering with ' character in Table Viewer.
  • Compared table comments in Structure Synchronization.
  • Input decimal separator issue in Table Viewer.
  • Unable to import date from Excel to VARCHAR field.
  • Unable to create trigger functions in Query.
  • Query Builder loading was slow.
  • Custom backup file name was ignored when scheduling in Automation.
  • Re-registration issue.
  • Unable to create new table in Import Wizard in some cases.
  • Error occurred when creating virtual columns in MariaDB Table Designer.

New in Navicat Premium Essentials 12.0.13 (Sep 5, 2017)

  • Bug Fixes:
  • Table triggers was not included when backing up tables.
  • Auto increment field was ignored when importing
  • Unable to set the default value of TEXT/BLOB field for MariaDB 10.2.1 or above.
  • Navicat hanged when running a query export profile in some cases.
  • Error occurred when running LOAD DATA LOCAL queries.
  • Special characters were garbled when exporting Access files.
  • Unknown Internal error occurred when exporting Access files.
  • Unknown Internal error occurred when saving changes in Table Designer.
  • "Too many client tasks" error occurred when importing Access files.
  • Double-quote encased text fields were split into new records when importing a record which multiple lines.
  • Syntax error occurred when performing data transfer in some cases.
  • Unable to set automation for cross server type data transfer.
  • Unknown Internal error occurred when adding multiple records in Table Viewer.
  • Two identical functions declared as different in Structure Synchronization.

New in Navicat Premium Essentials 12.0.11 (Aug 8, 2017)

  • Bug Fixes:
  • Unable to open Information pane by context menu.
  • Unable to import fixed width text file in some cases.
  • Access Violation error occurred when creating models / tables in some cases.
  • Access Violation error occurred after Navicat was idle.
  • ORA-01861 error occurred when importing Excel files.
  • Unable to import the CDATA data in XML files.
  • Number values were exported as text in Excel files.
  • Code completion did not work for alias in SQL Editor.
  • Beautify SQL did not format multiple statements properly in SQL Editor.
  • Unknown Internal error occurred when running query with nvarchar(max) fields / parameters.
  • Table menu displayed wrong item in some cases.
  • Unknown Internal error occurred when running old version export profiles in Automation.
  • Unknown Internal error occurred when opening tables in some cases.
  • Wrong syntax displayed for PostgreSQL in Function Designer.
  • "_Navicat_Temp_Stored_Proc() does not exist" error occurred when saving functions.
  • High memory usage issue in Data Synchronization.
  • "Relation does not exist" error occurred when restoring from PostgreSQL backups.
  • "Use empty string as NULL" option did not work in Import Wizard.
  • Unknown Internal error occurred when writing query in some cases.
  • Unknown Internal error occurred when backup in Automation in some cases.
  • Incorrect date format dispalyed when editing SQL Server datetime fields.
  • Hang issue occurred when launching Import Wizard.
  • Unable to connect with SSL in some cases.

New in Navicat Premium Essentials 12.0.10 (Jul 14, 2017)

  • Bug Fixes:
  • Error occurred when opening MySQL databases in HTTP connection if enabled "Encode outgoing query with base64" setting.
  • Unable to import Chinese characters from Excel files.
  • Incorrect date and decimal formats in exported Excel files.
  • Filter criteria settings were removed when applying sorting on column.
  • Error occurred when duplicating MySQL tables in HTTP connection.
  • Unknown Internal Error occurred when executing old version export profiles in Batch Job.
  • Save dialog did not pop up when closing backup profiles after editing.
  • Incorrect SQL Server datetime displayed in Table Viewer.
  • Unknown Internal Error occurred when loading Filter profiles in Table Viewer.
  • Identity Error occurred when duplicating SQL Server tables.
  • File path and file name were not saved in Export profiles.
  • Unknown Internal Error occurred when there was multiple statements in Query.
  • Incorrect field names were shown in code completion suggestion list.
  • Unable to attach the report PDF file in notification email.

New in Navicat Premium Essentials 12.0.9 (Jun 29, 2017)

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

New in Navicat Premium Essentials 12.0.8 (Jun 26, 2017)

  • Bug Fixes:
  • Wrong table showed when comparing tables in Data Synchronization in some cases.
  • Unable to import special characters from Excel.
  • Unable to paste multiple records in Table Viewer.
  • Created Batch Jobs did not show in Standard Edition.
  • "Unknown Internal Error" occurred when importing files.
  • Unable to select data from SQLite views in Report.
  • View Builder locked up when re-open for editing in some cases.
  • Unable to log in Oracle server using lower case username.

New in Navicat Premium Essentials 12.0.7 (Jun 17, 2017)

  • Bug Fixes:
  • "Access violation" error occurred when create new query/view.
  • Enum value drop-down list was missing for MariaDB in Table Viewer.
  • Wrongly showed primary key warning in some cases.
  • Unable to type some characters in editor when using international keyboard.
  • Unable to edit connection settings in some cases.
  • Information Pane did not appear in some cases.
  • "Oracle Library not loaded" error occurred when connecting.
  • Internal error occurred when importing CSV files.
  • Error occurred when opening PostgreSQL tables with large INT values.
  • Cell values froze when scrolling in grid view.
  • PostgreSQL Function Designer showed wrong language setting.

New in Navicat Premium Essentials 12.0.6 (Jun 9, 2017)

  • 1142 error occurred when dumping SQL files for MySQL.
  • 1142 error occurred when backing up MySQL databases.
  • Unable to connect Azure SQL Database.
  • Failed to load Data Synchronization profiles.
  • Data display issues in table viewer.
  • Minor bug fixes and improvements.

New in Navicat Premium Essentials 12.0.5 (Jun 2, 2017)

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

New in Navicat Premium Essentials 11.2.16 (Mar 20, 2017)

  • Bug Fixes:
  • Fixed the CREATE PACKAGE and CREATE PACKAGE BODY issue in SQL Editor.
  • Error occurred when exporting with Time field type.
  • Error occurred when importing identity column in SQL Server.
  • Unable to insert trigger in Table Viewer.
  • Removed "WHEN()" if "When Clause" is NULL for Oracle trigger.
  • "Argument out of range" occurred when running "Reverse Database to Model".
  • Wrong Oracle SQL statements were generated wrong when running "Synchronize to Database" in Model.
  • Fixed the Oracle varchar2 issue when running "Synchronize to Database" in Model.
  • Minor bug fixes and improvements.

New in Navicat Premium Essentials 11.2.15 (Jan 11, 2017)

  • Bug Fixes:
  • Cannot to show PostgreSQL large decimal data properly in Table Viewer.
  • Minor bug fixes and improvements.

New in Navicat Premium Essentials 11.2.14 (Jan 11, 2017)

  • Bug Fixes:
  • Unable to show some errors in MySQL Console.
  • Crashed when using Query in some cases.
  • "IGNORE_DUP_KEY" was always set to "ON" for SQL Server in Structure Synchronization.
  • Query auto-save feature did not work in some cases.
  • Debugger did not work for PostgreSQL 8.3 to 9.0.

New in Navicat Premium Essentials 11.2.13 (Jan 11, 2017)

  • Bug Fixes:
  • Unable to move PostgreSQL function with special parameter to virtual group.
  • Error occurred when getting MySQL query status.
  • Minor bug fixes and improvements.

New in Navicat Premium Essentials 11.2.12 (Jan 11, 2017)

  • Bug Fixes:
  • Fixed the session break with identity insert SQL issue for SQL Server in Data Transfer.
  • MySQL floating point fields were exported to decimal values.
  • Error occurred when profiling query with sql_mode "ONLY_FULL_GROUP_BY" for MySQL 5.7.5 or above.
  • Fixed the sorting issue in Table Viewer.
  • Unable to select database and schema for SQL Server 2000 in "Find in Schema".
  • Error occurred when a PostgreSQL numeric field has scale out of -84 to 127 in Table Designer.

New in Navicat Premium Essentials 11.2.11 (Aug 10, 2016)

  • Improvements:
  • Support more keywords for PostgreSQL in Query Editor.
  • List PostgreSQL warning and notice messages in History Log.
  • Increase the number of databases that can be attached to a SQLite database.
  • Bug Fixes:
  • Copy and paste issue in Table Viewer's Memo Editor.
  • Unable to close PostgreSQL Debugger after clicking Cancel in the Parameter dialog box.
  • "Date format is too long for internal buffers" error occurred when viewing Oracle tables in some cases.

New in Navicat Premium Essentials 11.2.10 (Aug 10, 2016)

  • Improvements:
  • Support inputting tabs in the editor of Table Designer.
  • Support UTF16 formatted files in Execute SQL File and Query's Import SQL functions.
  • Support PostgreSQL 9.5 keywords in Query Editor.
  • Bug Fixes:
  • The media keys (play, pause, next etc) did not work.
  • Unable to connect MariaDB 5.5 with SSL.
  • Failed to transfer data in Chinese locale OS.
  • Foreign keys check SQL was missing at the end of the dumped SQL file.
  • Crashed when synchronizing model to database in some cases.
  • Unable to show the light coloring when the tab is non-active.

New in Navicat Premium Essentials 11.2.9 (Aug 10, 2016)

  • Bug Fixes:
  • The datetime field values were inconsistent in exported file.
  • Error occurred when adding PostgreSQL, Oracle, SQL Server and SQLite tables to report.

New in Navicat Premium Essentials 11.2.8 (Aug 10, 2016)

  • Improvements:
  • Support SQLite JSON1 extension.
  • Bug Fixes:
  • Wrongly enabled "UPDATE CURRENT_TIMESTAMP" for MariaDB DateTime fields when creating table.
  • Unable to set "On Update Current_Timestamp" setting in some cases for MySQL version 5.6.5 or above.
  • Unable to add tables to Report's Query Wizard and Query Designer when the table name contained dot.
  • Error occurred when logging in Navicat Cloud if profile path contained Unicode.

New in Navicat Premium Essentials 11.2.7 (Aug 10, 2016)

  • Bug Fixes:
  • Failed to get PostgreSQL or Oracle Materialized View information for Code Completion.
  • Fixed multi-monitor with different dpi issue.
  • Column import definition broken when importing.
  • Saved Import profile mapped columns wrongly.
  • "invalid varient operation" error occurred when import from ODBC.
  • "Argument out of range" error occurred when importing CSV file.
  • Primary Key settings were deleted when modifying import profile.

New in Navicat Premium Essentials 11.2.6 (Aug 10, 2016)

  • Improvements:
  • Support field type JSON in MySQL 5.7.8 or above.
  • Bug Fixes:
  • Errors occurred when running LOAD DATA LOCAL queries in 64-bit version.
  • Error "Diagram table already exists" occurred when opening some model files.
  • Crashed when exporting connections.
  • "Access violation" error occurred when importing CSV file.
  • Errors occurred when viewing PostgreSQL Object Information.
  • Normal users were unable to view PostgreSQL Object Information.

New in Navicat Premium Essentials 11.2.5 (Aug 10, 2016)

  • Bug Fixes:
  • "Stop" button was not working in Query.
  • Unable to edit the query in Query Editor when running it.
  • Error occurred when running LOAD DATA LOCAL queries.

New in Navicat Premium Essentials 11.2.4 (Dec 15, 2015)

  • Bug Fixes:
  • Schedule and Command Line stopped working when user did not sign in Navicat Cloud.
  • Minor bug fixes and improvements.

New in Navicat Premium Essentials 11.2.3 (Dec 15, 2015)

  • Bug Fixes:
  • "Argument out of range" error occurred when using "Find in Database/Schema".
  • Unable to open or design tables in PostgreSQL version 7.x and 8.x .
  • Minor bug fixes and improvements.

New in Navicat Premium Essentials 11.2.2 (Dec 15, 2015)

  • Major New Features:
  • Navicat Cloud Collaboration
  • Create/Modify/Delete projects.
  • Add members to project for sharing connection settings, queries and models.
  • View Project Activity Log.
  • PostgreSQL Objects
  • Support Foreign Server with User Mapping.
  • Support Foreign Table.
  • Support PostgreSQL Debugger.
  • Enhanced Object Designers.
  • Data Modeling Tool
  • Support Model Conversion.
  • Support Views.
  • Enhanced Table Designer.
  • Others
  • SQLite Users Management.
  • Enhanced Connection Coloring.
  • Search database object structure.

New in Navicat Premium Essentials 11.1.13 (Aug 5, 2015)

  • Improvements:
  • Supported PostgreSQL 9.5.
  • Enhanced Stored Procedure editor.
  • Bug Fixes:
  • Exported result incorrect for TIME field type in Export Wizard.
  • File name with appended timestamp issue in Export Wizard.
  • Wrong caption/icon showed for Stored Procedure.
  • Unable to synchronize BIT fields for PostgreSQL tables in Data Synchronization.
  • Slow performance when showing/hiding column with Memo editor opened.
  • SSH protocol error issue.

New in Navicat Premium Essentials 11.1.12 (May 21, 2015)

  • Bug Fixes:
  • Foreign keys were re-created when editing Oracle tables in Table Designer.
  • Generated object SQL identifier without escaping quote characters in Model.
  • Unable to load the virtual group settings file created by old versions of Navicat.
  • After sorted a selected column in Table Viewer, access violation occurred when resizing column width.

New in Navicat Premium Essentials 11.1.11 (Apr 28, 2015)

  • Improvements:
  • Reset the field length to default value after changing the auto guessed field type in Table Designer.
  • Bug Fixes:
  • Access violation error occurred when entering SQL in Query.
  • Cannot access field 'Super_priv' as type Boolean error occurred when managing MySQL/MariaDB Users.
  • Unable to download source files with HTTPS connection in Import Wizard.
  • Failed to create/edit users for MySQL 5.7.6.
  • 'Cannot create oci environment' error occurred in Oracle connections.

New in Navicat Premium Essentials 11.1.10 (Mar 14, 2015)

  • Improvements:
  • Improved the Message Log information.
  • Bug Fixes:
  • Table Designer did not allow to edit MySQL table partition’s Values setting.
  • Failed to generate PostgreSQL index field clause in Structure Synchronization.
  • Unable to drop columns for PostgreSQL View in View Designer.
  • Unable to identify equality of trigger definitions with different system line breaks in Structure Synchronization.
  • Code Completion did not parse SQL Server PIVOT SQL clause properly in Query Editor.
  • Unable to generate the SET clause properly for Oracle when using update mode in Import Wizard.
  • Unable to generate MySQL table SQL with charset binary properly in Structure Synchronization.
  • Code Completion added smart quote wrongly for utc_date() in Query Editor.
  • Unable to convert object names in Data Transfer when using Schedule.
  • Unable to transfer MariaDB triggers in Data Transfer.

New in Navicat Premium Essentials 11.1.9 (Jan 28, 2015)

  • Improvements:
  • Support "WITH" clause for SQLite 3.8.3.
  • Support double-click to open SQLite database file.
  • Bug Fixes:
  • Unable to run in Windows Server 2003.
  • Fixed the color issue in the connection tree.
  • Wrong handling for MySQL/MariaDB field type BIT.
  • Unable to show Material View in PostgreSQL/Oracle Query Builder.
  • Exception error occurred while running synchronize to database for SQLite tables with different number of source and target relations in Data Modeling Tool.

New in Navicat Premium Essentials 11.1.8 (Dec 9, 2014)

  • Improvements:
  • Allow copying field names in Table Viewer and Query's Result.
  • Bug Fixes:
  • "Argument out of range" error occurred after running MySQL/MariaDB queries in Query.
  • Unable to add new computed column to an existing SQL Server table which already have computed columns in Table Designer.
  • Crashed after multiple drag & drop tables in Model Designer.

New in Navicat Premium Essentials 11.1.7 (Dec 3, 2014)

  • Improvements:
  • Supported data type conversion between uuid and uniqueidentifier when changing database type between PostgreSQL and SQL Server.
  • Error counting in Data Transfer's Message Log changed from records to records and objects.
  • Bug Fixes:
  • Structure Synchronization was unable to compare the difference between Null and empty default value for MySQL/MariaDB fields.
  • Materialized View option was missing in the main menu (View > Others) for PostgreSQL.
  • Wrong table inheritance was shown in PostgreSQL Table Designer.
  • Failed to show DDL for PostgreSQL Trigger Function in Object Information.
  • Unable to show and edit data of regclass, etc PostgreSQL data types in Table Viewer.
  • DROP SEQUENCE SQL did not include 'IF EXISTS' clause for PostgreSQL 8.2 or above in Data Transfer.
  • 'Cannot create oci environment' error occurred in some machines.
  • Wrong field name was generated in ALTER SQL when changing default value of a renamed field in SQL Server Table Designer.
  • Navicat got hang after running certain SQLite SQL in Query.
  • Unable to select new mode in connection tree using Alt+MouseDown.
  • Access Violation error occurred when exporting single column to Word.
  • Duplicated foreign key names issue in Model.
  • Unable to recognize the Row Delimiter when importing from CSV files.
  • Import Wizard was unable to import currency data from DBF files.
  • Advanced settings were saved incorrectly in Data Transfer profiles.

New in Navicat Premium Essentials 11.1.6 (Sep 19, 2014)

  • Bug Fixes:
  • Synchronized Navicat Cloud model files even they did not have any changes.

New in Navicat Premium Essentials 11.1.5 (Sep 17, 2014)

  • Improvements:
  • Added Open Containing Folder feature for Query, Report, Backup and Model.
  • Added Open with External Editor feature for Query.
  • Added press and hold Alt key and double-click table to open Table Design.
  • Bug Fixes:
  • Failed to dump SQL file from Navicat Cloud connection.
  • Unable to select foreign key for new table in Table Design.
  • Export PostgreSQL query issue.

New in Navicat Premium Essentials 11.1.3 (Aug 26, 2014)

  • New Features:
  • Support to sync selected conntection settings, queries, model files and virtual group information to Navicat Cloud. For more information, please visit here.
  • Improvements:
  • Support PostgreSQL 9.3 Materialized View.
  • Support SQLite 3.8 WITHOUT ROWID.
  • Support parameter in Report command line.
  • Support adding shapes in Model.

New in Navicat Premium Essentials 11.0.18 (Aug 6, 2014)

  • Improvements:
  • Support JSON data type for PostgreSQL.
  • Query profile now support to show in server level.
  • Bug Fixes:
  • Fixed to set MYSQL_OPT_LOCAL_INFILE for MariaDB connection.
  • Database properties for SQL Server not able to alter proper compatibility levels.
  • Unable to save local file if database name contained heading/tailing space.
  • Crashed when loading and parsing a long incorrect syntax SQL in Query.
  • After adding a new row, pressing next/last button would freeze the Form View in Table Viewer.
  • Number of rows selected incorrectly when using shift+up/down keys in Table Viewer.
  • Multiple selection not working properly with shift+keys in Table Viewer.
  • When using CTRL+A to select text inside a data cell, all cells were incorrectly selected in Table Viewer.
  • Import Paradox not able to import data properly in Navicat 64bits.
  • ORA-00911: invalid character error occured when exporting Oracle query results.
  • Backup not able to backup MySQL table with foreign key.
  • Wrong NullsOrder setting was shown for foreign key fields under Table Designer in Data Modeling Tool.
  • Wrong CREATE TABLE SQL with character set and comment exported under Export SQL in Data Modeling Tool.

New in Navicat Premium Essentials 11.0.17 (Aug 6, 2014)

  • Improvements:
  • MySQL Table Viewer is now able to update a row even not all the keys are input for numeric columns.
  • Always import as NULL value if "Use empty string as NULL" option is checked in Import Wizard.
  • All records are now able to show under the Fixed Width window in step 3 of Import Wizard.
  • Bug Fixes:
  • 'Control 'Dock2Form_1' has no parent window' error occured while docking in and out of windows.
  • Connection was deleted after renamed to capitalized name.
  • Foreign key information with two words identifier not able to get correct correctly in MySQL/MariaDB Table Designer.
  • Foreign key information with NDB cluster storage engine not able to get correctly in MySQL Table Designer.
  • Parameter list not able to show in MySQL/MariaDB Function Designer when there was CHARACTER type in function parameters.
  • datetime2 value with fractional seconds not able to import using SQL Server Import Wizard.
  • Binary Data Encoding option was ignored in Oracle/SQL Server Import Wizard if string data type existed.
  • 'Table does not exist' error occured while opening an export profile.
  • DateTime with fractional precision not handling correctly in SQL Server Export Wizard.
  • Server with unsaved password not able to connect under 'Import from Database' in Data Modeling Tool.

New in Navicat Premium Essentials 11.0.16 (Jan 9, 2014)

  • Improvements:
  • Added Dynamic Column Editor for MariaDB in Table Viewer.
  • Bug Fixes:
  • Lose focus in Table Viewer.
  • Function parser error.
  • Access Violation error occurred when designing MariaDB tables with foreign keys.
  • Access Violation error occurred when importing invalid connections.
  • ERegistry Exception error occurred when starting Navicat.
  • Oracle reconnection problem.
  • Wrong Date Editor frame size in Table Viewer.
  • Stack Overflow error when running Query.
  • Data Synchronization failed when MySQL or MariaDB table has multi-fields Primary Key.
  • Permissions issue of the Updater.
  • Cursor was missing in Stored Procedure.
  • Failed to create MySQL user with special characters password.

New in Navicat Premium Essentials 11.0.11 (Nov 13, 2013)

  • Improvements:
  • Support of MariaDB 5.1 or above.
  • Bug Fixes:
  • Missed to mark quotation on keywords in Query Builder.
  • Process was unable to stop while running query in Essentials version.
  • Failed to include auto increment column setting for floating point data types in MySQL.
  • Access Violation occured when executing MySQL query clause with 'GROUP BY _xxx, _yyy'.
  • Failed to get the accurate fraction part of date time data for SQL Server.

New in Navicat Premium Essentials 11.0.10 (Sep 12, 2013)

  • Bug Fixes:
  • Failed to show definition/DDL for MySQL View.
  • Failed to check/uncheck column fields in Show/Hide Columns using space key in Tabler Viewer.
  • Failed to scroll horizontally for wide content after applying Filter Wizard in Table Viewer.
  • Fixed Oracle explain plan for SYSDBA user.
  • Fixed some issues on Query and Export features under Oracle level.
  • Failed to identify the correct installed SQL Server Native Client version.

New in Navicat Premium Essentials 11.0.9 (Aug 7, 2013)

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

New in Navicat Premium Essentials 11.0.8 (Aug 7, 2013)

  • Bug Fixes:
  • Fixed SQL Server timeout reconnect issue.
  • SQL Server PRINT message was not showed.
  • Column width not able to be reset after showing the hidden column in Table Viewer.
  • Access violation occured in Table Viewer while reconnecting SSH connection with another port.
  • MySQL default value could not be kept longer than 255 characters in Table Designer.
  • Query message in status bar not updated if no result return after Run.
  • Fixed concat string (with date) in MySQL Query.
  • Access violation occured when entering MySQL query clause with 'GROUP BY _xxx, _yyy'.
  • Minimum or Maximum value not saved in PostgreSQL Sequence Designer.
  • Fixed issues on cross transfer.
  • Certain SQL Server function not copies over in a Data Transfer profile.
  • Synchronize to database in Data Modeling Tool generated SQL Server column SQL with multiple identity columns.

New in Navicat Premium Essentials 11.0.7 (Jul 4, 2013)

  • Key was rejected for SSH connection.
  • Crashed occured while establishing PostgreSQL connection with SSL.
  • Access violation occured while running report in command line.
  • Losing searched position in Memo editor after first searching or clicked into the Memo editor.
  • Fixed query parser error.
  • Invalid relation cardinality not showed in red color in Data Modeling Tool.

New in Navicat Premium Essentials 11.0.6 (May 20, 2013)

  • Bug Fixes:
  • Fixed "Keyboard Interactive Failed" error for SSH tunnel connection.
  • Crashed while using SSH tunnel connection for both source and target servers in Data Transfer.
  • "Access violation" error occurred while entering query clause with 'ORDER BY _xxx ASC/DESC' in Query.
  • Notification email not sent with an unsaved batch job.
  • SQLite query result table not able to update while having zero and padding integer.

New in Navicat Premium Essentials 11.0.5 (May 20, 2013)

  • Native 64-bit version
  • Interface:
  • New User Interface
  • Aero Snap with new docking system
  • Connection:
  • New SSH Manager
  • Connection Tree Filter
  • Table Viewer:
  • Find and Replace data
  • Box Selection
  • Multi-Cell Editing
  • Search Columns
  • Web Viewer
  • Memo Editor with syntax highlight
  • Support Transaction
  • Support animated gif in Image viewer
  • Copy data as INSERT/UPDATE statement
  • Table Designer:
  • Search Columns
  • Field Type Prediction
  • Query:
  • Enhanced Query Builder
  • Import Wizard/Export Wizard:
  • JSON file
  • CSV file
  • Improved binary data handling
  • Backup/Restore:
  • SQL Server Backup
  • Oracle Data Pump
  • Report:
  • Enhanced PDF printing
  • Others:
  • New Registration and Activation System
  • New Updater

New in Navicat Premium Essentials 10.1.7 (Dec 11, 2012)

  • Improvements:
  • Support fractional seconds precision of time, datetime, timestamp data types for MySQL 5.6.4/MySQL MariaDB 5.3 or above.
  • Allow max SQL Server datatype (varchar, nvarchar, varbinary) in Data Synchronization.
  • The Profile tab under MySQL Query is now displayed without sorting.
  • Support MySQL date time format 2012-12-31T01:02:03.456 in Import Wizard.
  • Support fractional seconds precision of time, datetime, timestamp data types for MySQL 5.6.4 or above under Synchronize to Database function in Data Modeling Tool.
  • Support to ignore comparing MySQL DEFINER clause of view, event, trigger, procedure and function in Structure Synchronization.
  • Bug Fixes:
  • MySQL Create function statement which was after DELIMITER change statement was unable to be executed in Query.
  • "List index out of bounds" error occurred when some source fields were removed after import profile were created during Import Wizard.
  • Synchronize to Database function in Data Modeling Tool genarated incorrect comparison result for equivalent source and target foreign keys.
  • Synchronize to Database function in Data Modeling Tool failed to synchronize SQLite tables with changed fields.
  • Dump SQL File function produced inorrect SQL for Oracle CLOB fields.
  • When "Run multiple queries in each execution" option is checked for SQL Server, character data was unable to import correctly in Import Wizard.
  • Binary data (from MySQL, PostgreSQL, SQLite Server) from Access/ODBC was imported incorrectly during Import Wizard.
  • Records were unable to generate for MySQL Federated table in Dump SQL File and Data Transfer.

New in Navicat Premium Essentials 10.1.6 (Sep 24, 2012)

  • Improvements:
  • Added data format options for XML file in Export Wizard.
  • Bug Fixes:
  • Error message occurred while creating databases/tablespaces in PostgreSQL 9.2.x.
  • The dump of an Oracle table with CLOB produced an incorrect SQL statement.
  • SQLite Table Designer was unable to handle NOT NULL ON CONFLICT field property.
  • Wrong time unit (ms) was shown under Messages tab in Query function.
  • Table Designer in Data Modeling Tool was unable to save newly added index and foreign key.
  • Synchronize to Database function in Data Modeling Tool was unable to generate the referencing table schema name in the SQL scripts.
  • Server Monitor was unable to show the process for PostgreSQL 9.2.x server.

New in Navicat Premium Essentials 10.1.5 (Aug 23, 2012)

  • Bug Fixes:
  • "Execute SQL File" was unable to parse a SQL Server query if 'GO' characters contained in a word.
  • Empty named MySQL relation was unable to load back in Data Modeling Tool.
  • Unable to generate sync queries for MySQL fields with auto increment and primary key in Data Modeling Tool.
  • "Synchronize to Database" function in Data Modeling Tool was unable to generate SQL Server SCHEMA property in comment SQL.
  • Empty named relation was unable to load back in Data Modeling Tool.
  • "Access violation" error occurred while opening "Import from Database" form in Data Modeling Tool.

New in Navicat Premium Essentials 10.1.2 (Jul 20, 2012)

  • Improvements:
  • Added font selection in Option for ER Diagram.
  • Bug Fixes:
  • 1064 error occured when running MySQL Store Procedure.

New in Navicat Premium Essentials 10.1.1 (Jul 12, 2012)

  • If the table contained many columns, new column would be inserted to wrong position in Table Designer (Data Modeling Tool).
  • Error occured in Oracle, SQLite and SQL Server Filter Wizard when the filter criteria contain '.
  • SQL Server Stored Procedure only showed the final message after multiple PRINT statements.
  • Empty string was identified as Null in SQLite.
  • 'GRANT CREATE ....' not being run in Oracle Query.