Temporal table support for SQL Source control

I'm working with temporal tables in SQL server 2016 and using SQL Source control.
I've added indexes to the temporal tables, but they are not showing up in the change history and so I can't commit them.

Any plans to fix this ?

Best Answers


  • Hi @valthordruzin which version of SQL Source Control are you using? If you're not on the latest version (6.0.2) I'd suggest trying to update and see if that solves your problem.
  • valthordruzinvalthordruzin Posts: 9 Bronze 1
    edited November 1, 2017 5:47PM
    I'm running version and this doesn't show up.

    Interestingly, when I use sql compare to compare a database _with_ the indexes on the temporal tables to a repository which does not have indexes on the temporal tables, it claims that the tables are identical, even though they are not. If I click on the parent table which compare says is 'identical' the difference is clearly shown ( as you can see from the attached image)
    I don't have any filters applied that could explain this, and the behaviour seems the same in both sql scompare and sql source control


  • I've raised this problem with the support team.
Sign In or Register to comment.