Add Application-period temporal tables and Bitemporal tables to SQL Server 2016
SQL Server 2016 has temporal tables however these are only for system period temporal tables.
Please add Application-period temporal tables and Bitemporal tables similar to the existing feature in DB2.
Upvotes: 29<=-=Jul 27 2016 5:17PM=-=>
This feature vastly simplifies development of certain types of applications. Would be interesting at least know if microsoft has some intention to implement it.<=-=Jul 27 2016 5:19PM=-=>
A fully compliant implementation to ansi sql 2011 would nice too.<=-=Jul 28 2016 1:01AM=-=>
I would also like to see bitemporal support added, it would be most useful!<=-=Mar 7 2017 11:54AM=-=>
This feature would really help people trying to migrate their DBs from DB2 or Oracle to SQL Server that much easier.