一款用于数据库治理、开发与数据迁徙的多平台图形化工具

更多文章 >>

• Navicat软件AI副手与智能建模：开释数据力量，赋能精准决策
• 数据库开发工具Navicat17的亮点职能一览
• Navicat软件职能介绍

?

?

Navicat Premium是一种数据库开发工具，可让你从单个利用法式同时衔接到MySQL、MariaDB、MongoDB、SQL Server、Oracle、PostgreSQL和SQLite数据库。与Amazon RDS、Amazon Aurora、Amazon Redshift、Microsoft Azure、Oracle Cloud、Google Cloud 和 MongoDB Atlas等云数据库兼容。您能够急剧轻松地构建、治理和守护您的数据库。

?

主屏幕

直观且设计优良的GUI可简化您的数据库治理和开发。

?

?

对象设计器

使用智能对象设计器治理所罕见据库对象。

?

?

RDBMS的数据运行?

将数据条款插入、编纂、删除或复造/粘贴到我们类似电子表格的数据编纂器中。

?

?

MongoDB的数据操运行

使用1xBET各类数据编纂器插入、编纂或删除数据。

?

?

数据库

使用复杂的数据库设计和建模工具可视化和编纂您的数据库。

?

?

图表

将您的数据库数据转化为视觉成就，通过图表和图形对数据有清澈的洞察力。

?

?

数据同步

通过具体的分析过程比力和同步数据库/模式之间的数据。

?

?

结构同步

提供数据库差距的全貌，并天生脚正本更新指标数据库。

?

?

数据天生

天生海量质量检验数据。

?

?

MongoDB的模式分析

急剧可视化数据散布、鉴别数据异常值并验证您的模式。

?

?

代码实现

通过从下拉列表当选择建议，在SQL/查问编纂器中构建SQL语句/查问。

?

?

代码片段

将片段插入SQL/查问编纂器，以更快、更正确地编写SQL/查问。

?

?

自动化

为您的日常工作创建和铺排批处置作业，并在职务实现时收到通知电子邮件。

?

?

Navicat合作

将您的文件存储在云中以起头与您的团队成员合作。

?

?

特点：

数据查看器 ?

使用1xBET内置编纂器查看、更新和删除纪录，您能够在树视图、JSON视图和经典的类似电子表格的网格视图中进行编纂。Navicat为你提供有效治理数据所需的工具，并确保流程顺利进行。

?

对象设计器 ?

对象设计器使您能够轻松急剧地接见治理数据库对象。Navicat通过方便的UI将查问分化为选项卡。让您在每一步都越发自负和正确地编写复杂的SQL。

?

SQL编纂器/调试器 ?

Visual SQL Builder将援手您创建、编纂和运行SQL语句，而不用不安语法和指令的正确使用。通过获取关键字建议并从编码中去除沉复，使用代码实现和可定造的代码片段急剧编码。此表，您还能够使用1xBET调试组件急剧定位和纠正PL/SQL和PL/PGSQL 编码谬误，例如设置断点、单步执行法式、查看和建扭转量值以及查抄挪用仓库。

?

迁徙

数据传输、数据同步和结构同步可援手您以更少的开销更轻松、更急剧地迁徙数据。为跨各类DBMS传输数据提供具体的分步指南。使用数据和结构同步比力和同步数据库。在几秒钟内设置和部署比力，并获取具体的脚正本指定您要执行的更改。

?

模型 ?

使用复杂的数据库设计和建模工具将您的数据库转换为图形暗示，以便您能够轻松地建模、创建和理解复杂的数据库。简化创建复杂实体关系模型的工作，只需单击一下即可天生剧本SQL。

?

图表 ?

图表职能可让您创建大型数据集的可视化暗示，并援手您从数据中获得更深刻的见解。索求和挖掘数据之间的模式、趋向和关系，并创建有效的可视化输出以在仪表板中展示您的发现以供共享。

?

进出口 ?

使用导入向导将数据从分歧体式传输到数据库，或者在设置数据源衔接后从ODBC传输数据。将表/集钟凝视图或查问了局中的数据导出为Excel、Access、CSV等体式。

?

数据天生器 ?

提供美满的职能，天生海量质量检验数据。您能够凭据业务规定和约束急剧创建拥有参照齐全性的真实数据集。

?

提逾越产率 ?

强的本地备份/复原解决规划和用于MongoDump、Oracle数据泵和SQL Server备份实用法式的直观GUI可领导您实现备份过程并削减犯错的可能性。为可沉复的部署过程设置自动化，例如在特按功夫或日期执行数据库备份、MapReduce作业和剧本。无论您身在何处，都能够随时实现工作。

?

模式分析器 ?

使用内置的模式可视化工具发现和索求您的MongoDB模式。分析您的文档并显示集中中的丰硕结构，这样您就能够相识数据的架构、查找架构异常并轻松查抄异常值。

?

合作 ?

将您的衔接设置、查问、模型、片段、图表工作区和虚构组信息同步到云服务，以便您能够实时接见它们，并随时随地与您的同事共享。

?

Secure Connection

