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 ?
Tagged:

Best Answers

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 6.0.2.6908 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

    ebekao6zr77z.png
    hb5l1vyfabwv.png
    y83tatt0gydy.png

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