Committed changes not the same as local database

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

Committed changes not the same as local database

Postby dunos » Thu Jul 08, 2010 8:45 am

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)
Code: Select all
ALTER TABLE [dbo].[VehicleRegistrationMark] ADD CONSTRAINT [CC_VehicleRegistrationMark_Registration_UpperCase] CHECK ((upper([Registration])=[Registration] collate Latin1_General_CS_AS))


Source control after commit
Code: Select all
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
 
Posts: 5
Joined: Fri Oct 30, 2009 10:24 am
Location: Bristol, UK

Postby simon.jackson » Thu Jul 08, 2010 9:57 am

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
 
Posts: 45
Joined: Thu Jan 08, 2009 10:42 am

Committed changes not the same as local database

Postby sherr » Wed Jul 21, 2010 11:46 am

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.
Thank you!
Stephanie M. Herr :-)
Delivery Product Manager
sherr
 
Posts: 126
Joined: Thu Mar 19, 2009 12:45 pm
Location: Cambridge


Return to SQL Source Control 1

Who is online

Users browsing this forum: No registered users and 0 guests