How do I set SQL user password while deploying the database project using CI CD pipeline

Question

I am working on database project which is a .sql project in Visual Studio.I am creating user like this:

CREATE USER [MyUser] WITHOUT LOGIN;
GO
ALTER ROLE [db_datareader] ADD MEMBER [MyUser]
GO
ALTER ROLE [db_datawriter] ADD MEMBER [MyUser]
GO
ALTER ROLE [db_executor] ADD MEMBER [MyUser]
I built dacpack in VSTS Build and deployed it to Azure in VSTS Release.
How do I setup the continuous deployment so that it will create user with password? Can anyone help me with this.
Thanks.

Answer 1

While you are trying , just try the below option as well.

This plug-in in Azure Marketplace maybe useful.

You can also create logins using PowerShell as it is also an option for you and includes conditional execution.

You can find another alternatives which are explained.

Hope this helps.