Error when doing "Get Latest" from SQLSMS

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

Moderators: Chris Auckland, David Atkinson, sherr, PhilScrace, andy.campbell.smith

Error when doing "Get Latest" from SQLSMS

Postby chrisvesper » Mon Apr 08, 2013 4:33 pm

I have a local database for development, and I get the following error when I do a Get latest via SQLSMS 2008 R2.

Failed to update file from source control: [DatabaseObjectId: Name=BBLCustomer, Owner=dbo, ObjectType=Table]. Following objects were no-oped System.Collections.Generic.List`1[RedGate.SQLSourceControl.Engine.Model.DatabaseObjectId]. Last objects no-oped were System.Collections.Generic.List`1[RedGate.SQLSourceControl.Engine.Model.DatabaseObjectId].

If we use SQL Compare 10 directly, it works just fine. if we use SQL Data Compare, it works as well.
chrisvesper
 
Posts: 2
Joined: Mon Apr 08, 2013 4:20 pm

Postby Manfred.Castro » Wed Apr 10, 2013 5:26 pm

Typically a no-op operation occurs when the working base is different from both the revision in source control and the DB, but where the DB and revision in source control is the same.

Can you try unlinking and re-linking the database?

Performing an unlink and re-link will create a new working base.
Manfred Castro
Product Support
Red Gate Software
Manfred.Castro
 
Posts: 209
Joined: Mon Apr 23, 2012 2:49 pm

Postby chrisvesper » Fri Apr 12, 2013 4:38 pm

Thanks for the help. I tried that procedure, but the problem persisted.

On 4/12/13 an an update for SQL Source Control became available (to 3.3.0.104) and after applying that, I was able to get latest changes.
chrisvesper
 
Posts: 2
Joined: Mon Apr 08, 2013 4:20 pm


Return to SQL Source Control 3

Who is online

Users browsing this forum: No registered users and 2 guests