1 個回答
- 最新
- 最多得票
- 最多評論
2
Hi,
My understanding is that only changes can be propagated by DMS. Mostly because it uses the rdbms logs to capture those changes and those logs do not contain full rows but only delta.
Nonetheless, you can achieve what you want by using a sql trigger: https://www.postgresql.org/docs/current/sql-createtrigger.html
The idea is the following; the trigger with fire on any change on the row brought by a DMS change. Then this trigger selects in full (i.e. all columns as neeed) the row as change is applied. This trigger then "pushes" the full row whenever you need: write it in another table, steams it outside of pg, etc.
Hope it helps!
Didier
相關內容
- 已提問 6 個月前
- AWS 官方已更新 2 年前
- AWS 官方已更新 2 年前
- AWS 官方已更新 2 年前
but apparently when using MySQL as source there is a configuration for this in the DMS it would be (ndb_log_updated_only = OFF), is there really nothing to be done in the DMS itself?