This is simple step by step guide to deploy your on-premises (or even cloud) Microsoft SQL database to Azure SQL database service with data. Simply, this is a data migration to Azure SQL.
You have to make sure you have an Azure tenant with an active subscription to proceed with the next few steps. I have downloaded and installed AdventureWorks2014 database in my own machine for the demonstration.
One more prerequisite, you need to have a SQL database server in Azure. Your server name should look be similar to yourservername.database.windows.net.
Once the above steps are done, you will be allowed to set the pricing tier for the server. This is bit of a tricky thing as there are DTUs for each tier. The resources and power of each service tier and performance level for Microsoft's Azure SQL cloud databases are expressed in terms of Database Throughput Units (DTUs). The available resources will vary based on the DTUs. So till we complete the data migration, it’s better to stay within the standard tier.