Hi,
I wanted to create an utility which creates/copies all the newly created/update content from Production to DR environment in daily basis. We are currently using VTT for same, but VTT recommends to shut down the environment before taking the back up. This is not feasible for highly available system.
In VTT, I can see that it copies data in DB and File system. So, if I will create a procedure to:
- Copy all changes entries in DB from Production to Preproduction in last 24 hours
- Copy all files modified/created from Production to Preproduction in last 24 hours
will keep my Preproduction in sync with Production on a daily basis.
Request you to please let me know if someone have already done this kind of exercise or I am missing something here?
Many thanks,
Sanjeev