Cannot "Get Latest" for the first time

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

Cannot "Get Latest" for the first time

Postby SonnyS » Thu Apr 03, 2014 7:12 pm

Hi Guys,

Newbie to the whole redgate and SQL source control scene, so go easy on me.

I've created my DB that i want to pull to, from the repository. I link the database to my Vault Pro repository.

I "Get Latest". It shows me all the tables etc that its going to pull down. I click get latest.

It runs through and determines schema changes. Then about 13% into the "Apply schema changes" it shows Error.

"The script to update the database failed."

It then below says Operand type clash: uniqueidentifier is incompatible with int

Invalid column name "IsActive"
Invalid column name "MailingAddressID"

Any ideas as to what I should be doing here? Unfortunately I'm the only one skilled enough to work though this, but my skill levels are not that good either.

Any help would be great.


Posts: 1
Joined: Thu Mar 20, 2014 6:31 pm
Location: Canada

Postby james.billings » Mon Apr 07, 2014 11:37 am

I've responded to you directly with some suggestions in relation to this.
Posts: 1121
Joined: Wed Jun 16, 2010 10:10 am
Location: Red Gate

Return to SQL Source Control 3

Who is online

Users browsing this forum: No registered users and 1 guest