How can I remove connection strings from a web deploy package?

Question

I have a few web applications using the same databases. I'm deploying them all in the same "Web site" on IIS. The connection strings will be set at the "Web site" level and inherited in the "Applications". When I make a publish package, it gives me a list of the connection strings in the web.config but doesn't let me choose to remove them. I have to change the value or leave it empty (which uses the one in my local web.config).

The goal is to end up with a "clean slate" package that I can publish in different "Web site" that has their own connection strings (production server vs staging vs development for example). I want to be able to deploy a package to the staging environment for testing and, after testing, deploy that same package to production.

Jocke · Accepted Answer · 2015-03-18 20:47:43Z

2

I would use web.config transformations to solve it. Then you can have different connection string for web.debug.config / web.production.config / we.test... and so on. You can replace in the connection string or the entire element. Here is a start: https://msdn.microsoft.com/en-us/library/dd465326%28v=vs.110%29.aspx

answered Mar 18, 2015 at 20:47

Jocke

2,3041 gold badge18 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Jocke Over a year ago

If you create different config for each environment you (or a tool like Octopus deploy) will execute the transformation on deploy. Your package (created on build) will contain all config transforms but it will be applied on deploy. Perhaps not your idea on "clean slate" but it works.

Collectives™ on Stack Overflow

How can I remove connection strings from a web deploy package?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related