Copy Changes on Certain Tables Down to Sub-Environments Daily

[jmiskey]

We currently clone down from our Prod to our sub-environments (Test and Dev) about once a quarter.  We have frequent updates to the following tables in Production:

- sys_user

- sys_user_group

- sys_user_grmember

- sys_group_has_role

- sys_user_has_ role

A lot of these updates are needed in the lower environments (especially Test) for testing purposes.  We are trying to figure out a way if we we could automatically capture the daily changes/updates from Prod, and push them down to the lower environments.  I know how to do it manually.  Simply query each of those tables on "Updated" field to identify just the recent changes, export them to an XML file, and then manually import them into the other environments.  But would like to figure out a way to automate this process.

We thought there might be a way to simply "clone" those 5 tables (and nothing else), but after we thought about it, determined that is not a good idea.  That is because there may also be changes "bubbling up" from Dev that would be creating things like new groups and service accounts that are not in Prod yet.  So we would not want to lose them.  That is why we were thinking we would need to do a "delta" file, of recent changes only, coming down from Prod to be loaded in Dev and Test.

Has anyone done anything like this?  Any suggestions on how we may be able to do this?

Thanks

[Dr Atul G- LNG]

Hi @jmiskey 

Sorry, but  I did not work on this, so to give you wrong answer, request you have a lokk here:

https://www.youtube.com/watch?v=C7IesKIzyig

[Mark Manders]

Check on the licensing for it, because I looked into this a while back and it wasn't worth the cost, although it's the best solution for your requirement.