How can we help you today? How can we help you today?

Committed changes not the same as local database

After using SQL Source Control to commit a local database into a TFS managed source control system it appears that one of my table constraints isn't being committed properly:

Local database (where the commit came from) 
ALTER TABLE [dbo].[VehicleRegistrationMark] ADD CONSTRAINT [CC_VehicleRegistrationMark_Registration_UpperCase] CHECK ((upper([Registration])=[Registration] collate Latin1_General_CS_AS))

Source control after commit 
ALTER TABLE [dbo].[VehicleRegistrationMark] ADD CONSTRAINT [CC_VehicleRegistrationMark_Registration_UpperCase] CHECK ((upper([Registration])=))

I think this may be an issue with how SQL Source Control is generating the scripts which it sends to source control.

Any ideas?
dunos
0

Comments

2 comments

Sort by
  • simon.jackson
    Thanks for reporting the problem. I've managed to reproduce it locally, and raised an issue (SOC-1261). There's a problem with our reading in the collation from the script file. It gets written to source control correctly, but read back wrong. I'll have a look at a fix and try and get it into the next private build.
    simon.jackson
    0
  • StephanieHerr
    Great news! Your issue was fixed in the patch release v1.0.3.73, http://www.red-gate.com/messageboard/vi ... hp?t=11447. I will send you an email with the download details.
    StephanieHerr
    0

Add comment

Please sign in to leave a comment.