Can I set database Collation on SHADOW database using SQL Change Automation
MatsE
Posts: 2 Bronze 1
Hi.
I am looking at the trial version of SCA with VS 2017. When creating the shadow database based on my target database baseline i get an error complaining on database collation when creating a stored procedure.
What I can see it depends on my target database and server has collation Finnish_Swedish_CI_AI but my development database server has collation Finnish_Swedish_CI_AS. When the shadow database is created the development server collation is used instead of the target database collation.
Is there a way to tell SCA to use the target database collation when creating the shadow database?
/Mats
I am looking at the trial version of SCA with VS 2017. When creating the shadow database based on my target database baseline i get an error complaining on database collation when creating a stored procedure.
What I can see it depends on my target database and server has collation Finnish_Swedish_CI_AI but my development database server has collation Finnish_Swedish_CI_AS. When the shadow database is created the development server collation is used instead of the target database collation.
Is there a way to tell SCA to use the target database collation when creating the shadow database?
/Mats
Tagged:
Best Answers
-
MatsE
Posts: 2 Bronze 1
I found a solution by using the pre-deployment script that creates the database. Just added "COLLATE Finnish_Swedish_CI_AI" to the CREATE DATABASE statement.
/Mats -
way0utwest
Posts: 312 Rose Gold 1
That's the place. The pre-script is what builds the shadow (and normal) db. Put things in there that you need done, database scoped config, multiple filegroups, etc.
Editor, SQLServerCentral
