SQL Server: how to restore on Azure?

Alex A
Alex A used Ask the Experts™
on
Hi, I have a sample SQL Server 2016 database back up and would like to restore it on Azure SQL Database. Any ideas?

Thank you in advance.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
SQL Server DBA & Architect, EE Solution Guide
Awarded 2009
Distinguished Expert 2018
Commented:
Yes, you can restore your local database backup to Azure with the below steps..
1. Restore your backup to your Local SQL Server machine.
2. Right click the database -> Tasks -> Deploy Database to Windows Azure SQL Database
3. Connect your Azure database and give the details.

More details and options below..
https://www.mssqltips.com/sqlservertip/3035/using-the-deploy-database-to-sql-azure-wizard-in-sql-server-management-studio-to-move-to-the-cloud/
Vitor MontalvãoMSSQL Senior Engineer
Distinguished Expert 2017
Commented:
@Raja, that's a very old article. Azure is changing very fast, so an article from 2013 isn't valid anymore.
I've wrote a more recent article about how to migrate a SQL Server database to SQL Azure as there is no RESTORE command for SQL Azure.
Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
Awarded 2009
Distinguished Expert 2018

Commented:
Thanks Vitor for providing the latest article(your article is good)
Even though the wizard pages changes, hope I have guided the steps correctly.. :)

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start Today