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.
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.
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
