1

I'm deploying an environment in Azure using ARM Templates. I'm using Azure SQL Server and 4 databases. I went to restore a bacpac file and got an error complaining about different collation settings between my master database and the database my team is working on.

Is it possible to set the master database collation to be SQL_Latin1_General_CP1_CS_AS and not SQL_Latin1_General_CP1_CI_AS (note the CI vs. CS)? The database we're using has to be SQL_Latin1_General_CP1_CS_AS and we want the master to match it as well.

0

A few pointers. This article talks about changing collation for the database. This article talks about master db and specifically mentions that its collation is equal to the server collation. Looking at the rest api to create Azure SQL server - its not possible to define collation at creation time >> not possible to change it.

But looking at this you shouldn't need to.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.