1 Resposta
- Mais recentes
- Mais votos
- Mais comentários
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
Conteúdo relevante
- AWS OFICIALAtualizada há 2 anos
- AWS OFICIALAtualizada há 2 meses
- AWS OFICIALAtualizada há 2 anos
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?