I wanted to implement a data archiving solution.
Main table and the table to be archived will be two columns in a configuration table.
I would like to archive the data from main table(MainTbl) to archive table(ArchiveTbl), but archive table will have some additional fields (Archive ID, updated date, Updated User).
How can I achieve this dynamically as configuration table will have more tables to be archived.
Thanks,