How can we help you today? How can we help you today?

How to "ignore collation" in the scpf Filter

Hi,

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
Bas_K
0

Comments

2 comments

Sort by
  • Andrew P
    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. 

    Cheers,
    Andrew P
    0
  • Bas_K
    Hi Andrew,

    Thank you! It is working, now I know what these options are and how to use it helps me a lot.
    Bas_K
    0

Add comment

Please sign in to leave a comment.