Data sync between prod and subprod instances

[Dheeraj Pology]

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?

[Tony Chatfield1]

Hi, can you clarify why you need to sync data between production and sub-production?
Normal best practice would be to maintain data in Production, coping the minimum of required records to sub-production when needed for development\testing but otherwise I would not expect to keep production data in a sub-prod instance. Normally in this scenario XML is used to ensure any record inserted into sub-production has the same sys_id and record values as the Prod record.

[Dheeraj Pology]

A client has a special requirement where they need the same whole data from Prod in one of their subprod which sync after every change. This is to test their application performance.

[Tony Chatfield1]

Hi, sub-production instances may not be running on same specification hardware as production, and a sub-production instance will not have the same number of platform nodes as a production instance. In my experience this combined with the instance usage makes the results of any performance tests subject to interpretation.

If you need to replicate large numbers of tables then I would look at one of the instance replication solutions, either from ServiceNow or one of the store vendors, but if you only need to replicate a few tables I would simply use after insert\update BR's in prod to trigger REST Post or Patch messages.