I have data in a Microsoft SQL Server that needs to be migrated to Postgres. The problem is that the SQL Server gets continuous updates and is hosted on our local net, while the Postgres instance is in the cloud.
What is the best way to manage this ETL process? My current approach is to just transfer over the tables we need (about 30) and then re-initialize the materialized views. I am willing to pay for a migration tool if it can fully automate the process, otherwise I'll go with the simplest solution our bandwidth can support.