Red Gate forums :: View topic - Option to "Commit all dependencies (recommended)"
Return to www.red-gate.com RSS Feed Available

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

Option to "Commit all dependencies (recommended)"

Search in SQL Source Control 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
anna.p



Joined: 03 Jul 2012
Posts: 23

PostPosted: Tue Feb 05, 2013 1:13 am    Post subject: Option to "Commit all dependencies (recommended)" Reply with quote

Hello,

When you try to commit something that has dependencies you get the window that pops up with the list of dependent objects giving you the option to commit them as well. I'm wondering 2 things:

1. What is the purpose of going ahead and committing the listed dependencies?

2. How exactly does SSC decide what dependencies to list?

Thanks much!
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1124
Location: Twitter: @dtabase

PostPosted: Thu Feb 07, 2013 11:39 am    Post subject: Reply with quote

In some cases, not committing the dependencies could mean that the database held (as files) in source control comprise an invalid database. This could mean in some cases that another user failing in the 'get latest' operation.

The workaround would be to manually fix up the "invalidness" in source control before trying to "get latest" again, but that's something that would best be avoided.

SQL Source Control builds up a dependency tree of your database to determine the objects that reference the object in question.

David Atkinson
Red Gate
Back to top
View user's profile Send private message Send e-mail
anna.p



Joined: 03 Jul 2012
Posts: 23

PostPosted: Thu Feb 07, 2013 8:26 pm    Post subject: Reply with quote

We're using a shared database model. Does it have any use in that environment?

Also, does the list of "recommended objects" include ones that are waiting to be committed and ones that haven't changed since the last commit? This seems to be the case, I just want to make sure.
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1124
Location: Twitter: @dtabase

PostPosted: Thu Feb 07, 2013 11:42 pm    Post subject: Reply with quote

Yes, in as much that if you deploy from source control with, say, SQL Compare, you'd want to do so from a valid repository. However, this is unlikely to be problematic as the fix would be to commit the offending objects.

It should only offer those objects that have changed. Are there objects in the list that don't exist in the commit list? That would be a bug which you should report to support@red-gate.com

David
Back to top
View user's profile Send private message Send e-mail
anna.p



Joined: 03 Jul 2012
Posts: 23

PostPosted: Fri Feb 08, 2013 1:34 am    Post subject: Reply with quote

I'm pretty sure I've seen it happen. I remember being curious about it, checking, then becoming confused. If I see it again I'll report it.

Thanks very much!
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