New feature: Temporal table support
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.
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.
