Does V12 not read older filter files?

CGLuttrell · September 21, 2016 4:50PM

I tried to use a filter I was using in V11 but it does not seem to be reading it or using it in V12. Is that planned obsolescence or a bug?

http://screencast.com/t/0rQp3OmI4
Trying to post an image to show you, not sure if it is working as it does not show in Preview. Fingers crossed and hitting submit. (edited to add a url)

sam.blackburn · September 22, 2016 4:46AM

Hello,

Thanks for reporting this - it definitely looks like a bug to me. I take it the filter just excludes security policies - could you send us your filter file (or paste the XML into a reply) so we can reproduce the problem here?

Cheers

CGLuttrell · September 22, 2016 12:26PM

None of my old filters worked, and they are not that complicated, including or excluding something by schema or name. This is one of them to exclude all our CDC stuff.

&lt;?xml version="1.0" encoding="utf-8" standalone="yes"?&gt;
&lt;!--
SQL Compare
SQL Compare
Version:11.1.3.30--&gt;
&lt;NamedFilter version="1" type="SQLCompareFilter"&gt;
  &lt;!--This filter can be loaded using the SQL Compare UI or used with a SQL Compare command line session using the /filter switch--&gt;
  &lt;FilterName&gt;Exclude CDC 2&lt;/FilterName&gt;
  &lt;Filter version="1" type="DifferenceFilter"&gt;
    &lt;FilterCaseSensitive&gt;False&lt;/FilterCaseSensitive&gt;
    &lt;Filters version="1"&gt;
      &lt;None version="1"&gt;
        &lt;Include&gt;False&lt;/Include&gt;
        &lt;Expression&gt;(@NAME LIKE 'spCDC%') OR (@SCHEMA = 'CDCStageG2') OR (@NAME LIKE 'fn_cdc_%') OR (@NAME LIKE 'cdc%')&lt;/Expression&gt;
      &lt;/None&gt;
      &lt;Assembly version="1"&gt;
        &lt;Include&gt;True&lt;/Include&gt;
        &lt;Expression&gt;TRUE&lt;/Expression&gt;
      &lt;/Assembly&gt;
      &lt;AsymmetricKey version="1"&gt;
        &lt;Include&gt;True&lt;/Include&gt;
        &lt;Expression&gt;TRUE&lt;/Expression&gt;
      &lt;/AsymmetricKey&gt;
      &lt;Certificate version="1"&gt;
        &lt;Include&gt;True&lt;/Include&gt;
        &lt;Expression&gt;TRUE&lt;/Expression&gt;
      &lt;/Certificate&gt;
      &lt;Contract version="1"&gt;
        &lt;Include&gt;True&lt;/Include&gt;
        &lt;Expression&gt;TRUE&lt;/Expression&gt;
      &lt;/Contract&gt;
      &lt;DdlTrigger version="1"&gt;
        &lt;Include&gt;True&lt;/Include&gt;
        &lt;Expression&gt;TRUE&lt;/Expression&gt;
      &lt;/DdlTrigger&gt;
      &lt;Default version="1"&gt;
        &lt;Include&gt;True&lt;/Include&gt;
        &lt;Expression&gt;TRUE&lt;/Expression&gt;
      &lt;/Default&gt;
      &lt;ExtendedProperty version="1"&gt;
        &lt;Include&gt;True&lt;/Include&gt;
        &lt;Expression&gt;TRUE&lt;/Expression&gt;
      &lt;/ExtendedProperty&gt;
      &lt;EventNotification version="1"&gt;
        &lt;Include&gt;True&lt;/Include&gt;
        &lt;Expression&gt;TRUE&lt;/Expression&gt;
      &lt;/EventNotification&gt;
      &lt;FullTextCatalog version="1"&gt;
        &lt;Include&gt;True&lt;/Include&gt;
        &lt;Expression&gt;TRUE&lt;/Expression&gt;
      &lt;/FullTextCatalog&gt;
      &lt;FullTextStoplist version="1"&gt;
        &lt;Include&gt;True&lt;/Include&gt;
        &lt;Expression&gt;TRUE&lt;/Expression&gt;
      &lt;/FullTextStoplist&gt;
      &lt;Function version="1"&gt;
        &lt;Include&gt;True&lt;/Include&gt;
        &lt;Expression&gt;TRUE&lt;/Expression&gt;
      &lt;/Function&gt;
      &lt;MessageType version="1"&gt;
        &lt;Include&gt;True&lt;/Include&gt;
        &lt;Expression&gt;TRUE&lt;/Expression&gt;
      &lt;/MessageType&gt;
      &lt;PartitionFunction version="1"&gt;
        &lt;Include&gt;True&lt;/Include&gt;
        &lt;Expression&gt;TRUE&lt;/Expression&gt;
      &lt;/PartitionFunction&gt;
      &lt;PartitionScheme version="1"&gt;
        &lt;Include&gt;True&lt;/Include&gt;
        &lt;Expression&gt;TRUE&lt;/Expression&gt;
      &lt;/PartitionScheme&gt;
      &lt;Queue version="1"&gt;
        &lt;Include&gt;True&lt;/Include&gt;
        &lt;Expression&gt;TRUE&lt;/Expression&gt;
      &lt;/Queue&gt;
      &lt;Role version="1"&gt;
        &lt;Include&gt;True&lt;/Include&gt;
        &lt;Expression&gt;TRUE&lt;/Expression&gt;
      &lt;/Role&gt;
      &lt;Route version="1"&gt;
        &lt;Include&gt;True&lt;/Include&gt;
        &lt;Expression&gt;TRUE&lt;/Expression&gt;
      &lt;/Route&gt;
      &lt;Rule version="1"&gt;
        &lt;Include&gt;True&lt;/Include&gt;
        &lt;Expression&gt;TRUE&lt;/Expression&gt;
      &lt;/Rule&gt;
      &lt;Schema version="1"&gt;
        &lt;Include&gt;True&lt;/Include&gt;
        &lt;Expression&gt;TRUE&lt;/Expression&gt;
      &lt;/Schema&gt;
      &lt;SearchPropertyList version="1"&gt;
        &lt;Include&gt;True&lt;/Include&gt;
        &lt;Expression&gt;TRUE&lt;/Expression&gt;
      &lt;/SearchPropertyList&gt;
      &lt;Sequence version="1"&gt;
        &lt;Include&gt;True&lt;/Include&gt;
        &lt;Expression&gt;TRUE&lt;/Expression&gt;
      &lt;/Sequence&gt;
      &lt;Service version="1"&gt;
        &lt;Include&gt;True&lt;/Include&gt;
        &lt;Expression&gt;TRUE&lt;/Expression&gt;
      &lt;/Service&gt;
      &lt;ServiceBinding version="1"&gt;
        &lt;Include&gt;True&lt;/Include&gt;
        &lt;Expression&gt;TRUE&lt;/Expression&gt;
      &lt;/ServiceBinding&gt;
      &lt;StoredProcedure version="1"&gt;
        &lt;Include&gt;True&lt;/Include&gt;
        &lt;Expression&gt;TRUE&lt;/Expression&gt;
      &lt;/StoredProcedure&gt;
      &lt;SymmetricKey version="1"&gt;
        &lt;Include&gt;True&lt;/Include&gt;
        &lt;Expression&gt;TRUE&lt;/Expression&gt;
      &lt;/SymmetricKey&gt;
      &lt;Synonym version="1"&gt;
        &lt;Include&gt;True&lt;/Include&gt;
        &lt;Expression&gt;TRUE&lt;/Expression&gt;
      &lt;/Synonym&gt;
      &lt;Table version="1"&gt;
        &lt;Include&gt;True&lt;/Include&gt;
        &lt;Expression&gt;TRUE&lt;/Expression&gt;
      &lt;/Table&gt;
      &lt;User version="1"&gt;
        &lt;Include&gt;True&lt;/Include&gt;
        &lt;Expression&gt;TRUE&lt;/Expression&gt;
      &lt;/User&gt;
      &lt;UserDefinedType version="1"&gt;
        &lt;Include&gt;True&lt;/Include&gt;
        &lt;Expression&gt;TRUE&lt;/Expression&gt;
      &lt;/UserDefinedType&gt;
      &lt;View version="1"&gt;
        &lt;Include&gt;True&lt;/Include&gt;
        &lt;Expression&gt;TRUE&lt;/Expression&gt;
      &lt;/View&gt;
      &lt;XmlSchemaCollection version="1"&gt;
        &lt;Include&gt;True&lt;/Include&gt;
        &lt;Expression&gt;TRUE&lt;/Expression&gt;
      &lt;/XmlSchemaCollection&gt;
    &lt;/Filters&gt;
  &lt;/Filter&gt;
&lt;/NamedFilter&gt;

Does V12 not read older filter files?

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk