How to use Cloud migration in sql server

please go through more info bellow blog

http://itproguru.com/expert/2015/03/how-to-move-or-migrate-sql-server-workload-to-azure-sql-database-cloud-services-or-azure-vm-all-version-of-sql-server-step-by-step/

Simple solution is

Case 1 : Azure Sql cloud to your local DB

only schema or data ?

then go for generating script with data or without upto your needs.

once script is generated , if the size of the script is less means your directly execute that script in your local DB instance.

if the script size is very big in the sense , upload that script to blob storage note down file location.

in your DB instance go for import the script with cloud option and give a proper credentials of storage and file name.

rest of the work sql server will take care.

Case 1 : Local DB to your Azure Sql

same process you need to follow.