More and more companies are using cloud infrastructure to host their applications and databases. In this article we will discuss the high level steps to move on-premises SQL Server database to Azure SQL database using Microsoft SQL Server Management Studio:
- Download and install the latest version of Microsoft SQL Server Management Studio, old version can give unexpected errors as now Azure SQL databases have almost same set of features as on-premises databases can have.
- Right click on the database to deploy to Azure, click on Tasks and Deploy Database to Microsoft Azure SQL Database.
- Follow the wizard, enter deployment settings (you must have an Azure subscription), click next, verify the details and submit the migration process.
There are some other ways as well to migrate the database to Azure but we found this very intuitive.
Hope it will help you in your next migration.