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

How to "ignore collation" in the scpf Filter


We use octopus deploy server to deploy software on our hosting enviroments. 
One of the steps is "Redgate - Deploy Database (type Run a Script) on Octopus Server", this is a standard Redgate step.

This step do an SQL compare with based on FIlter_deployment.scpf file. The compare is working, but we want to ignore collation. Now whe have some collation problems on synchronising the both database servers.

I do not know how I can ingore collation.

New-DatabaseReleaseArtifact, SQL Change Automation 3.3.19206.9626, Copyright Ac Red Gate Software Ltd 2014-2019
09:22:19 Info | VERBOSE: Parameters:
09:22:19 Info | VERBOSE: Source: imported.1.0 Database Package
09:22:19 Info | VERBOSE: Target: database 'Demo' on server 'x.x.x.x'
09:22:19 Info | VERBOSE: FilterPath: \\x.x.x.x\Database\Demo\db\state\Filter_Deployment.scpf
09:22:19 Info | VERBOSE: IgnoreStaticData: False
09:22:19 Info | VERBOSE: SQLCompareOptions: NoTransactions,IgnoreFillFactor, IgnoreTriggers
09:22:20 Info | VERBOSE: SQLDataCompareOptions: null
09:22:20 Info | VERBOSE: IgnoreAdditional: False
09:22:20 Info | VERBOSE: TransactionIsolationLevel: Serializable
09:22:20 Info | VERBOSE: IncludeIdenticalsInReport: False
09:22:20 Info | VERBOSE: AbortOnWarningLevel: None
09:22:20 Info | VERBOSE: IgnoreParserErrors: False

Best Answer

  • Options
    Andrew PAndrew P Posts: 194 Silver 3
    Hey Communited,

    Ignore Collations is a SQL Compare Option instead of a Filter - below is a screenshot of how you can add that to the deployment.

    Filters are for specific objects or object types - Options are for specific sql syntax. 

    Andrew Pierce
    Technical Sales Engineer
    Redgate Software


Sign In or Register to comment.