data-konzept

'If you are looking for a way to track the history of all the data changes to a table then SQL Server 2016 has you covered with the new temporal table support. With Temporal tables SQL Server is able to store all the older data records into in a history table while keeping the current records in the original table.  In this article I will explore using the temporal table feature of SQL Server 2016 to create a history table for an existing SQL Server table.'...

http://www.databasejournal.com/features/mssql/altering-an-existing-table-to-support-temporal-data.html