Does anyone with Pro 3.5 know if the new Append To Existing tool can handle relationship classes? Or has the unmanaged behavior been changed?
I posted to this blog but have not heard anything. https://www.esri.com/arcgis-blog/products/arcgis-pro/analytics/overwrite-options-arcgis-pro
My post
Will this properly handle relationship classes? I have had this issue for years when we need to swap out the records of a parent table. Even though our relationship classes are set to “Unmanaged” Arc will still set all the child keys to null on me if a delete the parent! This is not what I would expect from an “Unmanaged” relate. Will this new tool have a way around this? If not when the delete fires all the child record keys get set to null and then there is no way to tell them apart anymore.
Preferably “Unmanaged” relates get changed to be truly unmanaged, but if not, this tool should have a way around this. Esp when we have replication going it gets hard. It is also hard since we have 15-20 relates off the parent. It can take hours to delete since it goes and touches every single child.
BTW the way I have been getting around this the last few years by doing this - First calculate all the parent keys to the word Delete. Then replicate if you have a replica. Then finally delete the records. This way when it goes hunting for children it finds none.
thanks for any advice here
