NaviCat Premium

Print
Navicat Premium is a multi-connections database administration tool
NaviCat_Premium__5347d3397684e.pngNaviCat_Premium__5347d3397684e.png
Description

Navicat Premium

Navicat Premium is a multi-connections database administration tool allowing you to connect to MySQL, MariaDB, 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, MariaDB,
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. Also, 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.
System Requirements
Windows Mac Linux
  • Microsoft Windows XP SP2, Vista, Windows 7, Windows 8,
    Server 2003, Server 2008, Server 2012
  • Mac OS X 10.6 Snow Leopard, 10.7 Lion, 10.8 Mountain Lion or 10.9 Mavericks
  • Intel CPU
  • 32-bit and 64-bit Linux platform
  • Linux kernel version 2.2 or higher
  • Glibc 2.4 or above
  • GNOME and KDE
Secure Connection
Establish a secure SSH session through SSH Tunneling in Navicat. You can enjoy a strong authentication and secure
encrypted communications between two hosts. The authentication method can use a password or public / private key
pair. And, 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.
Object Designer
You can create, modify and design database objects using our professional object designers. Object designer is available
for all database objects such as Tables, Views, Functions/Procedures, Indexes, Triggers and Sequences. Your design work
will get easier and efficient, because you don’t need to write complex SQL to create/edit the objects and you’ll know exactly
what options you are working on.
You can create, modify and design database objects using our professional object designers. Object designer is available
for all database objects such as Tables, Views, Functions/Procedures, Indexes, Triggers and Sequences. Your design work
will get easier and efficient, because you don’t need to write complex SQL to create/edit the objects and you’ll know exactly
what options you are working on.
Table Viewer
Grid/Form view
You can add, modify and delete records using Grid view. It is similar to a spreadsheet, where each column represents a field
and each row represents a record. You can easily navigate the grid view that has thousands of records using our build-in
features like sorting and hiding columns in the view, or using our assistant editors like memo, hex, image and more. Also,
you can manipulate the current record with Form view. Enjoy a clear display of field name and its value with focus on current record.
You can add, modify and delete records using Grid view. It is similar to a spreadsheet, where each column represents a field
and each row represents a record. You can easily navigate the grid view that has thousands of records using our build-in
features like sorting and hiding columns in the view, or using our assistant editors like memo, hex, image and more. Also,
you can manipulate the current record with Form view. Enjoy a clear display of field name and its value with focus on
current record.
Foreign key data selection
Navicat uses the foreign key relationships in your database to automatically hook up lookup tables referenced by foreign keys
and create the dropdown lists on your behalf. So, you can locate the foreign key values from the reference table easily. Stop
shifting the view to a master table to look for the available values.
Navicat uses the foreign key relationships in your database to automatically hook up lookup tables referenced by foreign keys
and create the dropdown lists on your behalf. So, you can locate the foreign key values from the reference table easily.
Stop shifting the view to a master table to look for the available values.
SQL Builder/Editor
SQL Builder
Visual SQL Builder allows you to create and edit queries/views visually without having to learn the syntax and proper usage
of commands. It is divided into two portions: the upper Graphical View, and the lower Syntax View. You just have to choose
the operation you would like to perform over the tables, and it will write the SQL statements for you. And, you can set query
parameters to add variable values to a query each time you run it too.
Visual SQL Builder allows you to create and edit queries/views visually without having to learn the syntax and proper usage
of commands. It is divided into two portions: the upper Graphical View, and the lower Syntax View. You just have to
choose the operation you would like to perform over the tables, and it will write the SQL statements for you. And, you can
set query parameters to add variable values to a query each time you run it too.
Code completion
Experience a quick way in constructing SQL statements in SQL Editor with our code 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.
Experience a quick way in constructing SQL statements in SQL Editor with our code 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.
Database Designer
Reverse engineering
With the Reverse Engineer in Navicat, you can create a database model from an existing database and graphically visualize and
edit the structure of your database. Or, you can graphically create a model, and generate a database that supports your model.
With the Reverse Engineer in Navicat, you can create a database model from an existing database and graphically visualize
and edit the structure of your database. Or, you can graphically create a model, and generate a database that supports your
model.
Forward engineering and script generation
Synchronize to Database delivers you the full picture of all databases differences. Once your databases are compared, you
can view the differences and generate the necessary synchronization script to update the destination database and make it
identical to your model. Flexible comparison and synchronization settings will enable you to set up a customized comparison
key for comparison and for synchronization. Also, Export SQL gives you the opportunity to get a full control over the final
SQL script, generate individual parts of your model, generate referential integrity rules, comments, character set etc. It may
save you hundreds of hours of your work.
Synchronize to Database delivers you the full picture of all databases differences. Once your databases are compared, you can
view the differences and generate the necessary synchronization script to update the destination database and make it identical
to your model. Flexible comparison and synchronization settings will enable you to set up a customized comparison key for
comparison and for synchronization. Also, Export SQL gives you the opportunity to get a full control over the final SQL script,
generate individual parts of your model, generate referential integrity rules, comments, character set etc. It may save you
hundreds of hours of your work.
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.

Manufacturer News

Manufacturer News

Support Center

For technical support email or call us on:

5 Best Sellers