0

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?

Improve this question
8
  • 1
    You can connect SSMS directly to Azure. Commented Jun 2, 2017 at 20:43
  • I haven't used SQL Server Management Studio before, but I have added .mdf files in Visual Studio before. Commented Jun 2, 2017 at 20:45
  • 1
    Maybe this link will help you visualstudio.com/en-us/docs/build/apps/aspnet/cd/…. It's for .NET but it may give you an idea. SSMS is free though, so now is as good a time as any to install it and familiarize yourself with a SQL back end if you are developing an application utilizing it. Commented Jun 2, 2017 at 20:48
  • 1
    If you have already gone through the tutorial to create a database then it should be available to connect to in Azure. You just need to follow the steps to whitelist your computer in the Azure options, then connect via SSMS. Commented Jun 2, 2017 at 20:53
  • 1
    Use this tutorial instead: learn.microsoft.com/en-us/azure/sql-database/… The other one shows you how to use the Microsoft template database called "Adventureworks". Which is helpful for learning because a lot of the MS docs reference Adventureworks databases. Commented Jun 2, 2017 at 20:57

1 Answer 1

Reset to default
1

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

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.