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
Anonymous
shared this idea
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.