Filters on from source control "Schema Compare/Deploy" tab

[sux.stellino]

Hi all,

I'm deploying stored procedures from database A to database B via "Schema Compare/Deploy" tab of Sql Source Control. I'm comparing the latest changeset of database A to the database B schema. I'm doing it using the button "Compare/Deploy with SQL Compare..".
Ok until here..

When SQL Compare appears I noticed that in the filter section there is a default "Source Control Filter 1" item selected.
I created my filter in the past and I'd like to know if there is a chance to use it by default when I compare a specific database.
If I compare A to B, I'd like to get my designed filter for A and B.
If I compare C to D, I'd like to get my designed filter for C and D.

Is there a way to do this?
And what about change at least for a different default (always the filter for A and B)?
thanks in advance!
_________________
Alessandro Alpi
Head of Database Administration@Goldbet Sportwetten GmbH
Microsoft MVP - Most Valuable Professional
SQL Server - Systems Administrator
http://mvp.microsoft.com/profiles/Alessandro.Alpi

[MCP] [MCITP - Database Developer] [MCTS] [MCT]

[micheleidesmith]

I’m afraid this is not currently possible from within SSMS. But we are planning a new version of the Integration Pack which enable you to load a pre-saved filter for a specific pair of databases (e.g. A to B, or C to D). This will work as follows:
1. Create a custom filter within SQL Compare.
2. Save the filter as part of a comparison project settings in SQL Compare.
3. Load the saved project settings from the main Schema Compare/Deploy tab in SSMS. This will load the details for the database (or repository) you want to use as a source and target for the comparison, the custom filter you have saved and any other SQL Compare project options you have saved.

Would this solve the problem for you?

We are hoping to issue a new release of the Integration Pack mid-way through this year (Q2).

Can I ask if you use the SQL Compare project settings at the moment? If so, what do you use them for? What kind of settings do you save within your projects? E.g. project options, filters, mappings.

If you are not familiar with SQL Compare projects, please see this page for more information: http://www.red-gate.com/SupportCenter/Content/SQL_Compare/help/10.0/sc_working_with_projects
_________________
Michele Ide-Smith
User Experience Specialist
Red Gate Software
michele.ide-smith@red-gate.com

[sux.stellino]

[bigminer]

From SSMS > selected database > Other SQL source control tasks > Edit filter rules. I have edited my filter and committed that to source control. No problem. Now if i unlink my database from source control and link it again it doesn't load the filter.scpf that I modified the first time. It recognizes that it is different and presents me with the option to commit the default filter, but I don't want to do that.

If I look in the base location i see that the filter.scpf doesn't exist there. However, if i do svn update on that folder i get the filter.scpf. Unfortunately, it doesn't load this file even if i restart SSMS. It still has the default filter.