While planning to move your existing applications to Azure, one of the key considerations is how to move your existing on premise SQL server database to cloud. There is more than one way to accomplish this based on the specific requirement. For example, if you cannot afford down time between migration, the way forward is to use transactional replication setting your on premise database as publisher and your Azure SQL database as subscriber.
If real time migration isn’t a concern, you can go for exporting export your data (as .bacpac file that encapsulates a database’s schema and data) and importing it in your Azure database. Another solution is to deploy your on premise database directly to Azure as described below.
The feature to deploy database from SSMS to Azure was introduced in SQL Server 2012 and is available in SQL Server 2014 as well.
Note that the firewall settings for your Azure database server should be allowed to accept connections from your client IP.
The deployment wizard will let you to specify the connection and migration options as below.
Click on Finish to let the deployment/migration to complete