Navicat Premium v12.1.24/12.1.26 Win/Mac 簡體中文/繁體中文/英文註冊版-數據庫管理工具

2019-10-11 Comments 0 Comment

Navicat Premium是一套數據庫管理工具，讓你以單一程序同時連接到MySQL、MariaDB、SQL Server、SQLite、Oracle和PostgreSQL數據庫。此外，它與Drizzle、OurDelta和Percona Server兼容，並支持Amazon RDS、Amazon Aurora、Amazon Redshift、SQL Azure、Oracle Cloud和Google Cloud等雲數據庫。

Navicat Premium v12.1.24/12.1.26 Win/Mac 簡體中文/繁體中文/英文註冊版-數據庫管理工具

結合了其他Navicat 成員的功能，Navicat Premium 支持大部份在現今數據庫管理系統中使用的功能，包括存儲過程、事件、觸發器、函數、視圖等。

Navicat Premium 能使你快速地在各種數據庫系統間傳輸數據，或傳輸到一份指定SQL 格式和編碼的純文本文件。計劃不同數據庫的批處理作業並在指定的時間運行。其他功能包括導入嚮導、導出嚮導、查詢創建工具、報表創建工具、數據同步、備份、工作計劃及更多。Navicat 的功能足以符合專業開發人員的所有需求，但是對數據庫服務器的新手來說又相當容易學習。

安全連接

Navicat 可以讓你通過SSH 通道創建安全的SSH 階段作業，確保兩台主機之間的連接受到強大驗證和安全加密的保護。驗證方式可使用密碼或公鑰和私鑰對。Navicat 亦支持HTTP 通道，讓你靈活地繞過限制直接數據庫服務器連接的互聯網服務供應商。

對象設計器

使用專業的對象設計器創建、修改和設計所有數據庫對象，例如：表、視圖、函數、過程、索引、觸發器和序列。無需編寫複雜的SQL 來創建和編輯對象，你會知道你正使用什麼選項。

網格或表單查看

使用網格查看添加、修改和刪除記錄。用類似數據表的功能瀏覽網格查看，例如排序和隱藏數據組，使用我們的助理編輯器：備註、十六進制、圖像或更多，你也可以用表單查看操作記錄。清楚顯示記錄的字段名和其值，不必擔心誤解數據。

外鍵數據選擇

在你的數據庫使用外鍵關係錨定參考的查找表，並自動建立下拉列表。無需持續對照參考主表，你可以簡化你的工作流程和提升效率。

SQL 創建工具

視覺化SQL 創建工具讓你創建和編輯查詢或視圖，而不必擔心語法和正確命令的用法。選擇你想在表中執行的操作，它會為你編寫SQL 語句。

自動完成代碼

使用我們的自動完成代碼功能，能快速地在SQL 編輯器中創建SQL 語句。無論你想選擇的是數據庫對象的屬性或SQL關鍵字，你只需從下拉列表中選擇。

逆向工程

使用Navicat 的逆向工程，你可以從一個現有的數據庫創建數據庫模型，可視化地顯現和編輯你的數據庫結構或創建一個圖形模型，並由模型生成一個數據庫。

正向工程和腳本生成

同步到數據庫功能給你充分了解所有數據庫的差異。生成必要的同步腳本來更新目標數據庫，並使其與模型相同。

導出SQL 讓你有機會全面控制最終的SQL 腳本，生成參照完整性規則，生成模型的獨立部份、註釋、字符集等。它可以節省你的工作時間。

導入或導出嚮導

從不同格式的文件導入數據到表，例如Access、Excel、XML、TXT、CSV、JSON 及更多。而且，在設置數據源連接後，你可以從ODBC 導入數據。只需簡單地選擇你要導入的表，或使用添加查詢按鈕指定查詢。同樣，你可以將數據導出到各種格式，如Excel、TXT、CSV、DBF、XML 等。

數據傳輸

在多個不同的數據庫系統間輕鬆地傳輸數據– MySQL、MariaDB、SQL Server、Oracle、PostgreSQL 和SQLite 數據庫。你可以選擇以指定的SQL 格式和編碼導出數據為SQL 文件。這個功能可大大的簡化遷移數據的進程。

數據或結構同步

從一個數據庫中以詳細的分析進程傳輸數據到另外一個數據庫。同樣，你可以比對並修改表的結構。在數據和結構同步中，目標數據庫可以在源服務器，也可以在其他的服務器。

備份或還原

定期備份數據庫對用戶是相當重要的。備份或還原全部表、記錄、視圖等。如果數據損壞，不用再重做，讓你能高枕無憂。

