How to Transfer data from MySQL to PostgreSQL using Navicat Premium 12

How to Transfer data from MySQL to PostgreSQL using Navicat Premium 12

Do you ever think that there is an easy way to transfer data from MySQL to PostgreSQL and vice versa? Well, today I am going to show you how to transfer data from MySQL to PostgreSQL using Navicat Premium 12. This scenario maybe not happen on an everyday basis. But, as a database administrator, I have to prepare and learn this. Navicat Premium is truly my savior. It is a powerful, stable and reliable tool to manage databases. Today I am going to show you that migrate data from MySQL to PostgreSQL is super duper easy.

What we will learn

  • Connect to MySQL Server
  • Connect to PostgreSQL Server
  • Migrate data from MySQL to PostgreSQL

Before we start, you may want to download Navicat PremiumĀ 12. Get the free 14 days trial before purchase the Navicat Premium 12 Full Version. Lets get started.

How to Transfer data from MySQL to PostgreSQL using Navicat Premium 12 Full Version

Step 1. Connect to MySQL Server

Open Navicat Premium and then go to Connect | MySQL. Enter the MySQL Server credentials here. Also, make sure that you can connect to the server by testing the connection.

Step 2. Connect to PostgreSQL Server

After you have successfully connected to the MySQL server (source), now we need to connect to the PostgreSQL Server as the destination. Do the same as the previous steps but instead of MySQL, choose PostgreSQL from the database type.

So now, we have two connections: MySQL and PostgreSQL. Lets continue to the next steps.

Step 3. Data Transfer

Go to Tool | Data Transfer to open the data transfer wizard. Here we need to specify the source database and destination/target database. On the following window, select the source and target connection. As you can see, I want to transfer data from Mysql-server (MySQL) to raspberry (PostgeSQL). Select which database to transfer from the list.

Next, select the database objects to transfer. You can select more than one tables/objects at once.

transfer data from mysql to postgresql

Press Start to start the transfer process

Make sure there are no errors. And that’s it, we have just successfully transferred data from a MySQL database to PostgreSQL database using Navicat Premium 12 full version.

2

No Responses

Write a response

This site uses Akismet to reduce spam. Learn how your comment data is processed.