What are the challenges you face when working across database platforms? Take the survey
Options

Does V12 not read older filter files?

CGLuttrellCGLuttrell Posts: 39 Bronze 1
edited September 22, 2016 12:26PM in SQL Compare
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?
0rQp3OmI4http://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)

Comments

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