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.
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.