Committed changes not the same as local database

dunosdunos Posts: 8
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?

Comments

Sign In or Register to comment.