Do you have a comment or suggestion to improve SQL Server? We’d love to hear it!

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.

12 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    AdminMicrosoft SQL Server (Admin, Microsoft Azure) shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    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.

    1 comment

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • Anonymous commented  ·   ·  Flag as inappropriate

        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.

      Feedback and Knowledge Base