How to restore a On-premises SQL SERVER DB to Azure SQL Data Base

Question

I want to restore my SQL SERVER DB from local system to Azure SQL DB.

The DB is exist in my local system , I will take the backup of the DB.

Now what are the steps do I need to follow to restore this DB on Azure SQL DB

Answer 1

Hi, @Bharathi Welcome to Microsoft Q&A, Thanks for posting your question,
Thanks, @Nandan Hegde for your contribution and providing the documentation.

Here are the steps where you can also follow using DAC package
Moving schema from on-Premise SQL database to Azure SQL database

select extract Data-tier Application as shown

Click on next and Provide the location where the file should be placed,

Click on next under validation and summary, Build Package screen is displayed click on finish once done

Once the dacpac file is created. connect to Azure SQL Db from SSMS, right-click “Databases” and select “Deploy Data-tier Application”.

Click on next on Deploy Data- tier Application
Select Package screen is displayed browse the path where dacpac file created
Update configuration screen is displayed click Next
Click next on the summary, Deploy DAC screen is displayed
Click Finish
It is now completed and we should see the database in Azure,

Please let us know if you face any issues or need more information.

Regards
Geetha

Answer 2

Hey,
The below link provides step by step details for the same:
sqlshack.com/migrate-an-on-premises-sql-server-database-to-the-azure-sql-database/