Create and download a backup from SQL Azure Database Service

database

Open command prompt and run the below command. In this case you’ll need to create C:\backups folder first.

"C:\Program Files (x86)\Microsoft SQL Server\110\DAC\bin\SqlPackage.exe" /Action:Export /SourceServerName:"tcp:xxxxx.database.windows.net,1433" /SourceDatabaseName:DbName /SourceUser:user /SourcePassword:password /TargetFile:C:\backups\backup.bacpac

You will need to replace the bits in bold with whatever is relevant for you.