Navicat Premium v​​12.1.9 / 12.1.10 Win / Mac簡體中文/繁體中文/英文註冊版 – 數據庫管理工具

Navicat Premium v​​12.1.9 / 12.1.10 Win / Mac簡體中文/繁體中文/英文註冊版 – 數據庫管理工具

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 v​​12.1.9 / 12.1.10 Win / Mac簡體中文/繁體中文/英文註冊版 - 數據庫管理工具

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

導航嚮導，導出嚮導，查詢創建工具，報表創建工具，數據同步，備份，工作計劃及更多.Navicat的功能足以符合專業開發人員的所有需求，但是對數據庫服務器的新手來說又相當容容學習。

Navicat Premium v​​12.1.9 / 12.1.10 Win / Mac簡體中文/繁體中文/英文註冊版 - 數據庫管理工具

安全連接

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

對象設計器

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

Navicat Premium v​​12.1.9 / 12.1.10 Win / Mac簡體中文/繁體中文/英文註冊版 - 數據庫管理工具

網格或表單查看

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

Navicat Premium v​​12.1.9 / 12.1.10 Win / Mac簡體中文/繁體中文/英文註冊版 - 數據庫管理工具

外鍵數據選擇

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

SQL創建工具

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

Navicat Premium v​​12.1.9 / 12.1.10 Win / Mac簡體中文/繁體中文/英文註冊版 - 數據庫管理工具

自動完成代碼

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

逆向工程

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

正向工程和腳本生成

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

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

導入或導出嚮導

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

Navicat Premium v​​12.1.9 / 12.1.10 Win / Mac簡體中文/繁體中文/英文註冊版 - 數據庫管理工具

數據傳輸

在MySQL，MariaDB，SQL Server，Oracle，PostgreSQL和SQLite數據庫。你可以選擇以指定的SQL格式和編碼導出數據為SQL文件。這個功能可大大的簡化遷移數據的進程。

數據或結構同步

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

Navicat Premium v​​12.1.9 / 12.1.10 Win / Mac簡體中文/繁體中文/英文註冊版 - 數據庫管理工具

備份或還原

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

計劃

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

 

Oct 5 2018 Navicat Premium (Windows) version 12.1.8
Bug-fixes:

  1. Custom Filter was cleared when editing it.
  2. DBMS Output result was incomplete.
  3. HTML export did not specify charset.
  4. “Show/Hide Columns” option was missing in Form View.
  5. The hidden Information pane was shown when switching from Form View to Grid View.
  6. Cursor focus issue in Form View.
  7. Code Completion did not work in some cases.
  8. “Unterminated quoted string” error occurred when restoring backup in some cases.
  9. Link connection from Oracle to SQL Server failed in some cases.
  10. Minor bug fixes and improvements.
Sep 10 2018 Navicat Premium (Windows) version 12.1.7
Bug-fixes:

  1. “SQLite function sqlite_libversion cannot linked” error occurred when starting Navicat.
  2. Unknown Internal Error occurred when using foreign key data selection feature in SQL Server.
  3. Unable to scroll inside the text box in Form View.
  4. Slow issue when managing PostgreSQL Role.
  5. “is in list” operator in Filter Wizard did not working correctly.
  6. Structure Synchronization compared table options.
  7. Minor bug fixes and improvements.
Aug 21 2018 Navicat Premium (Windows) version 12.1.6
Bug-fixes:

  1. Unknown Internal Error occurred when showing data “{}” in TEXT editor.
  2. Precision value in CURRENT_TIMESTAMP(6) was missing when synchronizing structure.
  3. Error occurred when editing SQL Server data.
  4. BIGINT was exported as float when exporting Excel file.
  5. Esc shortcut did not work when error occurred during deleting records.
  6. Error occurred when renaming an existing column and adding a new one.
  7. Filter value did not displayed when the string exceeded 5880 characters.
  8. Unable to display the columns list in Table Designer’s Index tab when there was no index.
  9. Unable to apply Filter profile.
  10. Unable to scroll to right in Filter Wizard.
  11. PostgreSQL Debugger did not work in some cases.
  12. “Date” and “Time” field data were shown as blank in Table Viewer.
  13. Opening Design Table froze in large database.
  14. “Open Table” and “Design Table” were not properly synchronized.
  15. Import Target and Field Mapping changed after changing the source file in profile.
Jul 31 2018 Navicat Premium (Windows) version 12.1.5
Improvements:

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

Bug-fixes:

  1. Crashed when applying filter in Foreign Key Selection window.
  2. Error occurred when synchronizing PostgreSQL structure.
  3. Minor bug fixes and improvements.
Jul 26 2018 Navicat Premium (Windows) version 12.1.4
Main New Features:

  1. Support of MongoDB
  2. Support Roles for MySQL 8
  3. Support Roles for MariaDB 10
  4. Support Partitioned Table for PostgreSQL 10
  5. Brand new Filter Wizard
  6. UI and UX Improvement
  7. Navicat for MongoDB is released
