Change connection string for LS app deployed to SharePoint on Office365 RRS feed

  • Question

  • Hi

    I have a LS application, it connects to a DB, but when I publish to SharePoint (mine is in Office365), the only way to change the connection is to open the project, change it in there, and republish.

    This isn't good for dev to prod deploys of course!

    Thursday, October 31, 2013 5:56 PM


  • Mark - This is a known limitation.  The best advice I could give you is to modify the web.config directly.  Depending on your deployment setup this can be possible. For example in Azure Web Sites deployment (assuming you did a provider hosted publish) you can access the web.config through there and change the connection string. The DB schema would of course have to be the exact same if you did change the connection string.

    HTH - Matt Sampson

    R. Matt Sampson

    • Marked as answer by Angie Xu Tuesday, November 5, 2013 7:42 AM
    Thursday, October 31, 2013 8:10 PM