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/C ... h_projects