Support different collations when validating (as part of build) and testing deployments
I want to use different collations when validating and testing my database.
1
vote

Some changes which we have made to SQL Change Automation projects now give you flexibility that will allow this behavior.
SQL Change Automation projects now have a Provisioning folder with a CreateDatabase.sql script in it. Modifying this script will impact how the databases used for validation are created. You can therefore use this to validate against different collations if desired.