Get Latest doesn't appear to work
Backup a database which is under revision control (with SQL Source Control), modify an SP and commit it. Then restore the DB (rolls back the SP). Source Control see the changed SP and allows me to commit it, but Get Latest doesn't.
-
Chris Dalmazzo-Auckland commented
This is a bit of a usability issue, but it's working as designed.
You actually have all the latest objects in your local database, so there is nothing to 'Get' from source control. However, you have made some changes locally from the latest version. A history of local changes is stored by source control, so if you want to revert to the 'latest' version, you can 'undo' your local changes.
This is performed by right-clicking on the object > Other SQL Source Control Tasks > Undo changes...
I hope this helps.