CODEWITHSUNDEEP
c#sql-serverazure
user2911539
user2911539

Reputation: 87

Deploying SQL Server & Web App to Azure

Can someone please tell me how to create my own SQL server database, & host it on Microsoft Azure?

I've followed this tutorial: https://learn.microsoft.com/en-us/azure/sql-database/sql-database-get-started-portal

But, it just shows you how to make essentially a copy of Microsoft's template database.

Can you please tell me how to deploy an SQL server database to Azure?

I know how to create a local web app, & then add a database to that later on, but I don't know how to deploy it to Azure?

Upvotes: 0

Views: 90

Answers (1)

Farooq Hanif
Farooq Hanif

Reputation: 1899

Go to portal.azure.com

1) create sql server

enter image description here

2) after that, select the newly created sql server and then click on New Database

3) when the database is created, select the sql server again, go to properties, note admin login and server name

4) add your ip in sql server firewall settings

5) remotely connect to the server using your sql server management studio by providing server name and admin login noted in step#3

6) run create database script

Upvotes: 1

Related Questions