Red Gate forums :: View topic - Excluding tables with names start with underscore
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

Excluding tables with names start with underscore

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



Joined: 29 May 2013
Posts: 15

PostPosted: Tue Jul 30, 2013 8:11 pm    Post subject: Excluding tables with names start with underscore Reply with quote

Hello,

We have a naming convention in the company to name all physical temporary and backup tables with underscore (_). Examples: _CustomerTemp or _OrderBck.

I would like to exclude those tables from being pushed to source control (TFS), but when I setup filter rules "exclude if object name begins with _" all tables are excluded.

I tried SQL language approach and specified [_] as exclude value (exclude if object name begins with [_]) to replicate following SQL statement (below, which works), but it didn't work at all and all tables are included and pushed to Source control.

SELECT * FROM sysobjects
WHERE xtype='U' and name NOT LIKE '[_]%'

When I look at filter settings script it stays:

-- Table

Exclude where (@NAME LIKE '[_]%')

How do I exclude tables where names starts with _?

Please, advise.

Thank you,
Eugene.
Back to top
View user's profile Send private message
Manfred.Castro



Joined: 23 Apr 2012
Posts: 205

PostPosted: Thu Aug 01, 2013 9:27 pm    Post subject: Reply with quote

This is a known issue logged in our system under the internal reference number of SOC-3904.
Underscore is a wildcard character in one of the underlying expression parsers that we use here.
Unfortunately there is not currently a method to prevent the underscore from being treated as a wildcard.
There is an existing feature request you may want to vote for which would allow the underscore to be treated as a literal character.
http://redgate.uservoice.com/forums/39019-sql-source-control/suggestions/3172258-excluding-starts-with-underscore-filters-out-all
These forums are actively monitored by our development team and allow our users to request features and vote on them.
If a feature receives a significant amount of votes or is deemed to have merit development may include the feature in a future release.
_________________
Manfred Castro
Product Support
Red Gate Software
Back to top
View user's profile Send private message
eugef



Joined: 29 May 2013
Posts: 15

PostPosted: Thu Aug 01, 2013 9:59 pm    Post subject: Reply with quote

Thank you. I added my votes for this feature to be added to a next release.
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