1

I've extracted my connectionstring from Web.config to a separate file, which I do not include in my public git repository. How can I generate this file for appveyor to use, without having to publically share my database password?

I understand there is the "secure" variable, but how could I use this while generating my apps connectionstring?

Improve this question

1 Answer 1

Reset to default
1

I assume that you need this transformation for deployment with WebDeploy. In this case you can use parametrization. Also please read this support forum discussion and this StackOverflow post.

If your scenario is different, please elaborate.

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

3 Comments

That is not the case, sadly. The project itself (without WebDeploy) always depends on the MSSQL server and therefore also the connectionstring within connections.config. Without it, the build fails entirely. ci.appveyor.com/project/amivit/crawler2/build/6 So I need a safe way to include connections.config before build time, within the debug/release folder
In this case maybe you can simple edit web.config with PowerShell (stackoverflow.com/questions/20646769/…) and use secure variables (appveyor.com/docs/build-configuration/#secure-variables) to pass connection string to PowerShell?
Sounds like a reasonable suggestion, I will try it out. Thanks!

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.