Committed changes not the same as local database

dunosdunos Posts: 8
edited July 21, 2010 6:46AM in SQL Source Control Previous Versions
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?
· Share on Twitter

Comments

Sign In or Register to comment.