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.

No Files Were Attached
Patrick Lawrence 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.

keithrust 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

rchinnia Agile Professional Answered on April 9, 2019.
Add Comment

Your Answer

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