Provide ability to replicate to Azure non-Azure SQL Server
Allow data to be transactionally replicated to the cloud, with an alternative way (SFTP?) to provide snapshot initialization data.
Cant SSIS do this out of the box?
Akash Kava commented
@LiamCa, Replication is different then Data Sync, replication is a must because, what happens Azure's DB gets corrupt or loss of data happens and MS says its your fault, we only promise uptime, you should have taken backup !!! thats what all hositng providers do !! Replication is smarter choice to have most recent backup as well as do some local reporting and other similar benefits.
Have you taken a look at SQL Azure Data Sync? http://www.microsoft.com/windowsazure/developers/sqlazure/datasync/