Navicat Premium combines the functions of other Navicat members. With connections established to different database types, Navicat Premium supports data transfer between MySQL, Oracle and PostgreSQL. It supports most of the features in MySQL, Oracle and PostgreSQL including Stored Procedure, Event, Trigger, Function, View, etc.

Navicat Premium enables you to easily and quickly transfer data across various database systems, or to a plain text file with designated SQL format and encoding.

Batch job for different kind of databases can also be scheduled and run at a specific time. Other features include Import/ Export Wizard, Query Builder, Report Builder, Data Synchronization, Backup, Job Scheduler and more.

Features in Navicat are sophisticated enough to provide professional developers for all their specific needs, yet easy to learn for users who are new to database server.

Navicat Premium is available for three platforms - Microsoft Windows, Mac OS X and Linux. It can connect users to local/remote server, providing several utilities such as Data/Structure Synchronization, Import/Export, Backup/restore and Report to facilitate the process of maintaining data.

Feature Matrix

Platforms	Windows Edition	Windows Lite Edition	Mac OS X Standard Edition	Mac OS X Lite Edition	Linux Standard Edition	Linux Lite Edition
MySQL Objects Management
Supports MySQL Servers 3.21 or above
Create / Drop Databases
Support all MySQL objects: tables, views, procedures/functions and events
Support all subobjects: fields, indices, foreign keys and triggers
Support of partitioning
Support of character set and unicode
Oracle Objects Management
Supports Oracle Servers 8.1 or above
Create/drop schemas
Support all Oracle objects: tables (Normal, External and Index Organized), views, procedures/functions
Support all subobjects: fields, indices, foreign keys, uniques, checks and triggers
Managing directories, tablespaces, public database links and public synonyms
Managing database links, indices, java, materialized views, materialized view logs, packages, sequences, synonyms, triggers, types, XML Schema and Recycle Bin
Support of physical attributes
Support of character set and unicode
PostgreSQL Objects Management
Supports PostgreSQL Servers 7.3 or above
Create /drop databases and schemas
Support all PostgreSQL objects: tables, views and functions
Support all subobjects: fields, indices, foreign keys, uniques, checks, rules and triggers
Managing tablespace
Managing cast and languages
Managing aggregates, conversions, domains, trigger functions, operators and classes, sequences and types
Support of character set and unicode
Connection Management and Navigation
Multiple local/remote MySQL/Oracle/PostgreSQL server connections
Support of Oracle Basic Connection
Support of Oracle TNS Connection
Connection to MySQL/Oracle/PostgreSQL Server through SSH
Connection to MySQL/PostgreSQL Server through HTTP
Support SSL secure connection for MySQL and PostgreSQL 8.4 above
Backup connection information
Customize selected MySQL/PostgreSQL databases to work with
Data Viewer and Editor
Grid view
Form view
Text, Hex and BLOB viewer/editor
Oracle BFile viewer/editor
Copying and pasting selected records
Customize display formats
Incremental search, sorting and formatting table grid
Ability to show/hide Oracle table ROWID
Support of raw mode edit: apply MySQL/PostgreSQL built-in function
Support of foreign key data selection: locate the available values from the reference table
Filtering Records
Ability to set number of records showing on each page
SQL Processing
Visual query/view builder to facilitate the process of building complicated queries
Ability to create parameter queries
Multiple SQL editors with syntax highlighted feature
Code completion for SQL editors
Ability to preview SQL before execution
Support to return multi-resultsets
SQL console
Diversified Import and Export Competence
Importing data from ODBC: MSSQL, Oracle etc
Importing data from MS Excel
Importing data from MS Access
Importing data from other file formats : TXT, CSV, XML, DBF etc
Exporting data to MS Excel
Exporting data to MS Access
Exporting data to HTML and PDF
Exporting data to most popular formats: TXT, CSV, XML, DBF etc
Other Data Manipulation Tools
Data transfer (Same or cross server type)
Transferring data to SQL script as INSERT statement
Transferring data to a SQL file with designated SQL format and encoding
Data synchronization
Structure synchronization
Backup/Restore for MySQL/PostgreSQL
Backing up/restoring database
Restoring database with chosen database objects
Converting backup file into SQL script
Compressing/Decompressing Backup files
Schedule for Batch Job
Ability to set schedule on backup, query execution, import/export, data transfer and data synchronization
Ability to run profiles from different servers in a single schedule job
Schedule report printing
Schedule to print report to files: PDF, Excel, HTML etc
Sending notification e-mail for schedule task
Ability to attach Export Wizard/Report result files in Batch Job notification email
Server Security and Maintenance Services
Visual user manager to administer users, groups (roles) and privileges
Maintance database/schema objects tables
Server Monitor to view system variables and server status information
Report Management Tools
Report Builder
Report Viewer
Other Useful Features
Backing up schema/table to SQL script
Executing SQL script
Duplicate/empty/ truncate tables
Create table/view shortcut on desktop
Print schema/table Structure
Support of docking/tab windows
Support of virtual grouping: provide logical organization over connections and objects
Ability to run profile from command line
Log files: keep track on the actions have been performed in Navicat
Ability to copy Connection Information into Clipboard