Linking Static Data AFTER Getting Latest

A SQL Server Management Studio add-in to source control your database in Subversion or Team Foundation Server.

Linking Static Data AFTER Getting Latest

Postby ciaranarcher » Fri Jun 24, 2011 9:37 am

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!
Posts: 21
Joined: Fri Jun 24, 2011 8:52 am

Postby Chris Auckland » Mon Jun 27, 2011 7:09 pm

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 Auckland
Posts: 760
Joined: Tue Oct 24, 2006 1:12 pm
Location: Red Gate Software Ltd.

Postby ciaranarcher » Tue Jun 28, 2011 7:54 am

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!
Posts: 21
Joined: Fri Jun 24, 2011 8:52 am

Return to SQL Source Control Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests