Talking about cloud based things, I hope SQL Azure can implement back most useful features soon.

For example, something like generate create/alter SQL statement for changes... Now I have to look at multiple instances and hand-pick the changes from design view one by one. Can't imagine if I have to hand-pick in order to sync schemas across more instances...

Now the "next best" solution is to use a local instance of SQL server as master schema and do all the modifications here, then generate script to deploy to SQL Azure. It could work but is suboptimal I think.