Red Gate forums :: View topic - Support for SVN Ignore functionality?
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

Support for SVN Ignore functionality?

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



Joined: 15 Oct 2010
Posts: 2

PostPosted: Fri Oct 15, 2010 1:49 am    Post subject: Support for SVN Ignore functionality? Reply with quote

Hi,

We have just started using SQL Source Control.

It does not seem to support for SVN Ignore functionality.
Is this correct?

When we have items in a specific DB that we do not want to manage, how do we tell SQL Source Control to ignore them and not prompt us to commit them each time?

Simple examples of things we do not want to manage are:
Common utility stored procs and functions that are managed in their own DB, and deployed to each client DB.

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



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

PostPosted: Fri Oct 15, 2010 1:43 pm    Post subject: Reply with quote

We're hoping to add this feature in an upcoming release. Are you looking for these objects to be put in source control and subsequently ignored, or is it important that these objects never make it into source control in the first place?

David Atkinson
Red Gate Software
Back to top
View user's profile Send private message Send e-mail
tscottIDG



Joined: 15 Oct 2010
Posts: 2

PostPosted: Sat Oct 16, 2010 6:36 am    Post subject: Reply with quote

Hi David,

Thank you for your reply.

For me it would be ideal to match SVN's functionality, which is:
- The items are never put into source control.
- The source control does however have a register of the items that it is ignoring

Failing that, any way to ignore items would be useful.
The minimum useful functional requirements would be:
- allow items to be marked as ignored
- allow items to be un-ignored.
- for items marked as ignored, do not prompt to commit changes, do not check for updates

I hope this helps.

Regards,
Tim
Back to top
View user's profile Send private message
PDinCA



Joined: 25 Jul 2005
Posts: 511
Location: Costa Mesa, CA, USA

PostPosted: Sat Oct 23, 2010 12:58 am    Post subject: Seconded - with some urgency Reply with quote

"Ignore this" implemented somehow ASAP - dealing with cross-domain Login mismatches and DB Role mismatches as well, and all the mismatches due to sp_MS% for every arbitrarilly named Replication byproduct means I really can't see the wood for the trees... I'll still use the add-in because it's workable, but with 50 and more objects to have to ignore every time I look at the offsite Production box you can imagine it gets OLD very quickly - and I've only been using SSC for THREE DAYS!

Please add my vote for swift inclusion of a workable "Ignore Feature".

Thanks for listening...
Back to top
View user's profile Send private message
David Atkinson



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

PostPosted: Sat Oct 23, 2010 9:39 am    Post subject: Reply with quote

Do you think that replication objects should be ignored in SQL Source Control by default? Would anyone want to source control these ever?

David
Back to top
View user's profile Send private message Send e-mail
PDinCA



Joined: 25 Jul 2005
Posts: 511
Location: Costa Mesa, CA, USA

PostPosted: Mon Oct 25, 2010 12:11 am    Post subject: Reply with quote

Yes, please do ignore replication objects by default. The numbers following the SPs vary from instance to instance, so there's no real correlation there. In my case, we have but 5 PUB-SUBs in Production, only 2 in QA and development. Definitely care ZERO about Source Control for the generated objects, but I would like to source control each of the PUB-SUB CREATE scripts...

Thanks for asking, David.
Back to top
View user's profile Send private message
dmasciangelo



Joined: 26 Oct 2010
Posts: 3
Location: Peoria, AZ - USA

PostPosted: Tue Oct 26, 2010 11:40 pm    Post subject: Reply with quote

I agree with tscottIDG. We need to be able to ignore some database objects from source control. In my case I'm using tSQLt to create unit tests on database objects. I'm handling the units test separately in subversion and don't want them included as part of the databases source control but I can't ignore them...
Back to top
View user's profile Send private message
David Atkinson



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

PostPosted: Tue Oct 26, 2010 11:42 pm    Post subject: Reply with quote

Thanks for the request. This is a strong candidate for the next release (along with static data support).

I'm not familiar with tSQLt. Would this allow the unit test objects to be created in a separate linked database? This might be a workaround to avoid SQL Source Control from trying to commit them.

David
Back to top
View user's profile Send private message Send e-mail
dmasciangelo



Joined: 26 Oct 2010
Posts: 3
Location: Peoria, AZ - USA

PostPosted: Tue Oct 26, 2010 11:46 pm    Post subject: Re: Reply with quote

David Atkinson wrote:
Thanks for the request. This is a strong candidate for the next release (along with static data support).

I'm not familiar with tSQLt. Would this allow the unit test objects to be created in a separate linked database? This might be a workaround to avoid SQL Source Control from trying to commit them.

David


It is possible to place the tests in another database, but changing all my tests (which assume local db objects) would be tedious at best.
Back to top
View user's profile Send private message
David Atkinson



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

PostPosted: Wed Oct 27, 2010 9:17 am    Post subject: Reply with quote

I totally understand. Your other option is to wait until the first half of next year, which is when we plan to release SQL Source Control v2. Are you signed up to the Early Access list? This way you can try the features earlier and get the chance to give us feedback that can influence how the product is developed.

David
Back to top
View user's profile Send private message Send e-mail
devavrat



Joined: 21 Feb 2011
Posts: 1

PostPosted: Mon Feb 21, 2011 1:29 pm    Post subject: Re: Reply with quote

David Atkinson wrote:
I totally understand. Your other option is to wait until the first half of next year, which is when we plan to release SQL Source Control v2. Are you signed up to the Early Access list? This way you can try the features earlier and get the chance to give us feedback that can influence how the product is developed.

David


Is this implemented yet? Is there a trial version I can try that has this?
Back to top
View user's profile Send private message
David Atkinson



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

PostPosted: Mon Feb 21, 2011 1:35 pm    Post subject: Reply with quote

Sorry, this isn't available just yet. We're working on it!

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