Navicat Premium (Mac OS X) 11.2.8

Advertising
Software information
Platform:
Mac OS, Other
Publisher:
PremiumSoft CyberTech Ltd
Price:
$599
File size:
97.86 Mb
Date added:
April 20, 2016
Screenshot:
Product page:
Description from the Publisher

Navicat Premium is a database administration tool that allows you to simultaneously connect to MySQL, MariaDB, SQL Server, Oracle, PostgreSQL, and SQLite databases from a single application.

Navicat Premium combines functions of other Navicat products and supports most of the features used in modern database management systems, such as Stored Procedures, Events, Triggers, Functions, Views, etc.

Navicat Premium enables you to efficiently transfer data across various database systems or to plain text files with SQL format and encoding. Batch jobs for different types of databases can be scheduled to run at a specific time. Other features include an Import/Export Wizard, Query Builder, Report Builder, Data Synchronization, Backup, Job Scheduler, and more.

Navicat provides professional developers with sophisticated features specific to their needs, but is easy to learn for users new to database servers.

Features

Navicat Cloud

Navicat provides users with our Navicat Cloud service. Sync your connection settings, models, queries and virtual groups to the cloud so you can get real-time access to them anytime, anywhere. With Navicat Cloud, you can leverage every minute of your day to maximize your productivity.

Secure Connection

Navicat allows you to establish secure SSH sessions through SSH Tunneling, ensuring strong authentication and secure encryption between two hosts. The authentication method can use a password or a public/private key pair. Navicat also comes with HTTP Tunneling, allowing you to bypass ISP restrictions on direct database server connections.

Object Designer

Create, modify, and design database objects using professional object designers, available for all database objects such as Tables, Views, Functions/Procedures, Indexes, Triggers, and Sequences. Without the need to write complex SQL to create and edit objects, you’ll know exactly what you are working on.

Table Viewer

Grid/Form view

Add, modify, and delete records using Grid View. Navigate the Grid View with spreadsheet-like features, such as sorting and hiding data groups, or use our assistant editors like memos, hexes, images, and more.
Manipulate records using the Form View. Enjoy a clear display of field names and values without constantly worrying about data misinterpretation.

Foreign key data selection

Use foreign key relationships in your database to anchor referenced lookup tables and automatically create dropdown lists. Without the need to constantly reference a master table, you can optimize your workflow and productivity.

SQL Builder/Editor

SQL Builder

Visual SQL Builder allows you to create and edit queries/views without having to worry about syntax and proper usage of commands. Just choose the operation you would like to perform on the tables, and it will write the SQL statements for you.

Code completion

Quickly construct SQL statements in the SQL Editor with our code completion feature. Whether you want to select properties of database objects or SQL keywords, all it takes is a pick from the drop-down list.

Database Designer

Reverse engineering

Create a database model from an existing database using Navicat’s Reverse Engineer. Visualize and edit the structure of your database or create a graphic model and generate a database that supports it.

Forward engineering and script generation

Database Synchronization delivers a full picture of database differences. Generate the necessary synchronization script to update destination databases and make it identical to your model.

Export SQL gives you full control over the final SQL script, generating referential integrity rules, individual parts of your model, comments, character sets, and more, saving you hundreds of hours of work.

PL/SQL Code Debugger

PL/SQL Debugger offers features such as setting breakpoints, stepping through the program, viewing and modifying variable values, and examining the call stack. Debug PL/SQL code such as procedures and functions, object methods, and triggers directly from the Navicat workspace.

Data Manipulation Tools

Import/Export Wizard

Import data into a table from diverse formats such as Access, Excel, XML, TXT, CSV, JSON, and more. Import data from ODBC after setting up a data source connection. Simply choose the tables you wish to import or specify a query using the Add Query button. Likewise, you can export data into various formats such as, Excel, TXT, CSV, DBF, XML, etc.

Data Transfer

Effortlessly transfer data across various DBMS – MySQL, MariaDB, SQL Server, Oracle, PostgreSQL, and SQLite. You can also export data as an SQL file with designated SQL formatting and encoding. This feature drastically simplifies the process for data migration.

Data/Structure Synchronization

Transfer data from one database to another with a 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 source server or on another server.

Backup/Restore

Regular backup of databases important to you. Backup/restore all tables, records, views, etc. Rest easy knowing that data corruption won't undo all your work.

Schedule

Profiles from different types of databases can be created in a single batch job that you can schedule to run at a specific time. Batch jobs can be created for Report Printing, Database Backup, Query, Data Transfer, Data Synchronization, Import and Export. Navicat can automatically send notification e-mails to specified recipients upon task completion. Share data easily with automatic mail attachment of exported files or printed reports.

PL/SQL Debugger offers features such as setting breakpoints, stepping through the program, viewing and modifying variable values, and examining the call stack. Debug PL/SQL code such as procedures and functions, object methods, and triggers directly from the Navicat workspace.

Data Manipulation Tools

Import/Export Wizard

Import data into a table from diverse formats such as Access, Excel, XML, TXT, CSV, JSON, and more. Import data from ODBC after setting up a data source connection. Simply choose the tables you wish to import or specify a query using the Add Query button. Likewise, you can export data into various formats such as, Excel, TXT, CSV, DBF, XML, etc.

Data Transfer

Effortlessly transfer data across various DBMS – MySQL, MariaDB, SQL Server, Oracle, PostgreSQL, and SQLite. You can also export data as an SQL file with designated SQL formatting and encoding. This feature drastically simplifies the process for data migration.

Data/Structure Synchronization

Transfer data from one database to another with a 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 source server or on another server.

Backup/Restore

Regular backup of databases important to you. Backup/restore all tables, records, views, etc. Rest easy knowing that data corruption won't undo all your work.

Schedule

Profiles from different types of databases can be created in a single batch job that you can schedule to run at a specific time. Batch jobs can be created for Report Printing, Database Backup, Query, Data Transfer, Data Synchronization, Import and Export. Navicat can automatically send notification e-mails to specified recipients upon task completion. Share data easily with automatic mail attachment of exported files or printed reports.

Users reviews & testimonials

This software is not reviewed yet.

Advertising
Other downloads from this publisher

Navicat Data Modeler Essentials is a compact version of Navicat Data Modeler which helps developer build high-quality logical and physical data models. It can simplify the task of creating complex entity relationship models and generate the script SQL with a simple click.

Navicat Premium is a diverse database management tool for developer to concurrently connect to MySQL, MariaDB, SQL Server, Oracle, PostgreSQL, and SQLite databases from a single application. It provides sophisticated features to meet the user needs and take into account of new operators.

Navicat Data Modeler Essentials is a compact version of Navicat Data Modeler which helps developer build high-quality logical and physical data models. It can simplify the task of creating complex entity relationship models and generate the script SQL with a simple click.

Navicat Data Modeler Essentials is a compact version of Navicat Data Modeler which helps developer build high-quality logical and physical data models. It can simplify the task of creating complex entity relationship models and generate the script SQL with a simple click.

Navicat Data Modeler is a cost-effective database design tool which helps you build high-quality conceptual, logical and physical data models. It allows you to visually design database structures, perform reverse/forward engineering processes, etc.