How can we help you today? How can we help you today?
duggerg
This has not helped us by setting it to true or false. I am also seeing it create Security folders and files each time I try a new baseline even though I have set every option that deals with users, permissions, roles, etc to be ignored. What am I missing? <div><PropertyGroup></div><div>&nbsp; &nbsp; <!-- These properties might be set by the Developer --></div><div>&nbsp; &nbsp; <SyncOptionIncludeDependentObjects>False</SyncOptionIncludeDependentObjects></div><div>&nbsp; &nbsp; <SyncOptionIncludeExistenceChecks>False</SyncOptionIncludeExistenceChecks></div><div>&nbsp; &nbsp; <SyncOptionUseDropCreateInsteadOfAlter>False</SyncOptionUseDropCreateInsteadOfAlter></div><div>&nbsp; &nbsp; <SyncOptionDisableDdlTriggers>False</SyncOptionDisableDdlTriggers></div><div>&nbsp; &nbsp; <SyncOptionCaseSensitiveObjectDefinition>False</SyncOptionCaseSensitiveObjectDefinition></div><div>&nbsp; &nbsp; <SyncOptionIgnoreExtendedProperties>False</SyncOptionIgnoreExtendedProperties></div><div>&nbsp; &nbsp; <SyncOptionIgnoreCommentsInBodies>False</SyncOptionIgnoreCommentsInBodies></div><div>&nbsp; &nbsp; <SyncOptionIgnoreAnsiOptions>False</SyncOptionIgnoreAnsiOptions></div><div>&nbsp; &nbsp; <SyncOptionIgnoreCollations>True</SyncOptionIgnoreCollations></div><div>&nbsp; &nbsp; <SyncOptionIgnoreColumnsOrder>True</SyncOptionIgnoreColumnsOrder></div><div>&nbsp; &nbsp; <SyncOptionIgnoreWhiteSpace>True</SyncOptionIgnoreWhiteSpace></div><div>&nbsp; &nbsp; <SyncOptionIgnoreSynonymDatabaseAndServerName>True</SyncOptionIgnoreSynonymDatabaseAndServerName></div><div>&nbsp; &nbsp; <SyncOptionIgnoretSQLt>True</SyncOptionIgnoretSQLt></div><div>&nbsp; &nbsp; <SyncOptionIgnoreDmlTriggers>False</SyncOptionIgnoreDmlTriggers></div><div>&nbsp; &nbsp; <SyncOptionIgnoreInsteadOfTriggers>False</SyncOptionIgnoreInsteadOfTriggers></div><div>&nbsp; &nbsp; <SyncOptionIgnoreBindings>False</SyncOptionIgnoreBindings></div><div>&nbsp; &nbsp; <SyncOptionIgnoreQueueEventNotifications>False</SyncOptionIgnoreQueueEventNotifications></div><div>&nbsp; &nbsp; <SyncOptionIgnoreSquareBrackets>False</SyncOptionIgnoreSquareBrackets></div><div>&nbsp; &nbsp; <SyncOptionIgnoreWithElementOrder>True</SyncOptionIgnoreWithElementOrder></div><div>&nbsp; &nbsp; <SyncOptionIgnoreWithEncryption>False</SyncOptionIgnoreWithEncryption></div><div>&nbsp; &nbsp; <!-- These properties might be set by the DBA --></div><div>&nbsp; &nbsp; <SyncOptionIgnoreDataspaces>True</SyncOptionIgnoreDataspaces></div><div>&nbsp; &nbsp; <SyncOptionIgnoreConstraintNotForReplicationAttribute>True</SyncOptionIgnoreConstraintNotForReplicationAttribute></div><div>&nbsp; &nbsp; <SyncOptionIgnoreFillFactor>False</SyncOptionIgnoreFillFactor></div><div>&nbsp; &nbsp; <SyncOptionIgnoreIndexLockAttributes>False</SyncOptionIgnoreIndexLockAttributes></div><div>&nbsp; &nbsp; <SyncOptionIgnoreStatistics>True</SyncOptionIgnoreStatistics></div><div>&nbsp; &nbsp; <SyncOptionIgnoreDataCompression>True</SyncOptionIgnoreDataCompression></div><div>&nbsp; &nbsp; <SyncOptionIgnoreFullTextIndexing>False</SyncOptionIgnoreFullTextIndexing></div><div>&nbsp; &nbsp; <SyncOptionIgnoreReplicationTriggers>True</SyncOptionIgnoreReplicationTriggers></div><div>&nbsp; &nbsp; <SyncOptionIgnoreSchemaObjectAuthorization>False</SyncOptionIgnoreSchemaObjectAuthorization></div><div>&nbsp; &nbsp; <SyncOptionIgnoreStatisticsNorecompute>False</SyncOptionIgnoreStatisticsNorecompute></div><div>&nbsp; &nbsp; <SyncOptionConsiderNextFilegroupInPartitionSchemes>False</SyncOptionConsiderNextFilegroupInPartitionSchemes></div><div>&nbsp; &nbsp; <!-- Shared Developer/DBA options --></div><div>&nbsp; &nbsp; <SyncOptionIgnoreIndexes>False</SyncOptionIgnoreIndexes></div><div>&nbsp; &nbsp; <SyncOptionIgnorePermissions>True</SyncOptionIgnorePermissions></div><div>&nbsp; &nbsp; <SyncOptionIgnoreConstraintWithNoCheckAttribute>False</SyncOptionIgnoreConstraintWithNoCheckAttribute></div><div>&nbsp; &nbsp; <SyncOptionIgnoreNocheckAndWithNocheckAttributes>False</SyncOptionIgnoreNocheckAndWithNocheckAttributes></div><div>&nbsp; &nbsp; <SyncOptionIgnoreIdentitySeedAndIncrement>True</SyncOptionIgnoreIdentitySeedAndIncrement></div><div>&nbsp; &nbsp; <SyncOptionIgnoreUserProperties>True</SyncOptionIgnoreUserProperties></div><div>&nbsp; &nbsp; <SyncOptionIgnoreUsersPermissionsAndRoleMemberships>True</SyncOptionIgnoreUsersPermissionsAndRoleMemberships></div><div>&nbsp; &nbsp; <SyncOptionAddWithEncryption>False</SyncOptionAddWithEncryption></div><div>&nbsp; &nbsp; <SyncOptionDecryptEncryptedObjects>False</SyncOptionDecryptEncryptedObjects></div><div>&nbsp; &nbsp; <SyncOptionUseCompatibilityLevel>False</SyncOptionUseCompatibilityLevel></div><div>&nbsp; &nbsp; <!-- Data comparison/sync options --></div><div>&nbsp; &nbsp; <!--</div><div>&nbsp; &nbsp; <SyncDataOptionDropKeysIndexesAndConstraints>False</SyncDataOptionDropKeysIndexesAndConstraints></div><div>&nbsp; &nbsp; <SyncDataOptionDisableForeignKeys>False</SyncDataOptionDisableForeignKeys></div><div>&nbsp; &nbsp; <SyncDataOptionIncludeTimestampColumns>False</SyncDataOptionIncludeTimestampColumns></div><div>&nbsp; &nbsp; <SyncDataOptionCaseSensitiveObjectDefinition>True</SyncDataOptionCaseSensitiveObjectDefinition></div><div>&nbsp; &nbsp; <SyncDataOptionForceBinaryCollation>True</SyncDataOptionForceBinaryCollation></div><div>&nbsp; &nbsp; <SyncDataOptionTrimTrailingSpaces>False</SyncDataOptionTrimTrailingSpaces></div><div>&nbsp; &nbsp; <SyncDataOptionDisableDmlTriggers>False</SyncDataOptionDisableDmlTriggers></div><div>&nbsp; &nbsp; <SyncDataOptionDisableDdlTriggers>True</SyncDataOptionDisableDdlTriggers></div><div>&nbsp; &nbsp; <SyncDataOptionDontIncludeCommentsInScript>False</SyncDataOptionDontIncludeCommentsInScript></div><div>&nbsp; &nbsp; <SyncDataOptionReseedIdentityColumns>False</SyncDataOptionReseedIdentityColumns></div><div>&nbsp; &nbsp; <SyncDataOptionSkipIntegrityChecksForForeignKeys>False</SyncDataOptionSkipIntegrityChecksForForeignKeys></div><div>&nbsp; &nbsp; <SyncDataOptionTransportClrDataTypesAsBinary>False</SyncDataOptionTransportClrDataTypesAsBinary></div><div>&nbsp; &nbsp; <SyncDataOptionCompressTemporaryFiles>False</SyncDataOptionCompressTemporaryFiles></div><div>&nbsp; &nbsp; <SyncDataOptionTreatEmptyStringAsNull>False</SyncDataOptionTreatEmptyStringAsNull></div><div>&nbsp; &nbsp; <SyncDataOptionUseChecksumComparison>False</SyncDataOptionUseChecksumComparison></div><div>&nbsp; &nbsp; <SyncDataOptionUseMaxPrecisionForFloatComparison>False</SyncDataOptionUseMaxPrecisionForFloatComparison></div><div>&nbsp; &nbsp; --></div><div>&nbsp; </PropertyGroup></div> / comments
This has not helped us by setting it to true or false. I am also seeing it create Security folders and files each time I try a new baseline even though I have set every option that deals with users...
0 votes