Skip to main content
IN PREVIEW

Preview: Temporal tables in Azure SQL Database

Published date: 22 February, 2016
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.
  • Azure SQL Database