How to copy view from MS SQL to PGSQL? I have a MS SQL Server running in a different country (hence VPN, hence long round trip delay) and delveloping a PowerQuery model on a view located on that MS SQL Server.
Everytime I change something in the model, it reloads the view which is consuming a lot of time.
I'd like to:


setup a local PostGreSQL Server on my Mac (done already)
mirror the MS SQL View data into a PostgreSQL Database
connect the powerQuery to the local PostgreSQL Server (easy)


I'm struggling with "2", mirror the content of a view into the PostgreSQL server without using direct SQL (TCP1433) which I cannot use.

How can I mirror the data to the PostgreSQL Server using ODBC only?

BTW: I have no direct access to the MS SQL Server apart from the ODBC connection

EDIT: If required, I can also install a MS SQL Express Edition if that helps in any way. Thanks
Yes, mirror the content of the view to a PGSQL. But never mind, I was able to do it with a local SQL express installation very easily.