Navicat Premium

Navicat Premium is a multi-connections Database Administration tool allowing you to connect to MySQL, SQL Server, SQLite, Oracle and PostgreSQL databases simultaneously within a single application, making database administration to multiple kinds of database so easy.

Navicat Premium combines the functions of other Navicat members and supports most of the features in MySQL, SQL Server, SQLite, 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.

Multi-connections Database Administration tool
Additional Connection Options
Cross-servers Data Manipulation Tools
Advanced Oracle/SQL Server Management Tools
Well-Designed Visual Builder/SQL Editor
Diversified Import and Export Competence
Powerful Data Manipulation Tools
Powerful Security Management
Easy-to-Use Report Builder
More Great Features


System Requirements
Microsoft Windows XP, Vista, Server 2003, Server 2008, Windows 7
Pentium II processor or above
256 megabytes (MB) of RAM
Hard-disk space vary depending on installation. Full installation requires 65 MB of available hard-disk space
Multi-connections Database Administration tool

Navicat Premium allows you to perform multiple server administration to MySQL, SQL Server, SQLite, Oracle and PostgreSQL databases from a single interface. It combines the functions of other Navicat members and supports most of the features in MySQL, SQL Server, SQLite, Oracle and PostgreSQL including Stored Procedure, Event, Trigger, Function, View, etc. This is a time saver, and beneficial to any administrator managing multiple servers.



Latest MySQL Versions Support
Support of MySQL versions from 3.21 or above.
Support all MySQL objects: tables, views, stored procedures/functions and events.
Support all subobjects: fields, indices, foreign keys and triggers.
Support of partitioning.
Support of character set and unicode.


Latest SQL Server Versions Support
Support SQL Server 2000 or above.
Support SQL Azure.
Support all SQL Server objects: tables, views and functions.
Support all subobjects: fields, indexes, foreign keys, uniques, checks and triggers.
Managing linked servers, server triggers.
Managing assemblies, partition functions, partition schemes and database triggers.
Managing indexes, synonyms and triggers.
Support of character set and unicode.


All SQLite Versions Support
Support of SQLite 2 and 3.
Support all SQLite objects: tables and views.
Support all subobjects: triggers and indices.
Support of character set and unicode.

Latest Oracle Versions Support
Support Oracle Servers 8.1 or above.
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.


Latest PostgreSQL Versions Support
Support PostgreSQL Servers 7.3 or above.
Support all PostgreSQL objects: tables, views and functions.
Support all subobjects: fields, indices, foreign keys, uniques, checks, rules and triggers.
Managing tablespace, cast and languages.
Managing aggregates, conversions, domains, trigger functions, operators and classes, sequences and types.
Support of character set and unicode.



Additional Connection Options

Support connection to MySQL/SQL Server/Oracle/PostgreSQL through SSH Tunnel
Establish a secure SSH session through SSH Tunneling in Navicat. Enjoy a strong authentication and secure encrypted communications between two hosts. The authentication method can use a password or public / private key pair.



