From Postgres to SQL - Data movement

Hi All,

Is there any way to get the data from Postgres and import the data in SQL.

In Postgress (PgAdmin) I have a table : This is Source Table : From here I would like to take the data and that has to be placed in SQL DB-Table .

This activity should trigger every day in the evening...
or as and when data is refreshed in postgress . latest data has to be taken from it and it has to be loaded in SQL

Any way to automate this job ?


if your destination is MIcrosoft SQL Server

you can create Linked Servers in SSMS ( sql server management studio )

then a job in SSMS ( sql server management studio ) you will have options to schedule it