Custom history data retention

Unfortunately, you cannot configure a history table to automatically move data to some other table or repository according to a user-defined retention policy. That means that you have to implement this kind of data retention manually. This is not very complicated, but it is not a trivial action. I expected it as a part of the implementation and would be disappointed if this was not delivered in the next SQL Server version. As mentioned, you can use some other SQL Server features to implement data retention for history tables:

  • Stretch databases allow you to move entire parts of historical data transparently to Azure.
  • Partitioning history tables allows you to easily truncate the oldest historical data by implementing the sliding window approach.
  • Custom Cleanup doesn't require any other features. You use Transact-SQL scripts to convert a temporal table to non-temporal, delete old data, and convert the table back to a temporal table.
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.133.142.2