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