Committed changes not the same as local database

dunos

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?

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.

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.