SQL source control failing to notice a new column

A SQL Server Management Studio add-in to source control your database in Subversion or Team Foundation Server.

SQL source control failing to notice a new column

Postby boourns » Wed Feb 26, 2014 3:13 pm

I'm trying to bring my development database up to date and noticed something odd. There's a table where a column was recently added by another developer. This new column is never proposed to be created by source control when I get latest, even though my local database doesn't have the column. Here's an example of my .SQL file, with unrelated columns removed and the table and field names changed:

Code: Select all
CREATE TABLE [dbo].[MyTable]
[MyID] [int] NOT NULL IDENTITY(1, 1),
[ProblemField] [varchar] (36) COLLATE SQL_Latin1_General_CP1_CI_AS NULL

The "ProblemField" is the new one. I tried removing the "COLLATE SQL_Latin1_General_CP1_CI_AS" part but source control still does not propose adding it.

I'm using SQL server 2008 R2, SQL source control and Mercurial.
Posts: 1
Joined: Wed Feb 26, 2014 2:45 pm

Postby Evan Moss » Fri Feb 28, 2014 7:21 pm


Thanks for your post.

Are there any changes newer than the column you're referring to that are showing up in the get latest tab?

If not, I'm guessing there is either something wrong with the "transient" folder (which is a representation of the repository that we use locally to determine what shows up on the "get latest" tab), or possibly the working folder that you're linking to.

Can you try manually getting latest on your working folder, then unlinking/relinking your database to that folder?

We also have a ticket open for you (reference 14121), so feel free to contact me there if you'd like to troubleshoot through email or over the phone.

Evan Moss
Product Support
(866) 627-8107
Evan Moss
Posts: 112
Joined: Wed Jun 12, 2013 9:56 pm

Return to SQL Source Control 3

Who is online

Users browsing this forum: No registered users and 0 guests