How to Export Data from PostgreSQL to MS SQL Server Using Navicat Premium

How to Export Data from PostgreSQL to MS SQL Server Using Navicat Premium

Hello everyone, welcome to another tutorial of Navicat Premium. I do love this software. I use it pretty much to do some export and import data between database types. On this article, I am going to show you how to export data from PostgreSQL to MS SQL Server. Navicat Premium full version performs very well to do this job.

Scenario

I have a PostgreSQL database installed on a Raspberry Pi device and I want to export all the tables inside the PostgreSQL database to my MS SQL Server. For your information, I install the SQL Server on my Ubuntu 18.04 via Docker containers.

My Tools

  • PostgreSQL Server
  • SQL Server
  • Navicat Premium 12 Full Version

How to Export Data from PostgreSQL to MS SQL Server Using Navicat Premium

First, we need to create a new connection for each server. Open Navicat Premium and then go to Connections. Select PostgreSQL to create a new connection to PostgreSQL Server. Enter the PostgreSQL server details

And then do the same for MS SQL Server

After you have two connections, now we are ready to start Export Data. Go to Tools | Data Transfer. Then, configure the source and destination. In the source, we put the PostgreSQL Server connection and then in the destination, we use the SQL Server connection.

Click Next to select which tables will be exported.

export data from postgresql to ms sql server

Click Start to start the export process.

Conclusion

Navicat Premium 12 Full Version is a great tool to export and import data. It is not a paid ads but personally I am very satisfied with the performance of this software. Thank you for reading this article and see you in the next tutorials.

1

No Responses

Write a response

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