General availability: Temporal tables in Azure SQL Database

2016년 10월 12일 수요일

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.

무료 계정

지금 등록하여 $200 Azure 크레딧을 받으세요.

무료로 시작

Visual Studio

최대 $1800 연간 Azure 서비스를 구독자에게 제공

지금 활성화

시작

BizSpark 프로그램에 가입하고 무료 Azure 서비스를 이용하세요

자세한 정보