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.

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

Cannot "Get Latest" for the first time

Postby SonnyS » Thu Apr 03, 2014 8: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 7:31 pm
Location: Canada

Postby james.billings » Mon Apr 07, 2014 12:37 pm

I've responded to you directly with some suggestions in relation to this.
Posts: 1146
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.

Return to SQL Source Control 3

Who is online

Users browsing this forum: No registered users and 1 guest