Red Gate forums :: View topic - You can't exclude schemas by schema name
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

You can't exclude schemas by schema name

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



Joined: 12 Jun 2012
Posts: 78
Location: Edinburgh

PostPosted: Wed May 29, 2013 1:28 pm    Post subject: You can't exclude schemas by schema name Reply with quote

In my development database I want to exclude the tSQLt schema and all objects in the schema.

I have configured the filter rules dialog to look like this:



In the diff viewer it looks like this:

Code:

-- All Objects

   Exclude where (@SCHEMA = 'tSQLt')


In English:

Quote:
"For all object types, exclude if the schema name equals tSQLt."


I would expect this rule to exclude all the objects in the tSQLt schema and the tSQLt schema itself.

In the Commit Changes dialog, I can't see the objects in the tSQLt schema, but I can still see the tSQLt schema itself.

The dialog looks like this:



The tSQLt schema is highlighted in red. I have redacted my business objects with black.

This feels like a bug. Is it supposed to behave like this?

I can work around the issue by also excluding schemas whose name equals 'tSQLt'.

By the way, SQL Compare has an option to ignore "tSQLt framework and tests". I think a similar option would be useful in SQL Source Control.

My SQL Source Control version is 3.0.12.3695.
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