Migrating a database to Azure SQL

Creating backup and restoring it is not the only option on how to migrate the database to Azure. This process can be done without using a backup, directly migrating the database to Azure.

In order to do this, the first step is to select the database, click on bold Tasks and select the option to Deploy Database to Microsoft Azure SQL Database in SSMS. The first step is shown in this screenshot:

The second step is to connect to your Azure SQL Server. In order to do this, we select Connect... in the new window that opened after selecting the options in the first step. This window is shown in this screenshot: ...

Get Hands-On Cloud Administration in Azure now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.