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
软件下载地址:
您暂时无权查看此隐藏内容!
评论前必须登录!
注册