Updating data to support test environments

Wondering if anyone has a great way to add diff data (just metadata, not files) from PROD environment to TEST environment that can be set up as a weekly job.  Anyone tackle this (KEITH R.) with any success?  Would like to share notes.

Agile Angel Asked on April 9, 2019 in IT and Networking.
Add Comment
2 Answer(s)
Best answer

I imagine a dmp file creation and load could be automated between the environments. It would be a handful of scripts to run the full dmp sync. Synchronizing the attachments would be easier, honestly, with rsync/Robocopy.

Agile Angel Answered on April 9, 2019.

Sounds good Keith.. sorry I couldn’t spend more time on the phone the other day speaking through this but it sounds like a solid plan.

on April 11, 2019.
Add Comment

Hi Patrick

  I would agree with Keith. Since new objects can also be created in Test, you are now looking at a merge tool rather than a diff which would make it very complicated

  On an adhoc basis, we do the refreshes from Prod. We use a combination of ACP export/import to preserve parts of Admin settings (ACS, IT user roles, etc) and DB scripts to update URLs to our custom apps. We also do a diff of new files added since prior run. Instead of copying actual files from prod, we replace it with dummy files

– Raj

Agile Angel Answered on April 9, 2019.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.