At what point will Db status icon change if edit done to underlying file in local Git repo?

bitshift2 · November 13, 2018 10:07PM

Is SQL Source control Git-aware?

So if one has already linked a Db to an underlying Git repo, then:

- switched to a feature branch

- Opened the .sql file directly and updated a table definition
- Saved the change and performed a Git sync

When will we see the "changed" icon display on the Db? Or will this only change when the edit is done through SSMS?
I tested by also doing a table change via TSQL and it worked, but if I edited the .SQL file in the underlying Git repo, the icon didnt change. No big deal, just wondering.

Image: https://us.v-cdn.net/6029854/uploads/editor/vc/q3d8ykxygzml.png

Mike U · November 14, 2018 7:41AM

That's correct, the blue change indicators only show when objects in the database have changed since the last time a commit/get-latest operation took place. The change tracking does not do a comparison with the linked version control system - that comparison only happens when you refresh the commit/get-latest tabs.

David Atkinson · November 13, 2018 10:11PM

It only indicates database changes that haven't yet been checked in (or saved to working folder), not the other way round. It's trying to encourage frequent commits, which is generally accepted as a good practice.

bitshift2 · November 13, 2018 10:18PM

So its only tracking changes that the extension sees via SSMS ?

David Atkinson · November 13, 2018 10:20PM

No, the tracking is done irrespective of the tool that applies the change.

bitshift2 · November 14, 2018 12:11AM

Ok, to re-phrase the question, is it only tracking changes to the Db? In other words its only if there is a difference between the Db and the source its linked to?

David Atkinson · November 14, 2018 4:10PM

Yes, that's right.

At what point will Db status icon change if edit done to underlying file in local Git repo?

Best Answer

Answers

Product Learning

Community Forums

Events & Friends

Simple Talk