How can we help you today? How can we help you today?

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 ?
Valthor
0

Comments

5 comments

Sort by
  • Diogo
    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.
    Diogo
    0
  • valthordruzin
    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

    valthordruzin
    0
  • Diogo
    I've raised this problem with the support team.
    Diogo
    0
  • Tianjiao_Li
    Hi @valthordruzin

    Thanks for reporting it! It happens when compare live database to script folder. We've logged a bug for it and please keep an eye on the release note!
    Tianjiao_Li
    0
  • Tianjiao_Li
    Hi @valthordruzin ,

    Thanks for your patience and I'm pleased to let you know this bug is fixed in version 6.0.7. Please upgrade and let us know if you have more questions!
    Tianjiao_Li
    0

Add comment

Please sign in to leave a comment.