Restoring a SQL Database from an On-Premises SQL Server to an Azure Cloud

You can restore SQL databases from an on-premises SQL server to an Azure cloud.

The destination instance must be the same version or a later version of SQL than the source instance.

Note

When you restore an on-premises database to the Azure cloud, the restored database uses the standard tier model.

Procedure

From the navigation pane, go to Protect > Databases.

The Instances page appears.
In the row for the instance, click the action button , and then click Restore.

The Backup content dialog box appears.
Select the content to restore, and then click Restore.

The Restore options dialog box appears.
On the Out of place tab, do the following:
1. From the Destination instance list, select the Azure cloud instance to restore the data to.
2. From the Proxy server list, select the access node to use for the restore.
3. In the Staging path on proxy server box, enter the location to stage the Azure BACPAC file in.
  
  When you select the staging path, do one of the following so that the restore completes successfully:
  - Enter a location that is on the destination server.
  - Rename the database.
Click Submit.