Navicat Premium 12.1.26

Navicat Premium is an all-in-one database admin and migration tool for MySQL, SQL Server, Oracle and PostgreSQL.

Navicat Premium combines all Navicat versions in an ultimate version and can connect MySQL, Oracle and PostgreSQL. Navicat Premium allows user to drag and drop tables and data from Oracle to MySQL, PostgreSQL to MySQL, Oracle to PostgreSQL and vice versa within a single client. Also, batch jobs for different databases such as print report in MySQL, backup data in Oracle and synchronize data in PostgreSQL can also be scheduled and automated to run at a specific time. All in all, Navicat Premium can help database users to save lots of time to manage multiple databases and perform cross database data migration at their fingertips.

This Database Client tool runs on Mac OS X and features an intuitive interface. Other advanced features including Backup/ Restore, Data Import/ Export, Data Synchronization, Reporting and Remote Connection to MySQL, PostgreSQL and Oracle server, etc. This database migration tool provides a friendly step-by-step Wizard-GUI. All you want to do is: select a data source and a target output format, then submit migration!

Features

Seamless Data Migration

Data Transfer, Data Synchronization and Structure Synchronization help you migrate your data easier and faster for less overhead. Deliver detailed, step-by-step guidelines for transferring data across various DBMS. Compare and synchronize databases with Data and Structure Synchronization. Set up and deploy the comparisons in seconds, and get the detailed script to specify the changes you want to execute.

Diversified Manipulation Tool

Use Import Wizard to transfer data into a database from diverse formats, or from ODBC after setting up a data source connection. Export data from tables/collections, views, or query results to formats such as Excel, Access, CSV and more. Add, modify, and delete records with our built-in editors, you can facilitate your edits in Tree View, JSON View, and the classic spreadsheet-like Grid View. Navicat gives you the tools you need to manage your data efficiently and ensure a smooth process.

Easy SQL/Query Editing

Visual SQL/Query Builder will help you create, edit and run SQL statements/queries without having to worry about syntax and proper usage of commands. Code fast with Code Completion and customizable Code Snippet by getting suggestions for keywords and stripping the repetition from coding. Quickly locate and correct PL/SQL and PL/PGSQL coding errors using our debugging component such as setting breakpoints, stepping through the program, viewing and modifying variable values, and examining the call stack.

Intelligent Database Designer

Create, modify and manage all database objects using our professional object designers. Convert your databases into graphical representations using a sophisticated database design and modeling tool so you can model, create, and understand complex databases with ease.

Increase Your Productivity

Our powerful local backup/restore solution and intuitive GUI for MongoDump, Oracle Data Pump and SQL Server Backup Utility guides you through the backup process and reduces the potential for errors. Set an automation for repeatable deployment process like database backup, MapReduce job and script execution at a specific time or day. No matter where you are, you can always get the job done.

Smart Schema Analyzer

Discover and explore your MongoDB schema with our built-in schema visualization tool. Analyze your documents and displays rich structures within your collections, so you can understand your data’s schema, find schema anomalies, and inspect outliers easily.

Make Collaboration Easy

Synchronize your connection settings, models, queries and virtual groups to our Navicat Cloud service so you can get real-time access to them, and share them with your coworkers anytime and anywhere. With Navicat Cloud, you can leverage every minute of your day to maximize your productivity. Learn more >

Advanced Secure Connection

Establish secure connections through SSH Tunneling and SSL ensure every connection is secure, stable, and reliable. Support different authentication methods of database servers such as PAM authentication for MySQL and MariaDB, Kerberos and X.509 authentication for MongoDB, and GSSAPI authentication for PostgreSQL. Navicat 12 provides more authentication mechanisms and high-performance environments so you never have to worry about connecting over an insecure network.

What’s New in Navicat Premium 12.1.26

• Release notes not available at the time of this post.

Screenshots