So I use Visual Studio Database project to publish my database to Azure.
By Default this publishes the database as S0 pricing tier. I then have to log into the Portal and change the Pricing tier to S1.
From this answer I can see someone set the ServiceObjective property when creating a database like so:
CREATE DATABASE
[{databaseName}]
(MAXSIZE={maxSize}, EDITION='{edition}',SERVICE_OBJECTIVE='{serviceObjective}'
After Changing the Pricing tier in the portal I run this command:
SELECT DATABASEPROPERTYEX('MyDatabaseName', 'ServiceObjective')
and it returns S1 so I am sure ServiceObjective is the right property
But my question is can I set this property after Creating a Database using Alter