Debezium one-time + full-load migration

[Feng Lei]

Hi Debezium,

I am Feng. I am quite new to Debezium. In addition to supporting continuous updates through the CDC, I don't know if Debezium also supports one-time + full-load migration.

My scenario is that I need to migrate data from a database to another place. This DB still has activities so I think Debezium is suitable for continuous incremental sync-up. But for historical data, I want to migrate them at one time using full-load mode. By adopting of Debezium, I'd love to know if Debezium additionally supports that kind.

[Chris Cranford]

Hi Feng,

Yes, the option you're looking for is called "snapshot.mode" [1], and when set to "initial_only" it will capture the existing data from the configured capture tables (i.e. the snapshot) and then stop.

Thanks,
Chris

[1]: https://debezium.io/documentation/reference/2.5/connectors/sqlserver.html#sqlserver-property-snapshot-mode

--
You received this message because you are subscribed to the Google Groups "debezium" group.
To unsubscribe from this group and stop receiving emails from it, send an email to debezium+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/debezium/f1cf2855-cc10-44c7-bd22-9b4ff30d1be9n%40googlegroups.com.

[Feng Lei]

Wow! That is great to know. Thank you! Will look into this option.