Support connection to MySQL/SQLite/PostgreSQL server through HTTP Tunnel
Navicat comes with HTTP Tunneling while your ISPs do not allow direct connections to their database servers but allow establishing HTTP connections. HTTP Tunneling is a method for connecting to a server that uses the same protocol (http://) and the same port (port 80) as a webserver does.


Import/Export Connection Settings
You can easily transfer your connection settings while migrating Navicat from one computer to another new machine. Simply export your connections via Navicat and restore it on the new machine.


Cross-servers Data Manipulation Tools

Support of transferring data between servers
Data Transfer allows you to effortlessly transfer data across various database systems. This feature will drastically simplify the process for migrating data.



Export data and create records as INSERT statements in sql file
During Data Transfer, you can choose to export data as sql file with designated SQL format and encoding.



Create Schedule for Backup, Import/Export, Data Transfer, Queries and Data Synchronization from different kind of servers
Profiles from different kind of databases can be created in a single batch job, so that you can set schedule and run at a specific time. Batch job can be created for Report Printing, Backup, Query, Data Transfer, Data Synchronization, Import and Export.



Send notification e-mail and attachment for schedule task
Generate notification e-mails to recipients you specify, connecting them to the latest schedule information. Read directly through your email account on the results returned from a schedule. Also, exported file or printed report can be added to the batch job as mail attachment so that you can share your data easily.



Advanced Oracle/SQL Server Management Tools

Support of Oracle PL/SQL Code Debugger
PL/SQL Debugger offers all features you could wish for such as setting breakpoints, stepping through the program, viewing and modifying variable values, and examining the call stack. You can debug PL/SQL code such as procedures and functions, object methods, and triggers directly from the Navicat environment.



Oracle/SQL Server Code Outline
The tree view shows dependencies and information among objects including function, procedure, package, type, parameter, code body and so on.



Well-Designed Visual Builder/SQL Editor

Visual SQL Builder
Visual SQL Builder - which is divided into two portions: the upper Graphical View, and the lower Syntax View, allows you to create and edit queries/views visually without knowledge of SQL.


Query Editor
It allows you to create and edit SQL text for a query, prepare and execute selected queries.


Support of Parameter Query
Set query parameters to add variable values to a query each time you run it.



SQL Beautifier
With SQL Beautifier, you can format your SQL through a user-defined set of rules. This feature will increase your coding productivity and will improve the readability of your SQL code.


Smart Code/Word completion support
Experience a quick way in constructing SQL statements in SQL Editor with the code/word completion feature. Whether you want to select available properties of database objects or SQL keywords, all it takes is a pick from the drop-down list.


Support of standard editing features
Indent and outdent, show line numbers, convert cases, zoom in/out and more.



Code Folding
Code Folding lets you collapse (hide) and expand (show) sections of your code to make it easier to navigate and read. What you need to do is just to click the plus (+) and minus (-) signs next to the code.



Matched Brace/Bracket Highlighting
when you place the cursor just after a closing (or just before an opening) brace, bracket, or parenthesis. Navicat will try to locate its matching brace, bracket, or parenthesis and highlight their companion with pre-defined colour.


Diversified Import and Export Competence

Import data from ODBC
You can import data from ODBC after setting up a data source connection. All available tables will be included if connection success. Just simply choose the tables you wish to import or specify a query using Add Query button.


Import data from up to 18 most popular formats including MS Access, MS Excel, XML, PDF and TXT
Import Wizard allows you to import data into a table from diverse format. On top of that, you can save your settings as an import profile for setting schedule.



Export data to MS Access, MS Excel, MS Word, HTML, PDF, TXT, CSV, DBF, XML, etc
Likewise, Export Wizard allows you to export data into various format. Save your settings as an export profile for setting schedule.


Powerful Data Manipulation Tools

Form View
Manipulate the current record with Form View. Enjoy a clear display of field name and its value with focus on current record.



Support of Foreign Key Data Selection
With the GUI tool - Foreign Key Data Selection, you can locate the foreign key values from the reference table. Stop shifting the view to a master table to look for the available values!


Data and Structure Synchronization
You can transfer data from one database to another with detailed analytical process. Likewise, you can compare and modify the table structures. For both Data and Structure Synchronization, the target database can be on the same server as the source or on another server.


Support of Backup and Restore for MySQL/SQLite/PostgreSQL databases
Regular backup on database is important to users. Backup/restore all tables and records, views etc for your databases using Navicat. You can also schedule backups between databases.



Powerful Security Management

Visual User/Role Manager
Navicat provides users a visual tool for user/role management. You can easily add, duplicate, delete users/roles, and edit global user/roles privileges.



Visual Privilege Manager
Having assistance with our Privilege Manager, you will get a clear view as well as a quick access to grand privileges both at system and object levels for the selected account.


Easy-to-Use Report Builder *only available in Windows Enterprise Version

Create reports with visual Report Builder
Create different types of reports with our user-friendly GUI Report Builder. Design reports for Invoice, Statistics, Mailing Labels and more.



Export reports to multiple formats, PDF, Excel, HTML etc.
Enjoy more output formats for report export - text, pdf, Lotus, Excel, Graphic, Html and more. Check out the feature in Report Builder included in Navicat Enterprise Version.



View and share reports with others by using Report Viewer
Navicat Report Viewer allows you to navigate reports designed by Navicat Report Builder. The coolest thing about it is that you can share reports with someone who does not have Navicat running on his computer but has Navicat Report Viewer installed.



Report Archive
Navicat allows you to save reports as an archive file (.raf) for backup and increased portability.



More Great Features

Server Monitor
Select the servers that you want to monitor by checking them in the checklist box of the Server Monitor Window. Click on either Process List, Variables or Status Tab to show and/or modify the properties of your servers.



Connection Coloring
With Connection Coloring feature, you can immediately know which server you are connected to. It includes a colored strip indicator shown on the sub-window toolbar for identifying connections and their database objects.



Favorites
Navicat makes it easy for you to return to a particular database object you visit often within easy reach. By adding paths to your favorites list, you can go to those database objects with a single click, instead of having to navigate the connection and databases in Navicat.



Object Filter
If you want to narrow the list of database objects displayed in Navicat, why don't you try our Object Filtering feature. Type in text, and only those database objects that start with the specified string are shown.



Virtual Grouping
Have a better organization over connection and objects in Navicat. You can categorize objects into groups with the Virtual Grouping feature.



Support of Increment Search
Incremental Search allows you to perform a find, instead of waiting for the complete search string to be entered it will search for the closest match as the string is typed, reposition (caret) to the found string as it is typed. In other words, the matched text is found and highlighted instantly. This saves your time from typing the entire text.



Text/Hex/Image Viewer
Navicat provides Text/Hex/Image Viewer and Editor to view/edit text and image field contents. The editor allows you to view, update, insert or delete data in a table.



SQL Console
To use a command-line interface, you can open SQL Console in Navicat. It provides you an interactive text-based screen to query input and result output from database.