How do I copy my SQL Azure database to a local SQL Server instance?
Use the SQL Azure Migration Wizard:


  The SQL Azure Migration Wizard (SQLAzureMW) gives you the options to
  analyzes, generates scripts, and migrate data (via BCP) from:
  
  
  SQL Server to SQL Azure
  SQL Azure to SQL Server
  SQL Azure to SQL Azure