Navicat Premium is a set of database management tools that, together with other Navicat members, supports simultaneous connections to MySQL, MariaDB, SQL Server, SQLite, Oracle, and PostgreSQL databases. This tutorial will explain the basics of how to use Navicat Premium.

Navicat Premium 15 For Mac

Connecting to the database

  • When Navicat Premium is installed, you can start the Navicat program. In the upper left corner of the navigation window, click the “Connect” button. When clicked, a dialog box will be displayed indicating the connection properties. If you want to manage a remote database, enter the correct IP address in the IP address box.
  • Navicat also supports SECURE Sockets Layer (SSL) or Secure Shell (SSH) connections. After a successful connection, you will see all MySQL databases on your host in the navigation window on the left. Right-click on a gray database, in the right-click menu contains open, close, new, delete and data transfer, management user commands.

Import data – Import an Excel file into the database

  • Run the “Import Wizard”, select the type of data to import, select the table type: Excel file;
  • Select the data source, that is, select the location of the Excel file to be imported.
  • Select the table you want to import and define some additional options for the source;
  • Select the target table or create a new table.
  • Define the mapping between the source field and the target field. If the primary key is set for the target field, it must be selected in this step; otherwise, data cannot be imported normally.
  • Select the import mode, click “Start” button to execute the import command, after the import is complete, there will be a [Msg] message prompt.

Export data

  • Click the “Export Wizard” command, select the table type: Excel file,
  • Select a location to store the exported table.
  • Click the “Select All” drop-down button, select the location to save the exported table, such as “Export to the same file” to save the exported Excel table to an appropriate location, such as “Desktop”;
  • Select the fields (columns) that you want to export. By default, all fields are selected.
  • Define additional options, and the export is complete.