How can I include a connectionstring for the build process, which isn't on Git?

Question

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?

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