0

hell, I am completely new to azure

would like to know step by step to create sql server in azure and import a local db dump to it. Any pointers are appreciated.

Thanks

Evandro de Paula
  • 2,532
  • 2
  • 18
  • 27
user1464559
  • 29
  • 1
  • 2
  • What have you tried so far? – Dragonthoughts Jun 07 '18 at 18:37
  • went through few labs to get on to azure portal and create resource group, work with few properties such as create blob storage etc and publish a website. taking it to more real now. I have aken a subset of db dump and ready to store in cloud - was looking for a lab or step by step to be able to do it. Labs I searched online are a little bit advance, looking for a beginner lab to setup SQL server in azure and import db dump – user1464559 Jun 07 '18 at 21:00
  • I have azure basic pass from www.microsoftazurepass.com. Can someone please guide step by step (1) setting up sql server and creating a db in azure (2) import .bak to azure sql server db – user1464559 Jun 08 '18 at 05:59

2 Answers2

-1

You could follow Create an Azure SQL database in the Azure portal to set up azure sql server and create a sql database on azure.

A BACPAC file can be imported to Azure and can be used as a standard SQL database in Cloud.

Import using the Azure portal only supports importing a BACPAC file.

You could create a BACPAC file first and import the file into Azure, refer to this article.

Here is Import a BACPAC file to a new Azure SQL Database using azure portal or SQLPackage or powershell.

Joey Cai
  • 18,968
  • 1
  • 20
  • 30
-1

You can create an Azure SQL Database using Azure Portal as explained here, then you can use Data Migration Assistant to move your localdb database to your newly created Azure SQL Database server.

Alberto Morillo
  • 13,893
  • 2
  • 24
  • 30