I'm trying to figure out how I could sync the contents of a PostgreSQL materialized view to a Microsoft SQL Server DB. I was hoping I could convert my existing views to lazy materialized views, but there are no "BEFORE SELECT" triggers to help me achieve achieve lazy materialization on Table Select, which leaves me with the option of scheduling a materialization at the cost of stale data.
I could use an eagerly materialized view, which would allow me to keep data in a table instead of converting to a view.
I'm just looking for any hints or past experiences. I want to keep our business intelligence on the master node and replicate "crunched" data to all slaves. Thanks in advance!
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I'm trying to figure out how I could sync the contents of a PostgreSQL materialized view to a Microsoft SQL Server DB. I was hoping I could convert my existing views to lazy materialized views, but there are no "BEFORE SELECT" triggers to help me achieve achieve lazy materialization on Table Select, which leaves me with the option of scheduling a materialization at the cost of stale data.
I could use an eagerly materialized view, which would allow me to keep data in a table instead of converting to a view.
I'm just looking for any hints or past experiences. I want to keep our business intelligence on the master node and replicate "crunched" data to all slaves. Thanks in advance!
I don't think views are supported. It expects to find a table in the metadata. You can sync tables and use transformation to match the target schema.