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
1,016 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
• 7,340 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, 2019 in Jenkins by Sirajul
• 59,230 points
1,284 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
• 18,570 points
34,957 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,680 points
1,137 views
0 votes
2 answers
+15 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 27, 2018 in DevOps & Agile by DragonLord999
• 8,450 points
3,439 views
+2 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
• 7,340 points
1,657 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
• 7,340 points
761 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP