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

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

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.

bitshift2
0

Comments

6 comments

Sort by
  • 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.
    David Atkinson
    0
  • bitshift2
    So its only tracking changes that the extension sees via SSMS ?
    bitshift2
    0
  • David Atkinson
    No, the tracking is done irrespective of the tool that applies the change.
    David Atkinson
    0
  • 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?
    bitshift2
    0
  • 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.
    Mike U
    0
  • David Atkinson
    Yes, that's right.
    David Atkinson
    0

Add comment

Please sign in to leave a comment.