商品明細

Navicat Premium 資料庫管理開發

商品簡述
Navicat Premium是一套資料庫開發工具,你可以快速輕鬆地建立、管理和維護資料庫

商品介紹

本產品出貨為最新版本。
如需購買或了解內容請來電(2749-1909)或來信(
sales@ahasoft.com.tw)業務部
___________________________________________________________________

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

Seamless Data 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.


Diversified Manipulation Tool
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. Add, modify, 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.


Easy SQL/Query Editing
Visual SQL/Query Builder will help you create, edit and run SQL statements/queries 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. 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.


Intelligent Database Designer
Create, modify and manage all database objects using our professional object designers. 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.


Data Visualization Tool
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.


Increase Your 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.


Smart 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.


Make Collaboration Easy
Synchronize your connection settings, models, queries and virtual groups to our Navicat Cloud service so you can get real-time access to them, and share them with your coworkers anytime and anywhere. With Navicat Cloud, you can leverage every minute of your day to maximize your productivity. 


Advanced 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.


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.


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.

Feature Matrix

Essentials  

Enterprise

General

MySQL 3.21 or later, Drizzle, OurDelta, and Percona Server

MariaDB 5.1 or later

MongoDB 3.0 or later

Oracle 8.1 or later ( macOS Edition starts from Oracle 9i )

PostgreSQL 7.3 or later

SQLite 2 and 3

SQL Server 2000 or later

Amazon RDS, Amazon Aurora, Amazon Redshift, Microsoft Azure, Oracle Cloud, Google Cloud, Alibaba Cloud, Tencent Cloud, MongoDB Atlas, Huawei Cloud

Connection

Secure connection: SSH/HTTP/SSL

PAM and GSSAPI authentication

Kerberos and LDAP authentication

x.509 certificate authentication

Export/import connection settings

Navicat Cloud

Collaboration: create projects, add members

Synchronize connections and queries

Synchronize models and virtual groups

Data Viewer and Editor

Grid view, Tree view and JSON view

Form view

Foreign key data selection

Text, Hex, Image, Web or BFile viewer/editor

Raw mode editing

Data Validation

Customize data type colorings

Find and replace

Filter records

SQL/Script Processing

PL/SQL and PL/PGSQL Debugger

SQL/Script Editor

Visual SQL/Script Builder

Find Builder

Aggregate Builder

Code Snippet and Completion

SQL/Script Beautifier and Minifier

Find and replace

Create parameter queries

Open query files in an external editor

Console

Data Visualization

Support 20 chart types

Visualize live data

Customize multiple pages dashboard

Add interactive controls

Data Modeling

Conceptual, Logical and Physical model

Reverse/forward engineering

Auto layout

Add vertices, layers, images, notes, labels and shapes

Print database diagrams to PDF and graphic files

Import/Export

Import/export data from/to plain text file formats: TXT, CSV, XML, JSON

Import/export data from/to most popular formats: DBF etc

Import data from ODBC, MS Excel, MS Access

Export data to MS Excel, HTML

Export data to MS Access (Windows Edition only)

MongoImport and MongoExport

Data Manipulation

Data Transfer (Same or cross server type)

Data/Structure Synchronization

Backup/Restore

Backup/restore MySQL/MariaDB/PostgreSQL/SQLite database

Convert backup file into SQL script

MongoDump and MongoRestore

Oracle Data Pump

SQL Server Backup/Restore

Dump/Execute SQL file

Automation

Set schedule on backup, MongoDump, MongoImport, MongoExport, MapReduce, query execution, import/export, data transfer and data synchronization

Run profiles from different servers in a single batch job

Include attachment for export file in notification email

Server Security

Manage user

Server Monitor

Other Useful Features

Schema Analysis

ER Diagram view

Virtual grouping

Customize connection colorings

Database wide search

Favorites list

Print database/schema/table structure

Dark mode

System Requirements

Windows

Microsoft Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10, Server 2008, Server 2012, Server 2016, Server 2019

macOS

MacOS 10.12 Sierra or later

Linux

Debian 9 or later, Ubuntu 16.04 or later, CentOS 7 or later, Fedora 26 or later, Linux Mint 18 or later

Windows
Main Screen


Object Designer


macOS
Main Screen


Object Designer


Linux
Main Screen


Object Designer