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

Can I set database Collation on SHADOW database using SQL Change Automation

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?


Best Answers

  • Options
    MatsEMatsE 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.
  • Options
    way0utwestway0utwest Posts: 313 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.
Sign In or Register to comment.