Red Gate forums :: View topic - Committed changes not the same as local database
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  | Register 
Go to Documentation site
SQL Source Control 1
SQL Source Control 1 forum

Committed changes not the same as local database

 Search in SQL Source Control 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
dunos



Joined: 30 Oct 2009
Posts: 5
Location: Bristol, UK
PostPosted: Thu Jul 08, 2010 8:45 am    Post subject: Committed changes not the same as local database Reply with quote
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:
ALTER TABLE [dbo].[VehicleRegistrationMark] ADD CONSTRAINT [CC_VehicleRegistrationMark_Registration_UpperCase] CHECK ((upper([Registration])=[Registration] collate Latin1_General_CS_AS))


Source control after commit
Code:
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?
Back to top
View user's profile Send private message
simon.jackson



Joined: 08 Jan 2009
Posts: 45
PostPosted: Thu Jul 08, 2010 9:57 am    Post subject: Reply with quote
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.
Back to top
View user's profile Send private message
sherr



Joined: 19 Mar 2009
Posts: 122
Location: Cambridge
PostPosted: Wed Jul 21, 2010 11:46 am    Post subject: Committed changes not the same as local database Reply with quote
Great news! Your issue was fixed in the patch release v1.0.3.73, http://www.red-gate.com/messageboard/viewtopic.php?t=11447. I will send you an email with the download details.
_________________
Thank you!
Stephanie M. Herr Smile
SQL Tools Development Manager
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
 You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group