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

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

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
Mats Eliasson
0

Comments

2 comments

Sort by
  • MatsE
    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
    MatsE
    0
  • way0utwest
    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.
    way0utwest
    0

Add comment

Please sign in to leave a comment.