I am using Microsoft SQL Server Management Studio 2008 R2 to connect my SQL Azure account. I have had no problems connecting to the database.
However, when I tried to backup existing database from my local SQL Server and restore it using SQL Mgmt Studio, I saw a weird situation.
On my local database, when I right-click the database I can see options including but not limited to:
- Tasks -> Back up, Restore
however, when I right-click the remote SQL Azure database I connected, I don't see these options and what I see instead are "Extract Data-tier as Application, Register Data-tier as Application".
I want to restore backup binary file that I exported using "Tasks->Back up" from my local database.
Any ideas why Restore and Back up options do not show up on context menu of remote SQL Azure database?
EDIT: Later on I discovered SQL Azure Migration Wizard on Codeplex.