tag:help.appveyor.com,2012-11-13:/discussions/questions/36547-build-and-deployment-config-database-tests-connection-string-with-roundhouseAppVeyor: Discussion 2019-06-11T21:01:14Ztag:help.appveyor.com,2012-11-13:Comment/471662472019-04-10T21:21:49Z2019-04-10T21:21:49ZBuild and Deployment Config Database Tests Connection String with RoundhousE<div><p>If you deal with Azure App Service, you can store all secrets in their App Settings. Watch <a href="https://azure.microsoft.com/en-us/resources/videos/configuration-and-app-settings-of-azure-web-sites/">this video</a> which is quite old but has a good explanation. Or you can google <code>Azure App Service App Settings</code> and get a lot of articles.</p>
<p>Regarding integration testing, for me it is easier to do it locally on AppVeyor build VM, using built-in <a href="https://www.appveyor.com/docs/services-databases/">services</a>.</p></div>Ilya Finkelshteyntag:help.appveyor.com,2012-11-13:Comment/471662472019-04-11T05:05:30Z2019-04-11T05:05:30ZBuild and Deployment Config Database Tests Connection String with RoundhousE<div><p>Thx. Initial build seems to be working now with automated localdb integration testing; and the Azure app settings for db connection string should work fine once I get it deployed...which is my current issue.</p>
<p>I'm working on my Environment deployment settings. I think Web Deploy should work but I also need to run a RoundhousE (rh.exe tool) command before deployment that will execute one or more SQL scripts on the product db server. The SQL script(s) are checked in and executed by rh. How can I run my sql scripts as part of deployment?</p></div>blaketag:help.appveyor.com,2012-11-13:Comment/471662472019-04-11T14:10:59Z2019-04-11T14:10:59ZBuild and Deployment Config Database Tests Connection String with RoundhousE<div><p>For deployment to Azure App Service, I would recommend <a href="https://www.appveyor.com/docs/deployment/azure-app-service-zip-push-deploy/">Zip Push deploy</a> -- it was implemented relatively recently as a replacement for Web Deploy.</p>
<p>Unfortunately we do not support custom scripts in Environment deployment at the moment. Workaround is <a href="https://www.appveyor.com/blog/2015/11/04/deployment-projects/">deployment project</a>.</p></div>Ilya Finkelshteyn