In this article you will learn how to distinguish temporal tables in Azure SQL Database.
In this article I am going to provide more details about temporal tables that were recently launched by Microsoft Azure Preview: Temporal tables in Azure SQL Database. Earlier, when developers wanted to search or track the history of a database they needed to write some custom code, but this new feature, temporal tables, will allow you to figure out the full history of your database without any custom code. What are Temporal Tables? As mentioned above this is a new feature that helps you to figure out all the history of your database. Now please note that every temporal table has two explicitly defined columns, each with a datetime2 data type. These columns are referred to as period columns. These period columns are used exclusively by the system to record period of validity for each row whenever a row is modified. Other than this, temporal tables also contain a reference to another table with a mirrored schema. Please follow Temporal Tables by MSDN for more details. Advantage of Temporal tables:
Ways to implement Temporal tables: There are two terms we can discuss as a basic user. The first time if you are going to create a brand new application and you want to implement data auditing in your applications, and secondly is if the customer has an existing working app and wants to check data history. Below are the approaches.
Azure Web Apps for Developers