Now available in preview, you can use temporal tables in all service tiers of Azure SQL Database. Temporal tables are a productivity tool for developing applications that aim to provide insights from historical data. Temporal tables allow you to track the full history of changes in critical data directly in Azure SQL Database, without the need for custom coding. You can efficiently focus business analysis on a specific point-in-time.
Use temporal tables to:
- Add data auditing capability to your applications.
- Version data to analyze trends or detect anomalies over time.
- Perform fine-grained repairs if there is an accidental corruption made by humans or applications.
To get started, create new system-versioned temporal tables in your database or extend existing tables to become temporal.
For more information, check out Getting Started with Temporal Tables in Azure SQL Database