If you are looking to automate this, there is a way:
1) Generate the .bacpac file using SqlPackage.exe
For example:
“C:\Program Files (x86)\Microsoft SQL Server\110\DAC\bin\sqlpackage.exe”
/a:Export /ssn:SourceServerName /sdn:SourceDatabaseName
/tf:C:\DataExtraction\SourceDatabase.bacpac"
This would generate a bacpac under C:\DataExtraction\SourceDatabase.bacpac
for more info go here: SqlPackage.exe
2) Upload the bacpac to Azure Storage as Blob using Azure PowerShell
Switch-AzureMode -Name AzureServiceManagement
$context= New-AzureStorageContext -StorageAccountName "Storageaccountname" -StorageAccountKey "mystoragekeyhere"
Set-AzureStorageBlobContent -Context $context -Container adventureworks -File "NameOfLocal.bacpac" -Blob "NameofBacpacInStorageContainer.bacpac"
for more information on this cmdlet go here:
Set-AzureStorageBlobContent
Should you need to Import the following command will help you:
“C:\Program Files (x86)\Microsoft SQL Server\110\DAC\bin\sqlpackage.exe”
/a:Import /tsn:TargetServerName /tdn:TargetDatabaseName
/sf:C:\DataExtraction\SourceDatabase.bacpac"
Should you desire to use sqlpackage.exe
add the following directory to your PATH (instructions):
C:\Program Files (x86)\Microsoft SQL Server\110\DAC\bin\