Old versionsSee all
** The No.1 Multiple Database Management GUI **
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. It also contains many advanced features like Data Modeling Tool, Import and Export, Debugger, Visual Query Builder, Data Transfer, Data and Structure Synchronization and Batch Job Scheduling.
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.
- Powerful Visual Database Designer
Data Modeling Tool allows you to create graphical representations of a relational database. The Reverse Engineer feature enables you to create a database model from an existing database and graphically visualize and edit the structure of the database. Or, you can graphically create a model, and generate a database that supports the model.
In addition to creating model from database, Navicat Data Modeling also allows you to compare and synchronize between Models and Databases and generate SQL/ DDL scripts.
- Advanced Oracle/SQL Server Management Tools
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.
- Excellent visual and text tools for query building
Visual Builder allows you to build complicated queries without any knowledge of SQL syntax. You can also 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.
- Impressive data export and import capabilities
Navicat Premium provides a robust set of features to insert new data into your database or extract data from it using a variety of formats to suit your purposes. You can import data into your databases from up to 5 most popular formats including XLS, XML, CSV, TXT and DBF to create new tables or update existing tables in your database. It also gives you complete control over the source data selected for export, allowing you to fine tune the content of the output with special refinement options for each format.
- Powerful data manipulation tools
Advanced data transferring feature brings you a new level of reliability in transferring data across various database systems. Moreover, Naivcat synchronization tools provide the ability for data in different databases to be kept up-to-date so that each repository contains the same information.
Other useful features:
- ER Diagram View
- Backing up and restoring database
- Setting schedules
- Privilege manager
- Form view
- Text/Hex/Image viewer and editor
- SQL Beautifier/Minifier
- Connection coloring
- Virtual grouping
- Database Wide Search
- Object Filter