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 成员的功能,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
12.1.x版本官网下载
简体中文版:12.1.25
for x86: http://download3.navicat.com/download/navicat121_premium_cs_x86.exe
for x64: http://download3.navicat.com/download/navicat121_premium_cs_x64.exe
for MacOS: http://download3.navicat.com/download/navicat121_premium_cs.dmg
繁体中文版:12.1.25
for x86: http://download3.navicat.com/download/navicat121_premium_ct_x86.exe
for x64: http://download3.navicat.com/download/navicat121_premium_ct_x64.exe
for MacOS: http://download3.navicat.com/download/navicat121_premium_ct.dmg
英文版:12.1.25
for x86: http://download3.navicat.com/download/navicat121_premium_en_x86.exe
for x64: http://download3.navicat.com/download/navicat121_premium_en_x64.exe
for 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
for 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
for 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
for MacOS: http://download3.navicat.com/download/navicat120_premium_en.dmg
下载仅供下载体验和测试学习,不得商用和正当使用。
点击下载