How to copy a system versioning table to another table without loosing the history records
I am looking for a way to make a backup of a system versioning table. COPY TABLE ... AS does not work with temporal tables so I am looking for an alternative way. Dropping the system versioning on a table drops the history records, however we want to keep the history records in order to reload them. We also have valid time on the table.