Linking Static Data AFTER Getting Latest

[ciaranarcher]

Hi all

We've setup our local databases and linked them to source control which created the schema. That worked great.

But one developer is having an issue where SSMS is telling him his local copy is up to date when it isn't. It says there are no changes, but if he clicks 'Show History', right clicks on the latest version and then 'Update this version with SQL Compare Pro' he can see ALL the changes he should have.

Any ideas why get latest is not seeing these changes?

Thanks in advance!
Ciaran

[Chris Auckland]

Thanks for your post.

If the developer has inadvertently linked the database in 'shared' mode, then there will never be anything shown in the 'get latest' tab, as a shared database will always be on the latest version.

It might also be that they have the latest version, but have also made several changes to the local copy, which means it is no longer the same version as the repository. He can undo these changes using the undo function, but as he started out with the latest version, the 'get latest' won't show anything to get.

If neither of these apply, then something isn't right. Can you get them to relink and see if the problem remains?
_________________
Chris

[ciaranarcher]

Hi Chris

We are using the 'dedicated' model. Took your suggestion on board, re-linked and it pointed out a lot of conflicts, so we just took the versions from source control and now all is well.

Thanks for the help!