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

Sign In or Register to comment.