Data sync between prod and subprod instances

Dheeraj Pology
Tera Contributor

How can I sync table data from Prod to subprod instances automatically for inserts, updates or deletes?

I understand that IDR used for two separate prod instances - is this correct? Are there any other methods?