We have recently upgraded to Web8.1 from 2011, we have been following the process of taking the database backup of CM and restore to lower environments periodically to have the latest data to perform analysis or testing which cannot be done on production.
Now we have done this DB backup-restore process for first time on Web8.x and process followed is for all Tridion databases including Topology Manager and Discovery DB.
Yes, we have identified that if we restore Topology Manager and discovery databases from production to lower environments, then we cannot have it without changes after restoration. Because it has environment specific data within it.
We have reverted the Topology manager and discovery database restore but problem now is that Topology manager database has mappings as well which refers the TCM IDs from CM database. If we keep these from old version from lower environment then the TCM IDs for publications are mismatching and publishing or many other actions are not working for certain publications. (specially for publications which were created recently after the upgrade due to many publications were created on lower environments while testing)
Now that CM is on production version and topology and discovery are on lower environment version let's say QA version few things are not working, and we need to fix this.
Questions: 1. How to fix this? do I need to update the mappings or update the environment specific details on QA? 2. Is there any standard process followed for restoration of databases from production to QA specifically on or after Web 8.x and onward versions? Note: Already checked with SDL support and they do not have any standard process documented with them for this kind of process.
Thanks in advance, appreciate if someone can share their own experiences.