Options

New feature: Temporal table support

Andrew FAndrew F Posts: 21
edited March 22, 2017 1:24PM in SQL Compare
SQL Compare 12.2 introduced support for Temporal Tables, a SQL Server 2016 feature that allows database tables to record point-in-time information as well as the current values for each row. This makes it possible to query the historical values of any record in the table. Temporal tables described here:

Temporal tables on MSDN

SQL Compare now recognises temporal tables in your databases and will deploy the necessary GENERATED ALWAYS columns, PERIOD FOR SYSTEM_TIME declarations and SYSTEM_VERSIONING statements as required.

For a more detailed description of this new feature in SQL Compare, read our blog post.

We'd like to hear your feedback on this feature and any ways in which it could be improved.
Sign In or Register to comment.