通过SSH隧路和SSL成立secure衔接，确保每个衔接都secure、不变和靠得住。支持数据库服务器分歧的认证方式，如MySQL和MariaDB的PAM认证，MongoDB的Kerberos和X.509认证，PostgreSQL的GSSAPI认证。Navicat提供更多验证机造和高机能环境，因而你始终不用不安通过insecure的网络进行衔接。

?

深色模式 ?

设置深色主题以；つ难劬γ馐艽惩扑慊旅さ陌咨跋。当您处于深色模式时，页面的表观不会扭转行为。

?

跨平台许可 ?

此刻能够使用跨平台许可。无论您是在Windows、macOS还是Linux上运行，您都能够采办一次并选择一个平台来启动，而后再转移您的许可证。

?

系统要求：

?

Windows：

Microsoft Windows 7、Windows 8、Windows 8.1、Windows 10、Windows 11、Server 2012、Server 2016、Server 2019

?

Mac

macOS 10.14 Mojave、macOS 10.15 Catalina、macOS 11 Big Sur、macOS 12 Monterey、macOS 13 Ventura

?

Linux

Debian 9、Debian 10、Debian 11、Ubuntu 18.04、Ubuntu 20.04、Ubuntu 22.04、Fedora 33、Fedora 34、Fedora 35、Linux Mint 19、Linux Mint 20、Linux Mint 21、Deepin 20

?

【英文介绍】

?

Navicat Premium is a database development tool that allows you to simultaneously connect to MySQL, MariaDB, MongoDB, SQL Server, Oracle, PostgreSQL, and SQLite databases from a single application. Compatible with cloud databases like Amazon RDS, Amazon Aurora, Amazon Redshift, Microsoft Azure, Oracle Cloud, Google Cloud and MongoDB Atlas. You can quickly and easily build, manage and maintain your databases.

?

Features

Data Viewer ?

View, update, and delete records with our built-in editors, you can facilitate your edits in Tree View, JSON View, and the classic spreadsheet-like Grid View. Navicat gives you the tools you need to manage your data efficiently and ensure a smooth process.

?

Object Designer ?

Our Object Designer provides you easy and fast access for managing database objects. Navicat breaks down query writing into tabs through a convenient UI. Allow you to write complex SQL with greater confidence and accuracy at every step.

?

SQL Edit/ Debugger ?

Visual SQL Builder will help you create, edit and run SQL statements without having to worry about syntax and proper usage of commands. Code fast with Code Completion and customizable Code Snippet by getting suggestions for keywords and stripping the repetition from coding. Also, you can quickly locate and correct PL/SQL and PL/PGSQL coding errors using our debugging component such as setting breakpoints, stepping through the program, viewing and modifying variable values, and examining the call stack.

?

Migration ?

Data Transfer, Data Synchronization and Structure Synchronization help you migrate your data easier and faster for less overhead. Deliver detailed, step-by-step guidelines for transferring data across various DBMS. Compare and synchronize databases with Data and Structure Synchronization. Set up and deploy the comparisons in seconds, and get the detailed script to specify the changes you want to execute.

?

Model ?

Convert your databases into graphical representations using a sophisticated database design and modeling tool so you can model, create, and understand complex databases with ease. Simplify the task of creating complex entity relationship models and generate the script SQL with a simple click.

?

Charts ?

Our Charts feature lets you create visual representations of large data sets and help you to gain deeper insights from your data. Explore and unearth patterns, trends and relations between data, and create effective visual outputs to present your findings in dashboard for sharing.

?

Import/Export ?

Use Import Wizard to transfer data into a database from diverse formats, or from ODBC after setting up a data source connection. Export data from tables/collections, views, or query results to formats such as Excel, Access, CSV and more.

?

Data Generator ?

Provide a comprehensive range of functions to generate a large volume of quality testing data. You can rapidly create realistic data sets with referential integrity based on business rules and constraints.

?

Increase Productivity ?

Our powerful local backup/restore solution and intuitive GUI for MongoDump, Oracle Data Pump and SQL Server Backup Utility guides you through the backup process and reduces the potential for errors. Set an automation for repeatable deployment process like database backup, MapReduce job and script execution at a specific time or day. No matter where you are, you can always get the job done.

?

Schema Analyzer ?

Discover and explore your MongoDB schema with our built-in schema visualization tool. Analyze your documents and displays rich structures within your collections, so you can understand your data’s schema, find schema anomalies, and inspect outliers easily.

?

Collaboration ?

Synchronize your connection settings, queries, models, snippets, chart workspaces and virtual group information to the cloud service so you can get real-time access to them, and share them with your coworkers anytime and anywhere.

?

Secure Connection ?

Establish secure connections through SSH Tunneling and SSL ensure every connection is secure, stable, and reliable. Support different authentication methods of database servers such as PAM authentication for MySQL and MariaDB, Kerberos and X.509 authentication for MongoDB, and GSSAPI authentication for PostgreSQL. Navicat provides more authentication mechanisms and high-performance environments so you never have to worry about connecting over an insecure network.

?

Dark Mode ?

Set dark theme to protect your eyes from the traditionally blinding whiteness of computer. No behavior changes with how pages look when you are in dark mode.

?

Cross-Platform Licensing ?

Cross-platform licensing is now available. Whether you're operating on Windows, macOS, or Linux, you can purchase once and select a platform to activate and later on transfer your license.