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