There is no change but Source Control shows me item

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

There is no change but Source Control shows me item

Postby alibulut2006 » Wed Dec 29, 2010 1:30 pm

I create a link for my database and I did first commit for all objects to add them to source control. But one item didn't committed and always shown as "uncommitted" item in the commit list.
It is a table, when I review the changes; source control doeasn't show any changes but even I commit -that change next time it appears again.
What should I do ?
Is this a bug ?

Thanks .
Ali Bulut
Senior Database Administrator & Project Manager
a.bulut@triodor.eu
alibulut2006
 
Posts: 17
Joined: Thu Dec 23, 2010 2:56 pm
Location: 218

Postby Brian Donahue » Fri Dec 31, 2010 12:02 pm

Hello,

SQL Source Control diffs the SQL objects in the database and the scripts in source control. If there is a commit failure, you should be notified about that in the software, so most likely it's some unexpected behavior in the diff engine of SQL Source Control.

When you view the differences on the commit tab, what differences are shown? If none, it may be a collation-related issue, so do both sides use the same collations, and what about the database-level collation that you see between the live database and the RedGateDatabaseInfo.xml file you can find in C:\\Users\\you\\Local Settings\\application data\\red gate\\SQL Source Control 2\\WorkingBases\\your.working.base.gobbledygook
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Commit Changes doesn't show any changes

Postby alibulut2006 » Fri Dec 31, 2010 12:19 pm

Hi Brian;
Here are the asnwer related your questions :
* There are no differences are shown. This is the main reason I poted this issue
* My local DB has "Turkish_CI_AS" collation, RedGateDatabaseInfo.xml has "SQL_Latin1_General_CP1_CI_AS" collation

How can I solve this issue ?

Thanks
Ali Bulut
Senior Database Administrator & Project Manager
a.bulut@triodor.eu
alibulut2006
 
Posts: 17
Joined: Thu Dec 23, 2010 2:56 pm
Location: 218

Postby Brian Donahue » Fri Dec 31, 2010 2:44 pm

Hello Ali,

I have a sneaking suspicion that it may have something to do with the Turkish collation because of the "three-case-I" problem, but it really shouldn't affect a case-insensitive Turkish collation. Anyway I can test this out internally.

In the meantime, can you please send the SQL Source Control logs via email? They are in %userprofile%\\local settings\\application data\\red gate\\logs\\sql source control 2.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Conflict problem

Postby alibulut2006 » Mon Jan 03, 2011 9:18 am

Hi Brian;
I noticed that SQL Source Control shows as a difference between database version vs. source contro version following items :

Database Version :
Create Function [dbo].[Binary2Char] (@vbData Varbinary(256), @iStart Tinyint, @iLength Tinyint)


Source OCntrol Version :
Create Function Binary2Char (@vbData Varbinary(256), @iStart Tinyint, @iLength Tinyint)

There is only one difference : "dbo."

I hope this help to understand problem..
Thanks and Regards.
Ali Bulut
Senior Database Administrator & Project Manager
a.bulut@triodor.eu
alibulut2006
 
Posts: 17
Joined: Thu Dec 23, 2010 2:56 pm
Location: 218

Postby Brian Donahue » Tue Jan 04, 2011 11:11 am

I don't think this should matter. Anyway, if you commit, the difference should go away. Maybe the same object is defined in two different script files? We should probably get the log files from you.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Commit Changes doesn't show any changes

Postby alibulut2006 » Tue Jan 04, 2011 11:19 am

Hi Brian;
I sent log file to you by email yesterday. Source control shows only this differences "dbo.xxxxxx" vs "xxxxxx".

And; very strange that we all restored same database backup to our local SQLServer. You should work over this whay do this happen.

Thanks.

ALi Bulut
Ali Bulut
Senior Database Administrator & Project Manager
a.bulut@triodor.eu
alibulut2006
 
Posts: 17
Joined: Thu Dec 23, 2010 2:56 pm
Location: 218


Return to SQL Source Control 1

Who is online

Users browsing this forum: No registered users and 1 guest