I write in search of solutions since I am not very knowledgeable in the PI world and I have read many manuals but I have not been able to extract a very specific idea. In the real case we have a database in functional AF with certain elements and parent-child relationships. Particularly my interest is on a single branch of this hierarchy where all elements of type A are located with child elements that have an attribute that indicates their status. Example: We could have an element A with children B and C where B has a status attribute and it is relevant to know if B or C is active.
I need a check once a day to make a copy of these elements to my AF BD2, so that if for example in my BD I have the A element with a weak reference to another element, when making the copy -Verification on AF BD1 and find a change in A, when reflecting on AF DB2, it does not lose consistency, analysis or references to other objects.