Turn off the "Commit Dependencies" modal? Possible?

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

Turn off the "Commit Dependencies" modal? Possible?

Postby sgilboy » Wed Jan 30, 2013 1:53 pm

Is it possible to completely turn "off" this modal window, I don't ever want to commit the dependencies



Image
sgilboy
 
Posts: 31
Joined: Wed Jun 22, 2011 7:38 pm

Postby David Atkinson » Wed Jan 30, 2013 3:36 pm

Most options available in SQL Compare are now also available to SQL Source Control.

Please visit http://www.red-gate.com/SupportCenter/G ... 1202000521 for more information.

Having said that, it appears that the line already implies that dependencies aren't included.
<IncludeDependencies>False</IncludeDependencies>

I'll have to investigate.

David Atkinson
Red Gate
David Atkinson
 
Posts: 1136
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase

Postby sgilboy » Wed Jan 30, 2013 3:50 pm

Thanks for the quick reply David..

so I *think* that the setting you point to is to just by default have that checkbox unchecked in the modal, I was looking for a way to not even have the modal pop up and require me to take action before Compare does it's thing

btw, I tried to get into the settings by right-clicking as that KB article shows, but all I get is "Copy" in the context menu... I am running an older version (3.0.13.4214) because of 3.1's "timeout" issues

Image
sgilboy
 
Posts: 31
Joined: Wed Jun 22, 2011 7:38 pm

Postby David Atkinson » Wed Jan 30, 2013 3:54 pm

Have you raised the timeout issues with the Red Gate Support team?

Regarding the behavior of that option, I've done some experimentation and it appears that SQL Source Control isn't honoring that option at all.

We'd obviously want to encourage users to included dependencies to reduce the risk of ending up with an inconsistent database. Is there any reason why you never want to commit the dependencies?

David
David Atkinson
 
Posts: 1136
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase

Re:

Postby sgilboy » Wed Jan 30, 2013 4:04 pm

David Atkinson wrote:Have you raised the timeout issues with the Red Gate Support team?


Yup, sure have

http://www.red-gate.com/MessageBoard/vi ... hp?t=16158

There is a new patch, but I don't want to be the first to try it :-)


David Atkinson wrote:We'd obviously want to encourage users to included dependencies to reduce the risk of ending up with an inconsistent database. Is there any reason why you never want to commit the dependencies


We've got a mish-mash of SQL Server versions across our 3 environments, I keep things simple by using SQL Source Control *just* for the PROCs I write... it's worked great for 3+ years now
sgilboy
 
Posts: 31
Joined: Wed Jun 22, 2011 7:38 pm

Postby David Atkinson » Wed Jan 30, 2013 5:18 pm

I've raised this in our issue tracking system (issue SOC-4620).

In the time being I'm sorry to say that you'll have to uncheck that box each time!

David
David Atkinson
 
Posts: 1136
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase

Re: Turn off the "Commit Dependencies" modal? Possible?

Postby Ozzie » Tue Apr 21, 2015 9:16 pm

Has this ever been fixed to allow it to be turned off? We need that option too.

Thanks,
Doug
Ozzie
 
Posts: 26
Joined: Tue Jun 26, 2007 9:10 pm
Location: Havertown, PA, USA

Re: Turn off the "Commit Dependencies" modal? Possible?

Postby Robert Clenshaw » Mon Apr 27, 2015 1:09 pm

Hi Doug,

Unfortunately this feature hasn't been implemented, but I've added a note on our system to say that you've expressed an interest in it.
Robert Clenshaw
Product Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
Robert Clenshaw
 
Posts: 98
Joined: Wed Oct 22, 2014 3:07 pm
Location: Redgate Software, Cambridge

Re: Turn off the "Commit Dependencies" modal? Possible?

Postby Ozzie » Mon Apr 27, 2015 4:00 pm

Yeah - having that as the default deploys the dependencies if you are moving too fast, or if you have college interns who doesn't know to uncheck that box...;-)

Making that a user selectable default seems like a no harm/no foul option - especially if you DO NOT want it enabled as default.

Thanks for the consideration,
Doug
Ozzie
 
Posts: 26
Joined: Tue Jun 26, 2007 9:10 pm
Location: Havertown, PA, USA

Re: Turn off the "Commit Dependencies" modal? Possible?

Postby sgilboy » Tue Jun 16, 2015 3:37 pm

How do I get to the "IncludeDependencies" XML flag in the SQL Source 3.8.11 ?
sgilboy
 
Posts: 31
Joined: Wed Jun 22, 2011 7:38 pm

Re: Turn off the "Commit Dependencies" modal? Possible?

Postby Dan Guzman » Thu Jul 23, 2015 9:09 pm

Is there any more news on this? I too would like the include dependencies default to be configurable.

Thanks.
Dan Guzman
 
Posts: 12
Joined: Sat Sep 27, 2014 4:11 pm

Re: Turn off the "Commit Dependencies" modal? Possible?

Postby Robert Clenshaw » Wed Aug 05, 2015 1:14 pm

Dan Guzman wrote:Is there any more news on this? I too would like the include dependencies default to be configurable.

Thanks.


Hi Dan,

Afraid not, although I've put a note on our system to say that you've expressed an interest.

Sorry.
Robert Clenshaw
Product Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
Robert Clenshaw
 
Posts: 98
Joined: Wed Oct 22, 2014 3:07 pm
Location: Redgate Software, Cambridge

Re: Turn off the "Commit Dependencies" modal? Possible?

Postby Dan Guzman » Sat Aug 15, 2015 8:50 pm

Thanks for the update, Robert. I just installed SQL Source Control 4.0 and didn't see such an option.

The reason I'd like the configurable default is that we have one database that has many partitioned views and member tables. For each view, the number of tables vary by installation target so we only keep a view containing a single table in source control along the member table. These are excluded from visibility using filters. However, developers sometimes forget to uncheck the dependency box when checking in objects that reference partitioned views, and that pulls in the multi-tabled partitioned view and member tables too. I have to routinely clean up the mess.
Dan Guzman
 
Posts: 12
Joined: Sat Sep 27, 2014 4:11 pm


Return to SQL Source Control 3

Who is online

Users browsing this forum: No registered users and 0 guests

cron