Red Gate forums :: View topic - There is no change but Source Control shows me item
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Source Control 1
SQL Source Control 1 forum

There is no change but Source Control shows me item

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



Joined: 23 Dec 2010
Posts: 17
Location: 218

PostPosted: Wed Dec 29, 2010 1:30 pm    Post subject: There is no change but Source Control shows me item Reply with quote

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
Back to top
View user's profile Send private message Send e-mail MSN Messenger
Brian Donahue



Joined: 23 Aug 2004
Posts: 6649

PostPosted: Fri Dec 31, 2010 12:02 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
alibulut2006



Joined: 23 Dec 2010
Posts: 17
Location: 218

PostPosted: Fri Dec 31, 2010 12:19 pm    Post subject: Commit Changes doesn't show any changes Reply with quote

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
Back to top
View user's profile Send private message Send e-mail MSN Messenger
Brian Donahue



Joined: 23 Aug 2004
Posts: 6649

PostPosted: Fri Dec 31, 2010 2:44 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
alibulut2006



Joined: 23 Dec 2010
Posts: 17
Location: 218

PostPosted: Mon Jan 03, 2011 9:18 am    Post subject: Conflict problem Reply with quote

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
Back to top
View user's profile Send private message Send e-mail MSN Messenger
Brian Donahue



Joined: 23 Aug 2004
Posts: 6649

PostPosted: Tue Jan 04, 2011 11:11 am    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
alibulut2006



Joined: 23 Dec 2010
Posts: 17
Location: 218

PostPosted: Tue Jan 04, 2011 11:19 am    Post subject: Commit Changes doesn't show any changes Reply with quote

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
Back to top
View user's profile Send private message Send e-mail MSN Messenger
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