Microsoft Azure SQL Database, there are good reasons why outsourcing to the cloud makes sense for many applications.
Microsoft Azure SQL Database provides a SQL Server-based, multi-tenant database as a service in the Azure cloud, removing IT hardware and server management tasks from your data center.
Azure platform as a service (PaaS) allows you to dynamically resize your databases and increases their scalability. In addition, Azure SQL Database provides automatic administration and data protection. With Azure SQL Database, Microsoft provides all of the infrastructure support, security and software updates, as well as automatic backups and disaster recovery failover.
SQL Server databases to Microsoft’s PaaS, the process essentially requires you to first create an Azure SQL Database using the Azure Portal and then test if your current database is compatible with Azure SQL Database. You need to fix any compatibility issues you might find before performing the migration.
There are a number of ways to test if your database is compatible with Azure SQL Database. One of the easiest ways is to use the Export D
ata-tier Application function in SQL Server Management Studio (SSMS)
Export Data-tier Application wizard. Click Next on the introduction dialog to display the export settings dialog. You will have the option to save the BACPAC file to either the local disk or to Microsoft Azure. To check compatibility, it’s best to select the save to local disk option.
-> Migrating databases with SQL Server Migration Wizard <-
There are several methods available that you can use to migrate your on-premises database to Azure SQL Database. The most direct method is probably to use the Deploy Database to Microsoft Azure SQL Database wizard option from SSMS, which migrates a compatible SQL Server database directly to Azure SQL Database.
To begin the migration, open SSMS and use Object Explorer to navigate to the database you want to migrate. Then, right-click the database and select Tasks. Next, click Deploy Database to Microsoft Azure SQL Database.
This will start the Deploy Database to Microsoft Azure SQL Database wizard. Click through the introduction screen to display the Deployment Settings dialog. The database name will be displayed under New database name and the Temporary file name will specify the local directory and file to
Azure SQL Database server connection name. If you click on the Server name link, you can copy it to the clipboard and paste it into the Connect to Server dialog.
Before you can connect to the server from your client system, you will probably need to set up an Azure SQL Database firewall rule. The firewall works by creating exceptions for one or more client IP addresses, allowing these addresses to have access to the Azure SQL Database server.
— Microsoft Certified Solutions Associate (MCSA)