Temporal table support for SQL Source control

valthordruzin

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 ?

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

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!

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.

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

Diogo

I've raised this problem with the support team.