How to organize one-way synchronization from MS SQL 2014 to PostgreSQL?

Question

SQL

there is a 1C database in MS SQL 2014 (not express), which stores product data (characteristics, photos, available quantity, prices), there is a remote server on linux + PostgreSQL, how you can dynamically replicate data from MS SQL to PostgreSQL?
Clarification: photo files are stored separately in the FS, only links in the database.

Answer 1

You create a linked server, then in the studio you create a task for synchronization.
https://www.mssqltips.com/sqlservertip/3662/sql-se...
There are other options. If you need, contact me on Skype vladimir-korotenko I will help
you set up import export.

Answer 2

Look towards FDW
https://github.com/tds-fdw/tds_fdw