Navicat Premium

Navicat Premium is a Windows application for database management. All modern formats and technologies are supported. There are tools for synchronization, backup and export. There is a visual query builder that greatly simplifies their creation.

Connection

After opening the program, you need to set up a new connection to the database. To do this, the DBMS type, password, login, port and server name are requested. Connection to remote and local hosts is supported. A function of exporting the settings to a file for use on another computer is provided. Synchronization with cloud databases, which are very popular today and are used in many areas, is also fully supported.

Management

A visual query builder is built in, which makes your work much easier by eliminating the need to write complex constructs manually. Most functions are supported, including events, triggers and procedures. There is a separate scheduler for executing a set of commands on a schedule. This can be used to automate backups, for example. For important projects, backups may be required every 24 hours or more often, so a manual run is impractical. In such situations, the corresponding function is usually used. Data from individual tables can be edited and exported, and import from external sources is supported. Tools for analyzing and processing data arrays are built in. The module allows you to create charts and graphs to visually display dependencies and other information. Features:

• the application allows you to develop databases and customize them;
• work with several connections;
• a scheduler is provided;
• local and network databases are supported;
• SQL query builder;
• built-in tools for analyzing information;
• only the trial version is available free of charge.