0

I have a project that is running on a local SQLExpress server. I have exported my database to a .bacpac file.

I am trying to restore that DB to an Azure SQL server. So what I am trying to do is to create a DB on Azure using this back-up file.

How can I do that?

Hussam Ahmed
  • 413
  • 1
  • 5
  • 17
  • There's already a microsoft guide for this. https://learn.microsoft.com/en-us/azure/azure-sql/database/database-import If you have trouble you can ask your Azure account manager also. – Hitobat Sep 16 '20 at 19:07

2 Answers2

0

The easiest way to migrate a database to Azure SQL Database is using Data Migration Assistant (DMA). This tool performs an assessment first to verify the database does not use incompatible statements with Azure SQL Database, and it also migrate the schema and/or the data, as you wish. Download it from here.

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

I imported it through SSMS by connecting to my Azure SQL server and doing import data-tier application

Hussam Ahmed
  • 413
  • 1
  • 5
  • 17