May 29 2018 Navicat Premium (Windows) version 12.0.29
Bug Fixes:

  1. File encoding was incorrect when transferring database to SQL file.
  2. The generated CREATE PROCEDURE statement was incorrect when dumping database to SQL file.
  3. Structure Synchronization detected differences after synchronizing.
  4. Incorrect unique values were imported from .dbf file.
  5. Crashed when saving the modified field names in some cases.
  6. Extra “(” was added to INSERT statements when deploying scripts in Data Synchronization.
  7. Foreign keys were not transferred when transferring tables from MySQL to SQLite.
  8. Unable to restore LONGTEXT data completely from .psc file.
  9. .ndm file association was not worked.
May 8 2018 Navicat Premium (Windows) version 12.0.28
Improvements:

  1. Supported to connect MySQL 8 using SHA2 connection.

Bug Fixes:

  1. 80041318 error occurred when saving a task schedule.
  2. The cursor position row moved to the bottom line after saved the procedure/function.
  3. “XXX is not a valid value” error occurred when editing a PostgreSQL model table in some cases.
  4. Syntax error occurred when updating MySQL user password.
  5. Transaction did not end after closing the table in some cases.
  6. Error occurred when there was a “CRLF” character in Oracle procedure.
Apr 25 2018 Navicat Premium (Windows) version 12.0.27
Bug Fixes:

  1. Unable to transfer objects between different server types by drag-and-drop.
  2. Zero decimal place digits were not displayed in Table Viewer.
  3. “Double” format issue for SQL Server in Table Viewer.
  4. Exported SQL file did not have table name when exporting an unsaved query.
  5. Incorrect SQL “ON UPDATE CURRENT_TIMESTAMP(0)” was dumped for MariaDB 5.5 tables.
  6. The privileges of PostgreSQL functions with parameters were not visible in Privilege Manager.
  7. Error occurred when transferring BLOB data from MySQL to SQL Server.
  8. Unknown Internal Error occurred when importing from ODBC.
  9. Incorrect dates were exported when exporting PostgreSQL tables to Excel files.
  10. Syntax error occurred when importing CSV files in some cases.
  11. Database names were missing in the Drop SQL generated by Structure Synchronization.
  12. ORA-01830 error occurred when transferring tables to Oracle server in some cases.
  13. Unable to change the Tab Width in Query Editor.
  14. Unable to edit query results when tables had alias.
  15. Procedure parameters were missing in the scripts generated by Structure Synchronization.
  16. Unknown Internal Error occurred when Automation ran.
  17. Unable to transfer tables with HEX format.
  18. Default parameter syntax was stripped after saving PostgreSQL function.
  19. Syntax error occurred when creating PostgreSQL function with array parameters.
  20. Encoding issue of the exported text file.
  21. Unable to show the SQLite CTE based view definition in View Designer.
  22. Crashed when the Oracle host name was longer than 1000.
Mar 28 2018 Navicat Premium (Windows) version 12.0.26
Bug Fixes:

  1. “Access Violation” error occurred when creating new connections in fresh installed Navicat.
Mar 27 2018 Navicat Premium (Windows) version 12.0.25
Bug Fixes:

  1. Unable to create a query inside a group.
  2. The color of function keywords did not change according to the Font Color settings in Options.
  3. Column width did not retain after hide and show the column in Table Viewer.
  4. Unable to drag and drop a query into a group in some cases.
  5. “SQL Logic” error occurred when loading SQLite extension.
  6. Unable to edit query results in some cases.
  7. Unable to disable Foreign Key constraint in Data Synchronization.
  8. Crashed when dumping table to sql file in some cases.
  9. Foreign Key constraint didn’t work when the constraint name was empty in SQLite.
  10. DROP PROCEDURE statements in Structure Synchronization did not include the schema name.
  11. Some setting values was missing in SQLite Trigger Designer.
  12. Foreign Key constraint issue in Import Wizard.
  13. Unable to show the SQLite CTE based view definition in View Designer.
  14. SQLite connections was missing in Model’s Import from Database feature.
  15. Code completion replaced the text after caret.
  16. Exported files or reports were not attached to the notification email.
  17. Plugin error occurred when using RSA/PAM authentication for MariaDB connections.
  18. Keepalive Interval setting attempted to connect continuously even the database was down.
  19. If a query was opened, abnormal behavior happened when closing Navicat.
  20. Automation did not start when the computer was logged out.
  21. Unable to create new table with primary key settings in Import Wizard.
Feb 22 2018 Navicat Premium (Windows) version 12.0.24
Improvements:

  1. Supported creating PostgreSQL 10 Models.
  2. Supported Microsoft Azure Database for MySQL.

Bug Fixes:

  1. RAISE NOTICE events did not show in Message Log.
  2. Spaces were missing in the SQL exported from Model.
  3. Extra newlines were added to the SQL exported from Model.
  4. Unable to change the comment of PostgreSQL functions with named parameters.
  5. “Hourly” option was missing on Task Schedule’s Trigger tab.
  6. Wrong datestamp was appended to the exported files.
  7. Added records showed wrong values until refreshing SQLite table grid.
  8. Slow issue when searching in Table Viewer.
  9. Unable to move functions into a group.
  10. Syntax error occurred when running query in some cases.
  11. Unable to select Enum data in query results.
  12. “Unknown Internal Error” occurred when opening SQLite tables.
  13. “Invalid byte sequence for encoding” error occurred when opening PostgreSQL tables.
  14. Target functions/procedures were not dropped before create when synchronizing structure.
  15. Unable to synchronize models/queries in Navicat Cloud.
  16. Exported Excel files were corrupted in some cases.
  17. “Access is denied” error occurred when setting schedule.
Jan 22 2018 Navicat Premium (Windows) version 12.0.23
Improvements:

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

Bug Fixes:

  1. Error occurred when synchronizing structure in some cases.
  2. Replace All did not work in Table Viewer.
  3. “Unknown Internal Error” occurred when opening SQLite table.
  4. Cell selection disappeared after pressing CTRL+C in Table Viewer.
  5. Error occurred when running query in some cases.
  6. “Unknown Internal Error” occurred when exporting query results.
  7. Unable to choose the custom object type in Table Designer.
Jan 15 2018 Navicat Premium (Windows) version 12.0.22
Bug Fixes:

  1. Unknown Internal error occurred when editing/adding connections.
  2. Adding self-referencing table issue in Query Builder.
  3. Minor bug fixes and improvements.
Jan 11 2018 Navicat Premium (Windows) version 12.0.21
Bug Fixes:

  1. Out of memory issue when running Data Transfer.
  2. Unable to add Identify column in existing SQL Server tables.
  3. “Unknown Internal Error” occurred when loading profiles in Structure Synchronization.
  4. Export Float data to csv files issue.
  5. No scripts were deployed when synchronizing SQL Server functions.
  6. Syntax error occurred when synchronizing MySQL functions.
  7. Unable to display Oracle Chinese data in some cases.
  8. Crashed when importing Excel or Text files in some cases.
  9. Opening large databases in List View took long time.
  10. Unable to show query files with “.SQL” extension in Objects tab.
  11. The length of NVARCHAR fields were missing when exporting models to SQL files.
  12. Errors occurred when executing MySQL Dump files.
  13. CTRL+SPACE shortcut were missing in Query Editor.
  14. Target’s default Tablespace were not used in Data Transfer.
  15. Unable to connect PostgreSQL 10 with scram-sha-265 Auth-Method.
  16. Print report to PDF command wrongly sent the report to printer.
  17. Null date values were exported wrongly as “1900-01-00” in Excel files.
  18. Tables Viewer displayed wrong number of digits.
  19. Input parameter window did not pop up when exporting query.
  20. “Invalid Stored Procedure Syntax” error occurred when saving PostgreSQL functions.
  21. High CPU usage issue.
Dec 5 2017 Navicat Premium (Windows) version 12.0.20
Bug Fixes:

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

簡體中文版：12.1.9官網下載地址： https ： //www.navicat.com/en/download/navicat-premium

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

12.1.x版本官網下載

for x86： http ：//download3.navicat.com/download/navicat121_premium_cs_x86.exe

for x64： http ：//download3.navicat.com/download/navicat121_premium_cs_x64.exe

對於MacOS： http ：//download3.navicat.com/download/navicat121_premium_cs.dmg

繁體中文版：12.1.9

for x86： http ：//download3.navicat.com/download/navicat121_premium_ct_x86.exe

for x64： http ：//download3.navicat.com/download/navicat121_premium_ct_x64.exe

對於MacOS： http ：//download3.navicat.com/download/navicat121_premium_ct.dmg

英文版：12.1.9

for x86： http ：//download3.navicat.com/download/navicat121_premium_en_x86.exe

for x64： http ：//download3.navicat.com/download/navicat121_premium_en_x64.exe

對於MacOS： http ：//download3.navicat.com/download/navicat121_premium_en.dmg

12.0.x版版本官網下載

簡體中文版：12.0.29

for x86： http ：//www.navicat.com.cn/installers/navicat120_premium_cs_x86.exe

for x64： http ：//www.navicat.com.cn/installers/navicat120_premium_cs_x64.exe

對於MacOS： http ：//www.navicat.com.cn/installers/navicat120_premium_cs.dmg

繁體中文版：12.0.29

for x86： http ：//download3.navicat.com/download/navicat120_premium_ct_x86.exe

for x64： http ：//download3.navicat.com/download/navicat120_premium_ct_x64.exe

對於MacOS： http ：//download3.navicat.com/download/navicat120_premium_cs.dmg

英文版：12.0.29

for x86： http ： //download3.navicat.com/download/navicat120_premium_en_x86.exe

for x64： http ： //download3.navicat.com/download/navicat120_premium_en_x64.exe

對於MacOS： http ： //download3.navicat.com/download/navicat120_premium_en.dmg

發表迴響

這個網站採用 Akismet 服務減少垃圾留言。進一步了解 Akismet 如何處理網站訪客的留言資料。