Permissions not syncing

samgreenesamgreene Posts: 6 New member
edited October 4, 2016 2:24PM in SQL CI 2
Hi,

I have a dev database under source control. When trying to deploy changes to test using SQL CI on TFS and Octopus Deploy, permissions on tables are not being synced when there are differences.

The permission changes are in source control and in the nupkg generated by the build.

Using sql compare, the differences are shown. When I look at the artifacts showing what will be changed, they are not shown.

Please help me get this working. We are so close :D

Thanks,

Sam

Comments

  • samgreenesamgreene Posts: 6 New member
    Here is my filter...

    <?xml version="1.0" encoding="utf-8" standalone="yes"?>
    <!---->
    <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>Filter created using SQL Source Control</FilterName>
    <Filter version="1" type="DifferenceFilter">
    <FilterCaseSensitive>False</FilterCaseSensitive>
    <Filters version="1">
    <None version="1">
    <Include>False</Include>
    <Expression>(@NAME = 'db_owner') OR (@NAME = 'db_datareader')</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>False</Include>
    <Expression>(@NAME LIKE 'Source%')</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>
    <SecurityPolicy version="1">
    <Include>True</Include>
    <Expression>TRUE</Expression>
    </SecurityPolicy>
    <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>
  • Hi Sam,

    We have logged a support ticket for this issue.

    I will contact you shortly through that channel.

    Thank you,
    Sergio
    Product Support Engineer
    Redgate Software Ltd
    Please see our Help Center for detailed guides on how to use our tools
Sign In or Register to comment.