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.
I had rolled my own tables before and was happy to hear that MS made temporal tables a built in feature.
I don't know why they only targeted live transaction databases and left people working with non-live data out in the cold.
I really hope this one gets implemented.