Navicat Premium 12.0.13 for Mac破解版 强大的数据库客户端. 、Oracle 和 PostgreSQL 等数据库,支持数据库建模,正向和反向工程,数据同步等功能,而 Premium 版本是包含了 Navicat 所有功能的最强大版本,是首选的数据库客户端工具之一。.
![]()
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 ANSIQUOTES SQL mode. Column order was incorrect when importing database to model.
Minor bug fixes and improvements.To upgrade, please visit our. Bug-fixes:.
Custom Filter was cleared when editing it. DBMS Output result was incomplete. HTML export did not specify charset. 'Show/Hide Columns' option was missing in Form View. The hidden Information pane was shown when switching from Form View to Grid View. Cursor focus issue in Form View. Code Completion did not work in some cases.
'Unterminated quoted string' error occurred when restoring backup in some cases. Link connection from Oracle to SQL Server failed in some cases. Minor bug fixes and improvements.To upgrade, please visit our. Improvements:. Supported to connect MySQL 8 using SHA2 connection.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.To upgrade, please visit our.
![]()
Improvements:. Updated SQLite library version to support more JSON functions.Bug Fixes:. Error occurred when synchronizing structure in some cases. Replace All did not work in Table Viewer.
'Unknown Internal Error' occurred when opening SQLite table. Cell selection disappeared after pressing CTRL+C in Table Viewer. Error occurred when running query in some cases.
'Unknown Internal Error' occurred when exporting query results. Unable to choose the custom object type in Table Designer.To upgrade, please visit our. 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.To upgrade, please visit our.
New Features:. 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.To upgrade, please visit our. 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 sqlmode 'ONLYFULL GROUPBY' 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.To upgrade, please visit our. 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.To upgrade, please visit our. 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.To upgrade, please visit our.
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 'Superpriv' 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.To upgrade, please visit our. 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.To upgrade, please visit our. 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.To upgrade, please visit our. 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. 'Access violation' error occurred while opening 'Import from Database' form in Data Modeling Tool.To upgrade, please visit our.
Improvement:. Enhanced MySQL Model transformation.Bug Fixes:.
'Access violation' error occurred when dragging n dropping a server node in connection tree together with the Model/Schedule object pane were opened. When created a virtual group in the connection tree, it would be added under Model/Schedule object pane while they were opened.
![]()
Failed to execute a SQL Server Stored function with some field types. 'Maintain'-'Vacuum Database.'
For PostgewSQL and SQLite server would randomly not shown in the connection tree.To upgrade, please visit our. New Feature:. Support of SQL Azure. Added Firewall Rules setting for SQL Azure. Added Bandwidth Usage in Connection Information for SQL Azure.Improvements:.
Improved sorting order in Connection Tree and Object list.Bug Fixes:. MySQL Table Designer was unable to handle field insertion. MySQL Table Designer was unable to insert a field as first since Navicat modifies the second field to reference the not yet inserted field. MySQL Table Designer now supports primary key fields ordering. Table Designer was unable to show/edit trigger definition.To upgrade, please visit our. Improvements:. Improved the compatibility of third party plugin (eg.
Bug Fixes:. SQLite Table Viewer treated e.g. '2010-12-14' as number format instead of text format. Limit Records feature did not work in SQL Server Table Viewer. When altered procedure, SQL would be missing a dot between schema name and object name during Structure Synchronization in SQL Server. DBF character field length would be set to 254 if table field length is 0 while exporting to DBF file. Tree node was unable to be highlighted when Connection Coloring feature was applied under Windows XP.To upgrade, please visit our.
Bug Fixes:. '700 - Invalid response: 403' error occured when using HTTP tunnel connection for MySQL, PostgreSQL and SQLite server. Index/Trigger was unable to be renamed in SQLite Table Designer. SQLite Foreign Key did not work properly.
'Out of memory' error occured when running a long SQL in Query function. 'Access violation' error occurred when running an invalid SQL syntax in Query function e.g. SELECT DBMSOBFUSCATIONTOOLKIT.MD5 (inputstring='1') FROM DUAL. Result form showed in Query Editor would be closed after a new query was run. Beautify SQL returned an invalid SQL syntax, e.g. Formatted xxx@yyy into xxx @ yyy. 'Cannot call Start on a running or suspended thread' error occured when exporting tables with mutli resultsets.
SQLite 'Check For Updates' did not work properly.Upgrade Procedure. Improvements:. Allow to save Function in Oracle Procedure/Function Designer if user selected Procedure in first step of Function WizardBug Fixes:. SQLite Table Designer did not allow to create data type TEXT, BLOB, REAL, etc with length, precision and scale.
SQLite indexes were unable to be removed in Table Designer. When pasting an enum type value using CTRL+V in Tabler Viewer, the drop down list box would be shown in wrong position. 'Access violation' error occurred when running an invalid SQL syntax in Query Builder, e.g. From,table01. Imported string data as blob data incorrectly to MySQL, PostgreSQL and SQLite database using Import Wizard. Failed to import characters data as NVARCHAR2, NCHAR, CLOB, NCLOB to Oracle server using Import Wizard. 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. Error occurred for Oracle and PostgreSQL server when primary key constraint name in source table conflicted with the unique index which was created as the same name as the primary key in Structure Synchronization. Field names for some tables with special names were unable to be listed in Report Builder.Upgrade Procedure. Improvements:. Structure Synchronization will now not compare MySQL table comment.Bug Fixes:.
Auto-reconnection did not work on SSH tunnel connection to MySQL server. Fixed the unicode display problem on Text field with MySQL 4.0 or below. Beautify SQL would cause error if extra spaces existed in aggregate function. Fixed error when importig XML files from the Interent. When exported data to Excel spreadsheet, string start with zero (e.g. 009123) would be changed to integer (9123).
'Access Violation' error occured in Manage User when MySQL user did not have enough privilege. 'Ask to save new queries' in Options would be reset to unchecked after Navicat restarted.Upgrade Procedure. Improvements:. Support encrypted SQLite file (wxSQLite3). Improved smart quote identifier for SQLite.
Improved virtual grouping rename issue - e.g. Improvements:. Added Java and XML syntax highlighting for Oracle.
Support Cancel action in copying SQLite objects, table and query.Bug Fixes:. When unchecked MySQL 'Include other table options' in Data Transfer, engine/table type, character set, auto increment settings were not transferred properly. The font size used in Query grid was smaller than in View grid. 'Set Display Format' option in Table Viewer did not work in numerical field.
Fixed the wrong positioning issue of main menu items. MySQL character set/collation type issue in Query Builder or View Builder.Upgrade Procedure. Improvements:. Better handle case sensitive of object identifier for Query Builder. Support 'select. Improvements:. If length does not specify for MySQL char/varchar, 255 value will now be assigned when saving a table.Bug Fixes:.
When using MySQL HTTP Tunnel connection and user tried to add/duplicate an user. Improvements:. In step 6 of Import Wizard, Source field name would be truncated if longer than 255 characters. Now, Navicat supports up to 5000 field name characters.Bug Fixes:. MySQL Auto increment value could not be altered if 'Use DDL from SHOW CREATE TABLE' option was disabled with 'Include Auto Increment' option being checked in Data Transfer.
Refresh did not work for getting update data. When import text-based file using Import Wizard, Navicat was unable to get the number of columns correctly if the file did not contain field name row or there were empty lines existed before first data row.Upgrade Procedure. Improvements:. 'Exceed package size.' Error will now occur to remind you to enlarge the maxallowedpacket variable if the records larger than the maximum packet size setting when running Data Synchronisation for MySQl server.
Report Builder now accepts datetime function for MySQL server. PostgreSQL 'bytea' data type will now being exported as E'.' In text-base file.Bug Fixes:. 'Property cannot be found' error occured when importing Access file with datatype that may involve decimal places info, e.g.currecy, number, floating point value. BLOB data in text file was unable to import successfully for MySQL and PostgreSQL servers.
SQL statements exported from Export Wizard was exported incorrectly. When added a new field (without labelling its name) in MySQL server usng Table Designer, then click the Move Up button. The last field in the table would be disappeared.
'List index out of bound' error occured when using an account, which did not have enough privileges, to open MySQL Stored Procedure/Function. Crashed when running 'SELECT ctid FROM table' in PostgreSQL server. 'Access Violation' error occured when exporting data to Access file if using HTTP Tunnel connection.Upgrade Procedure. Enhancement:.
Support of UUID for PostgreSQL server 8.3 or above.Bug Fixes:. 'SSH Tunnel:'is not a valid integer value' error occured during SSH connection. When exported data to MS Access, month and day values were mixed up. Slow problem while transfering data from command line.
'permission denied for relation pgauthid' error occured when creating table for ProgreSQL server. Access Violation error happened when creating new table with index. Fixed SQL parsing problem for Oracle version.
Index, constraint and trigger could not be renamed in Table Designer.Upgrade Procedure. Enhancement:. Improved connection alive issue for MySQL server.Bug Fixes:. When ran 'LOAD DATA LOCAL FILE' in Query Editor to import data to MySQL database, Access violation error occured. If table names stated with number e.g.
1Table, those tables were not displayed on the Query Builder. when using Find (ctrl+f) in Form View, it would jump out of Form View into Grid View. When applied docking feature under Windows 7, 'System Error. The parameter is incorrect' occured. Fixed 'Select' statement with empty string in Query Editor resulted in Access violation.Upgrade Procedure. Main features:Multi-connections Database Administration tool:Navicat Premium allows you to perform multiple server administration to MySQL, Oracle and PostgreSQL databases from a single interface.
Bug-fixes:. Empty tables were created when importing.accdb file. Run Selected option did not run all highlighted text when using shortcut to select the SQL. SSH connection dropped issue.
Unable to retain selected columns in Foreign Key Selection window. PostgreSQL SCRAM authentication did not work properly.
Data Synchronization data grid UI issue in Dark Mode. Data Synchronization inserted values into Generated Columns. Minor bug fixes and improvements.To upgrade, please visit our.
Bug-fixes:. Unable to connect MongoDB in some cases. COMMAND-N new object shortcut did not work. Not Null checkbox state was wrong in Table Designer.
Crashed when creating new connection in some cases. Import Target and Field Mapping changed after changing the source file in profile. Crashed when deleting fields in PostgreSQL. Syntax error occurred when transferring MySQL ARCHIVE engine tables. Error occurred when editing SQL Server data. Crashed when closing window in some cases.
Minor bug fixes and improvements.To upgrade, please visit our. Bug Fixes:. Incorrect SQL 'ON UPDATE CURRENTTIMESTAMP(0)' was dumped for MariaDB 5.5 tables. Crashed when starting Navicat. Unable to edit query results when tables had alias. Exported files were not attached to the notification email.
Procedure Parameters was missing when synchronizing structure. Unable to filter connections in the Navigation Pane. Error occurred when importing data to TIMESTAMP(6) fields. Profile icons did not have indicator after adding attachments in Batch Job.To upgrade, please visit our. Bug Fixes:. Result tab was focused when explaining query. Query Plan result column was too narrow in Query.
't' character was appended to the end of the row when copying data to text / Excel file. Unable to map fields in Import Wizard.
Dump SQL File process was slow. Create new table wrongly when importing to existing table in some cases. Use old user to connect after changing new user name in Connection window. Unable to import decimal values when data has thousand separator. Crashed when searching on different pages in Table Viewer.To upgrade, please visit our.
Bug Fixes:. Auto increment field was ignored when importing. Unable to set the default value of TEXT/BLOB field for MariaDB 10.2.1 or above. Error occurred when connecting to MariaDB in some cases. System items were shown in the Import from Database window.
Navicat hanged when running a query export profile in some cases. Window was resized when clicking the Triggers tab in PostgreSQL Table Designer. Crashed when viewing or editing Functions.
Code completion displayed unrelated items.To upgrade, please visit our. Bug Fixes:. Replace All did not work in Table Viewer.
Wrong row was inserted to when selecting foreign key value in Table Viewer. Memory error occurred when transferring tables.
Suggested wrong table column in code completion list. Context menu UI issue in some cases. Tables displayed as NEW in Import Wizard even it is already existed. Slow issue occurred when using code completion. Server name was missing in the window title bar of Console. Unable to add tables/views to Query Builder.
Crashed when opening SQLite connection in some cases.To upgrade, please visit our. Crashed when exporting query result in some cases. Unable to show time values in Timestamp fields in Table Viewer.
Error occurred when executing SQL Server procedure in some cases. Field names were not shown for SQLite in Query Builder.
Lost focus when inputting auto increment value in Table Designer. Incorrect values displayed in MySQL 'Data Length' column in Detail View. Table list was not sorted in Export Wizard. Backup object list in the Objects tab was not refreshed after finishing backup. Progress bar did not update when importing.To upgrade, please visit our. Bug Fixes:. Fixed displaying object list slow issue.
Fixed selecting user slow issue. Fixed the query builder window resize issue. Unable to show users in the Objects tab in some cases.
Foreign key's Source Fields list was empty in Table Viewer. 'Invalid default value' error occurred when transferring MySQL data. The Identifiers list in Query Editor did not show items. 'Data Length' displayed in Bytes in Detail view. 'Name' column width was too narrow in Detail view.To upgrade, please visit our.
New Features:. 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.To upgrade, please visit our. Bug Fixes:. Fixed the column order issue when using Copy As Insert/Update in Table Viewer.
Navicat got hang when editing PostgreSQL UUID fields in Table Viewer. Crashed when inserting a row for PostgreSQL in Table Viewer. Unable to insert empty string to fields with date time types if import date is empty since MySQL 5.7. Failed to close the parameter window after opening in Function Designer. App Store Essentials version: Failed to keep the 'Show Object List' state in Query.To upgrade, please visit our. Bug Fixes:. Crashed when opening SQL Server Role Designer.
Unable to load tnsnames.ora file. Unable to save the 'Show Object List' option in Query.
There was no syntax highlight in the SQL Preview tab. Unable to show the cursor in Query Editor with black background. Failed to drag and drop connection in some cases. Smart quote issue in Query Editor. Font issue in Query Editor. Find feature issue in Query Editor. Unable to copy more than 30 rows in Table/Query Viewer.To upgrade, please visit our.
Bug Fixes:. Pop-up options of selected cell were missing in Table Viewer.
Objects tab was not selected when clicking an item in the Connection pane. Unable to resize the width of main window as Version 11.1.
'Rolcatupdate' error occurred while accessing Roles in PostgreSQL 9.5. All field names were placed on the same line after applying Beautify SQL.
Unable to show the column list of 'Show/Hide Columns' in Table Viewer on Mac OS X 10.10. CMD+F shortcut did not work in the main window on Mac OSX 10.11. It was slow when running PostgreSQL queries.To upgrade, please visit our. 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 Filter Wizard.
Enhanced Query Designer.To upgrade, please visit our. Bug Fixes:. Incorrect schema name for CREATE INDEX or TRIGGER SQL for PostgreSQL in Structure Synchronization. Crashed when getting table constraints due to extra constraints created by PostgreSQL extension earthdistance. Showed wrong database in Connection Tree.
Execute SQL file did not output errors in some cases. Lost local connections after Navicat crashed during synchronizing to Navicat Cloud. App Store version: In-App Purchase did not work in Mac OS X 10.11.To upgrade, please visit our. Bug Fixes:. Unable to edit BLOB field's text data on TEXT editor. Error occurred when opening SQL Server 2005 and SQL Azure connections. Unable to use CMD-Y New Query shortcut after selecting Tables, Views, etc nodes on Connection Tree.wal and.shm files were not deleted after closed SQLite connections.
Failed to create/edit users for MySQL 5.7.6. Failed to run schedule for connections in Navicat Cloud. Cursor did not focus on Query Editor when opening a query.To upgrade, please visit our. Bug Fixes:. Fixed the escape character data issue for PostgreSQL tables in Data Transfer.
Unable to insert/update/delete money type in Table Viewer and Data Transfer for SQL Server 2000. Wrongly showed MySQL/MariaDB TEXT fields with collation xxxbin as BLOB fields in Table Viewer. Fixed import DBF file with empty datetime value issue. Crashed when typing 'create function test (in' in Query Editor. Error occurred when opening SQL Server 2008 R2 schemas. Error occurred when opening SQLite files with the same name by double-clicking the database files.To upgrade, please visit our. Improvements:.
Added the ability to copy column name with data and copy records as Insert/Update statements in Query/View Result.Bug Fixes:. App Store Essentials version: Fixed unable to copy query by drag-and-drop method. Fixed the SQL Azure connection hang issue. Fixed the time interval setting issue in Schedule.
Fixed the multi headers issue when exporting multi SELECT query to XML file. Fixed the warning issue when renaming query. Fixed unable to handle delimiter statements issue in Execute SQL File.To upgrade, please visit our. Bug Fixes:. Unable to execute Data Transfer profiles in Batch Job. Navicat Cloud login checking restriction. The Select/Where/Group By/Having/Order By clasue bar disappeared in Query/View Builder.
Crashed when saving profiles. Failed to import date time field and float number from DBF files. Select fields panel in Table Designer did not update after the table was saved.
INT type values were rounded up when importing XLS files. Table Designer view was not displayed corrently in HTTP connections.To upgrade, please visit our. Improvements:. Customized column width and column order in Table Design are saved.Bug Fixes:. Failed to run Backup Server jobs for cloud connections in Schedule.
PostgreSQL JSON type data was unable to show in Table Text Editor. Generated wrong query for field name with '.' In Filter Wizard. Crashed when removing connection from a virtual group. Unable to save the Word Wrap setting in Table Text Editor. Crashed when creating a new virtual group in fresh installed Navicat.
Connection list did not refresh automatically after dragging connections between Navicat Cloud and My Connections.To upgrade, please visit our. Improvements:. Added Show in Finder feature for Query, Backup and Model.
Added Open with External Editor feature for Query.Bug Fixes:. Press CMD-F again did not highlight the text of the search field in Table Viewer. Wrong formatter of Oracle date in Import. Crash when control-click a database in connection tree on OS X 10.9 below in Essentials version. Failed to save SSH password for Navicat Cloud connection. Unable to close Navicat with CMD-Q when opened more than one tabbed windows.
Unable to perform data synchronization for SQLite databases.To upgrade, please visit our. Improvements:. Compatible with Mac OS X 10.9 Mavericks.Bug Fixes:. Crashed on tabbed window. Failed to import JSON file. App Store version: Error on export path during Export Wizard in Mac OS X 10.9.
Wrongly displayed for the time fraction part of datetime type in SQL Server Table Viewer. Crashed when paring 'DECLARE myCursor CURSOR FOR' in SQL Server Query Viewer. SQL Server fields did not compare in Structure Synchronization. Crashed when opened a linked SQL Server and removed it in main window. App Store version: Failed to open SQLite database file.To upgrade, please visit our. Improvements:. Support of SQLite loadextension by setting sqliteLoadExtension boolean to YES in plist file.
Suppport larger row limit for xlsx version, 1048576 rows in Export Wizard.Bug Fixes:. No popup error showed in Table Viewer. Failed to find the next match in Find Next action after selecting a cell in Table Viewer. Crash occured in Query Editor. Fixed the MySQL auto increment value while altering table in Structure Synchronization. Duplicated quote occired in PostgreSQL Stored Procedure parameter name.To upgrade, please visit our.
Major New Features:Native 64-bit versionInterface. New User Interface.
New docking systemConnection. New SSH Manager. Connection Tree FilterTable Viewer. Find and Replace data. Search Columns. Support TransactionTable Designer.
Search Columns. Field Type PredictionQuery. Support showing multiple resultsImport Wizard. JSON file.
Excel file 2007 (.xlsx,.xlsm). MS Acess database (.mdb,.accdb)Export Wizard. JSON file. Excel file 2007 (.xlsx)Backup/Restore. SQL Server Backup. Oracle Data PumpOthers.
New Registration and Activation System. New UpdaterTo upgrade, please visit our. Improvements:. Increased the limit of number of joins allowed in Query Builder.
Improved the working area on Query Builder.Bug Fixes:. Fixed the error when running Explain plan for Oracle 9i. Fixed the error when importing LOB field in Import Wizard.
Fixed a crash issue when re-running a query in Query Viewer. Fixed the failure of sending email in Schedule. Fixed the bug of disabled definition box in PostgreSQL function. Fixed the bug on running functions in PostgreSQL function window.To upgrade, please visit our. Improvements:.
Embedded Oracle Full Client instead of Light Client. Update the SQLite version to 3.7.10.Bug Fixes:. Fixed the failure of printing PDF in Model Designer.
Fixed the bug of DISTINCT clause disappeared in Query Editor after using Query Builder. Fixed the slow response issue when opening Execute SQL File window. Fixed a crash issue when using Beautify SQL. Fixed the crash issue when quitting MySQL/PostgreSQL/Oracle/SQL Server process in Server Monitor.To upgrade, please visit our. Improvements:.
Added hidden option to disable transaction in Stored Procedure in MySQL connection.Bug Fixes:. Fixed Data Transfer encoding issue when MySQL charset was disabled. Fixed the bug on the comparison of MySQL field character set. Fixed the refresh problem after reordered the fields in ER diagram view. Fixed the reload time issue after saving table.
Fixed the wrong listing for target tables in SQL Server Data Synchronization. Fixed the bug occurred when selecting weekday in Schedule setup panel.To upgrade, please visit our.
Improvements:. SQLite library is updated to version 3.7.6.3. Improved the situation of losing connection in MySQL connection.Bug Fixes:. Fixed the occasionally hang problem in Query Builder. Fixed the problem of failing to run Data Synchronization batch job.
Fixed the problem of improperly quoted index expressions in Backup and Table Designer. Fixed the problem of occasionally displaying blank cell in Table Viewer. Fixed the problem of continuously adding row when pressing Down Arrow button in Table Viewer.To upgrade, please visit our. Major New Features:. Support of Microsoft SQL Server (2000 to 2008R2). Support of MySQL Server 5.5. Support of PostgreSQL Server 9.
Connection to SQL Server through SSH. Support Keep Connection Alive for Oracle and SQL Server. Support of geometry data type for MySQL and SQL Server.
Support BTREE and HASH index methods for MySQL Server. Support of UUID/GUID generator for PostgreSQL/SQL Server. Support of SQL Server Code Outline. New Privilege Manager.
Enhanced User/Role Management. Data Synchronization performance improved with new engine.To upgrade, please visit our. Improvements:. Connection name is now shown in the title bar of Console window. Oracle keyword 'elsif' can now be recognized.Bug Fixes:.
Query results were unable to be edited under MySQL HTTP Tunnel connection. Failed to display MySQL unsigned bigint values properly. The referencing database of MySQL/PostgreSQL foreign keys were not properly transferred to files. If the decimal symbol was not set as period (.), incorrect decimal values may be imported for excel files.Upgrade Procedure. Main features:Multi-connections Database Administration tool:Navicat Premium allows you to perform multiple server administration to MySQL, Oracle and PostgreSQL databases from a single interface.
Improvements:. Added 'Keep Orthogonal Layout' to Model.Bug-fixes:.
The Code Snippet pane status was not retained when opening new window. 'Stored Type' column was empty in Function object list. 'Table Type' column was empty in Table object list. Opening query with External Editor did not use the selected editor.
Customizing Date Delimiter did not work when exporting files. Unable to create new query by shortcut CTRL+Q in some cases.
Minor bug fixes and improvements.To upgrade, please visit our. 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 ANSIQUOTES SQL mode. Column order was incorrect when importing database to model. Minor bug fixes and improvements.To upgrade, please visit our. Bug-fixes:.
Custom Filter was cleared when editing it. DBMS Output result was incomplete.
HTML export did not specify charset. 'Show/Hide Columns' option was missing in Form View. The hidden Information pane was shown when switching from Form View to Grid View. Cursor focus issue in Form View.
Code Completion did not work in some cases. 'Unterminated quoted string' error occurred when restoring backup in some cases. Link connection from Oracle to SQL Server failed in some cases.
Minor bug fixes and improvements.To upgrade, please visit our. Improvements:. Updated SQLite library version to support more JSON functions.Bug Fixes:. Error occurred when synchronizing structure in some cases. Replace All did not work in Table Viewer. 'Unknown Internal Error' occurred when opening SQLite table.
Cell selection disappeared after pressing CTRL+C in Table Viewer. Error occurred when running query in some cases. 'Unknown Internal Error' occurred when exporting query results. Unable to choose the custom object type in Table Designer.To upgrade, please visit our.
New Features:. 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.To upgrade, please visit our. Bug Fixes:. Fixed the CREATE PACKAGE and CREATE PACKAGE BODY issue in SQL Editor.
Error occurred when exporting with Time field type. 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.To upgrade, please visit our.
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.To upgrade, please visit our. 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. Error occurred when exporting connections. Error occurred when saving profiles.To upgrade, please visit our.
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.To upgrade, please visit our. 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 'Superpriv' 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.To upgrade, please visit our.
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.To upgrade, please visit our. 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.To upgrade, please visit our. 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.
'Access violation' error occurred while opening 'Import from Database' form in Data Modeling Tool.To upgrade, please visit our. Improvement:. Enhanced MySQL Model transformation.Bug Fixes:. 'Access violation' error occurred when dragging n dropping a server node in connection tree together with the Model/Schedule object pane were opened. When created a virtual group in the connection tree, it would be added under Model/Schedule object pane while they were opened. Failed to execute a SQL Server Stored function with some field types. 'Maintain'-'Vacuum Database.'
For PostgewSQL and SQLite server would randomly not shown in the connection tree.To upgrade, please visit our. Improvements:. Added Ctrl+a as shortcut key for 'select all' in Form View.Bug Fixes:.
'./startnavicat: 10: arithmetic expression: expecting EOF: '2.100+13 2' error would occur when starting up Navicat. Wrong table would be copied while running 'Duplicate Table' function.
MySQL Object Information was unable to be refreshed when under 'List' view mode. Foreign Key Check box under Table Designer was unable to be toggled using space bar. Searching in Table Viewer would freeze when no record showed on the existing view.To upgrade, please visit our. Bug Fixes:. '700 - Invalid response: 403' error occured when using HTTP tunnel connection for MySQL, PostgreSQL and SQLite server. Index/Trigger was unable to be renamed in SQLite Table Designer.
SQLite Foreign Key did not work properly. 'Out of memory' error occured when running a long SQL in Query function. 'Access violation' error occurred when running an invalid SQL syntax in Query function e.g. SELECT DBMSOBFUSCATIONTOOLKIT.MD5 (inputstring='1') FROM DUAL. Result form showed in Query Editor would be closed after a new query was run.
Beautify SQL returned an invalid SQL syntax, e.g. Formatted xxx@yyy into xxx @ yyy. 'Cannot call Start on a running or suspended thread' error occured when exporting tables with mutli resultsets. SQLite 'Check For Updates' did not work properly.Upgrade Procedure.
Improvements:. Allow to save Function in Oracle Procedure/Function Designer if user selected Procedure in first step of Function WizardBug Fixes:. SQLite Table Designer did not allow to create data type TEXT, BLOB, REAL, etc with length, precision and scale. SQLite indexes were unable to be removed in Table Designer. When pasting an enum type value using CTRL+V in Tabler Viewer, the drop down list box would be shown in wrong position. 'Access violation' error occurred when running an invalid SQL syntax in Query Builder, e.g. From,table01.
Imported string data as blob data incorrectly to MySQL, PostgreSQL and SQLite database using Import Wizard. Failed to import characters data as NVARCHAR2, NCHAR, CLOB, NCLOB to Oracle server using Import Wizard. 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. Error occurred for Oracle and PostgreSQL server when primary key constraint name in source table conflicted with the unique index which was created as the same name as the primary key in Structure Synchronization.Upgrade Procedure. Improvements:.
Horizontal scrollbar is now reset to the left position after applying Beautify SQL feature.Bug Fixes:. SQLite index/trigger was unable to be removed from the Navicat main window. 'Access violation' error sometimes occurred when running an invalid syntax in Query Editor. Data Transfer profiles were unable to be opened for PostgreSQL server. 'Error in updating task' error occurred when saving a scheduled task. Error occurred when schedule name and path contained unicode string.Upgrade Procedure.
Improvements:. libcurl.dll library updated.
Structure Synchronization will now not compare MySQL table comment.Bug Fixes:. Auto-reconnection did not work on SSH tunnel connection to MySQL server. Fixed the unicode display problem on Text field with MySQL 4.0 or below.
Beautify SQL would cause error if extra spaces existed in aggregate function. Fixed error when importig XML files from the Interent. When exported data to Excel spreadsheet, string start with zero (e.g. 009123) would be changed to integer (9123).
'Access Violation' error occured in Manage User when MySQL user did not have enough privilege. 'Ask to save new queries' in Options would be reset to unchecked after Navicat restarted.Upgrade Procedure.
Improvements:. If length does not specify for MySQL char/varchar, 255 value will now be assigned when saving a table.Bug Fixes:. Connection Name in Connection Properties sometime would show empty value. When using MySQL HTTP Tunnel connection and user tried to add/duplicate an user.
Improvements:. In step 6 of Import Wizard, Source field name would be truncated if longer than 255 characters. Improvements:.
'Exceed package size.' Error will now occur to remind you to enlarge the maxallowedpacket variable if the records larger than the maximum packet size setting when running Data Synchronisation for MySQl server. PostgreSQL 'bytea' data type will now being exported as E'.' In text-base file.Bug Fixes:. 'Property cannot be found' error occured when importing Access file with datatype that may involve decimal places info, e.g.currecy, number, floating point value.
BLOB data in text file was unable to import successfully for MySQL and PostgreSQLservers. SQL statements exported from Export Wizard was exported incorrectly. When added a new field (without labelling its name) in MySQL server usng Table Designer, then click the Move Up button.
The last field in the table would be disappeared. 'List index out of bound' error occured when using an account, which did not have enough privileges, to open MySQL Stored Procedure/Function. Crashed when running 'SELECT ctid FROM table' in PostgreSQL server.
'Access Violation' error occured when exporting data to Access file if using HTTP Tunnel connection.Upgrade Procedure. Improvements:.
The Data Synchronization message log will not show server name rather than Host/IP.Bug Fixes:. When applied comma as decimal seperator, Data Synchronization would cause problem for MySQL and PostgreSQL server. Date field was not converted correctly when exported to DBF file. An empty field would be displayed if employed EUCJP as database encoding in PostgreSQL server.
Undo (Ctrl + z) function did not work properly on memo editor in Table Viewer. Email attachment in Schedule could not be sent if 'Add timestamp' option was enabled in Export Wizard.Upgrade Procedure.
![]() Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
January 2023
Categories |