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.

Thanks

SS
SonnyS
 
Posts: 1
Joined: Thu Mar 20, 2014 7:31 pm
Location: Canada

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

Hi,
I've responded to you directly with some suggestions in relation to this.
james.billings
 
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