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

bitshift2

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.

Mike U

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

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

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

David Atkinson

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

bitshift2

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

Yes, that's right.