How to organize daily copying of data from PostgreSQL to SQL Server?

Question

PostgreSQL

It is necessary to execute a query to the PostgreSQL DBMS on a daily basis and save the result of the query to a MS SQL DBMS table. The databases are on different servers. Question for the connoisseurs. How to properly organize this process?
The first thing that comes to mind. It to make means MS SQL. You can probably link servers. And run the job. I don't know how this is possible and whether the linking will fall off.
Or write a service on the MS SQL server side that will query PostgreSQL. Or a console application and run it on the scheduler.
Or maybe there is a ready-made solution that has been tested by time.
I want to do it correctly so that it always works without failures. And it was designed to copy several thousand lines at a time and did it not very slowly. And maybe even with logs.

Answer 1

https://docs.microsoft.com/en-us/sql/integration-s...