Permissions not syncing

samgreene

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

Thanks,

Sam

samgreene

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>

Sergio R

Hi Sam,

We have logged a support ticket for this issue.

I will contact you shortly through that channel.

Thank you,