General availability: Temporal tables in Azure SQL Database

12 Ekim 2016 Çarşamba

You can use temporal tables to track the full history of data changes directly in Azure SQL Database, without the need for custom coding. With temporal tables, you can see your data as of any point in the past and use a declarative cleanup policy to control retention for the historical data.

Use temporal tables to:

  • Perform data auditing in your applications.
  • Analyze trends or detect anomalies over time.
  • Implement a slowly changing dimension pattern.
  • Perform fine-grained row repairs at the row level, in case of accidental data errors made by humans or applications.

To get started, create system-versioned temporal tables or extend existing tables to become temporal. For more information, check out Getting Started with Temporal Tables in Azure SQL Database.

Ücretsiz hesap

$200 değerinde Azure kredisi elde edin ve popüler hizmetlerden 12 ay boyunca ücretsiz olarak yararlanın

Ücretsiz kullanmaya başlayın

Visual Studio

Aboneler yıllık $1800 tutarına kadar Azure hizmeti edinir

Şimdi etkinleştirin

Startup’lar

BizSpark programına katılıp ücretsiz Azure hizmetlerinden yararlanın

Daha fazla bilgi edinin