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

0 votes

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.

image

Apr 10, 2018 in Jenkins by Atul
• 10,240 points
71 views

1 answer to this question.

0 votes

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 here.

Hope this helps.

answered Apr 10, 2018 by shubham
• 6,890 points

Related Questions In Jenkins

0 votes
1 answer

How do you implement CI/CD using Jenkins?

Continuous Integration using Jenkins and Git plugin Create ...READ MORE

answered Aug 30 in Jenkins by Sirajul
• 25,180 points
261 views
+4 votes
7 answers

How to set the pipeline name and description for a Jenkinsfile?

You can rename pipeline jobs in jenkins ...READ MORE

answered Oct 11, 2018 in Jenkins by Hannah
• 14,070 points
6,655 views
0 votes
1 answer

How do I pass value from my Fake # script to the host build server (Jenkins)

You can use the EnvInject plugin to pass environment ...READ MORE

answered Jul 11, 2018 in Jenkins by Kalgi
• 2,620 points
92 views
+13 votes
2 answers

Git management technique when there are multiple customers and need multiple customization?

Consider this - In 'extended' Git-Flow, (Git-Multi-Flow, ...READ MORE

answered Mar 26, 2018 in DevOps & Agile by DragonLord999
• 8,380 points
145 views
0 votes
1 answer
0 votes
1 answer

Error while talking to remote Oracle DB using Jenkins-CI

I installed Oracle XE to talk to ...READ MORE

answered May 1, 2018 in Jenkins by shubham
• 6,890 points
250 views
0 votes
1 answer

Error while communicating with remote Oracle DB through Jenkins-CI

I was also facing the same problem. ...READ MORE

answered Apr 25, 2018 in Jenkins by shubham
• 6,890 points
75 views