SQL Server Database[Answered] RSS

• • Reply
  rkrex

  Member

  282 Points

  298 Posts

  SQL Server Database

  Jun 28, 2018 06:23 PM|rkrex|LINK

  I have a .Net Core application that is using a SQL Server Database. I know how to deploy a project or application to Azure that's not using a database. But what if I want to deploy an application that is using a sql server database. Do I create a SQL Server Database on Azure and then connect to it? If so what happens to all of my existing connectionstring settings in the web.config file? Thanks !

• • Reply
  ryanbesko

  Contributor

  7048 Points

  2189 Posts

  Re: SQL Server Database

  Jun 28, 2018 07:46 PM|ryanbesko|LINK

  rkrex

  Do I create a SQL Server Database on Azure and then connect to it?

  Yes.  You will have a server address available in the Azure portal that you use in SSMS on your local machine to connect to SQL Server on Azure.  You can either backup your database and restore it to Azure or script it all and run that script on Azure.

  rkrex

  If so what happens to all of my existing connectionstring settings in the web.config file?

  Use Web.config transforms: https://msdn.microsoft.com/en-us/library/dd465326%28v=vs.110%29.aspx?f=255&MSPPError=-2147217396

  <?xml version="1.0" encoding="utf-8"?>
  <configuration xmlns:xdt="http://schemas.microsoft.com/XML-Document-Transform">
    <connectionStrings xdt:Transform="Replace">
      <clear />
      <add name="YOUR_CONNECTION_STRING_NAME" connectionString="Data Source=YOUR_AZURE_SERVER_NAME;Initial Catalog=YOUR_DATABASE_NAME;Integrated Security=True;MultipleActiveResultSets=True" providerName="System.Data.SqlClient" />
    </connectionStrings>
    <system.web>
      <compilation xdt:Transform="RemoveAttributes(debug)" />
    </system.web>
  </configuration>

  EDIT: Right-click the Web.config file in your project and you will see the choice "Add Config Transform" on the popup menu.

  Mark all posts that give the desired result the answer. If you only mark the last that gave you clarification because you misread an earlier post others will be confused. Some of us are here to help others and our point to post ratio matters.
• • Reply
  rkrex

  Member

  282 Points

  298 Posts

  Re: SQL Server Database

  Jun 28, 2018 09:22 PM|rkrex|LINK

  Thanks very Much !