Hi GeoNet Community,
I’m working with two enterprise geodatabases in SQL Server and need to copy only a subset of records from a feature class in one geodatabase to another. However, I want to ensure the archived records in the source geodatabase remain intact and unaffected by the process.
I understand that when a feature class is copied over, archiving will need to be re-enabled in the target geodatabase, which means the existing archived records from the source will not be preserved in the target. Based on this, I want to know if it’s possible to preserve the source archive while copying only selected records.
Is this possible, or is there a workaround to achieve this? I’m aware that restoring the entire database to a new server would preserve the archive, but that’s not an option because the database is too large for me to want to consider restoring the whole thing. If anyone has experience with handling this task or can suggest best practices/workarounds, I’d greatly appreciate your advice.
Thank you in advance!