計劃

不同數據庫的設置文件可以創建在單一批處理作業，這樣你就可以設置計劃並在指定的時間運行。批處理作業可以創建的對象包括打印報表、數據庫備份、查詢、數據傳輸、數據同步、導入和導出。當任務完成後，Navicat 可自動傳送電子郵件通知給你指定的收件人。此外，導出的文件或打印的報表可以添加到批處理作業作為電子郵件附件，讓你可以輕易與其他人共享你的數據。

Oct 2 2019 Navicat Premium (Windows) version 12.1.24

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.

Sep 17 2019 Navicat Premium (Windows) version 12.1.23

Bug-fixes:Export process was slow.Error occurred when editing Stored Aggregate Functions.Unable to restore tables that included “pg_catalog”.”name” type.Unable to dump the default value of TIMESTAMP field.Synchronize to Database feature wrongly detected differences of unique constraints.Unable to show multiple values for list partitioning in PostgreSQL partition table.Minor bug fixes and improvements.

Aug 1 2019 Navicat Premium (Windows) version 12.1.22

Bug-fixes:Copy and paste data issue in Table Viewer.Minor bug fixes and improvements.

Jul 30 2019 Navicat Premium (Windows) version 12.1.21

Bug-fixes:Unable to list users for MariaDB 10.4.Code Completion did not work in some cases.Unable to import signed numbers when there was spaces between the sign and the number.A double quote was added to the JSONB column index (PostgreSQL).Unable to map a source field to multiple target fields in Import Wizard.DELIMITER statements did not work in Console.“Synchronize to Database” incorrectly detected differences for unique constraints (PostgreSQL).“Cannot open file” error occurred when scheduling export profiles in some cases.“IDENTITY_INSERT is already ON for table” error occurred when transferring tables (SQL Server).Unable to show empty fields in query result sets.Minor bug fixes and improvements.

Jun 10 2019 Navicat Premium (Windows) version 12.1.20

Bug-fixes:“syntax error at end of input” error occurred when running CREATE RULE statement in Query Editor.“Unknown Internal Error” occurred when opening Table Designer.“syntax error at or near “VERBOSE”” occurred when using Vacuum Analyze on PostgreSQL 11 tables.Minor bug fixes and improvements.

May 23 2019 Navicat Premium (Windows) version 12.1.19

Bug-fixes:Text editor did not display the full text in some cases.Data Synchronization inserted values into Generated Columns.Minor bug fixes and improvements.

Apr 17 2019 Navicat Premium (Windows) version 12.1.18

Bug-fixes: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.

Mar 21 2019 Navicat Premium (Windows) version 12.1.17

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.

Feb 26 2019 Navicat Premium (Windows) version 12.1.16

Bug-fixes:“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.

Feb 13 2019 Navicat Premium (Windows) version 12.1.15

Improvements:Add a “Drop with CASCADE” option for deleting PostgreSQL objects.Bug-fixes:Crashed when opening Oracle table with Spatial data.“Cannot add foreign key constraint” error occurred when importing Access file.Code completion box displayed off the bottom of the screen and partially obscured.Unable to customize query result tab name by using /*NAME:XYZ*/ .Hanged when executing script files in MongoDB server.Boolean or BIT(1) values importing, exporting and transferring issue.Copying table field names in Table Designer was slow.Table Form view was unable to show jpg images.Unable to import data when using Append/Update mode.Importing files to Oracle server was slow.Minor bug fixes and improvements.

Jan 10 2019 Navicat Premium (Windows) version 12.1.12

Bug-fixes:Error occurred when modifying a MongoDB view and auth was enabled.Unable to change variable’s value when debugging Oracle function.SQL order issue in Structure Synchronization.Console window was not colored when connection coloring were set.Unable to specify the minimum property when designing a collection in MongoDB.Unable to save PostgreSQL function in some cases.Minor bug fixes and improvements.

Nov 23 2018 Navicat Premium (Windows) version 12.1.10

Improvements:Added the “Include Owner” or “Include Definer” option in Data Transfer.Bug-fixes:Geometry field precision was lost when transferring MySQL/MariaDB tables.Field types and length did not show in PostgreSQL Table Designer when using HTTP tunnel connection.List index out of bounds error occurred when inserting data in Table Viewer.Unable to shrink the last column on the Process List tab in Server Monitor.Minor bug fixes and improvements.

官網下載地址： https://www.navicat.com/en/download/navicat-premium

官網更新記錄： https://www.navicat.com/en/products/navicat-premium-release-note