A very useful guide to understand how to import/export data from SQL Azure to SQL Server 2008 R2 is available at
http://blogs.msdn.com/b/sqlazure/archive/2010/05/19/10014014.aspx
A very useful guide to understand how to import/export data from SQL Azure to SQL Server 2008 R2 is available at
http://blogs.msdn.com/b/sqlazure/archive/2010/05/19/10014014.aspx
Use this connection string to connect to SQL Azure database
<add name=”DatabaseEntities” connectionString=”metadata=res://*/Database.csdl|res://*/Database.ssdl|res://*/Database.msl;provider=System.Data.SqlClient;provider connection string="Server=tcp:[serverName].database.windows.net;Database=[myDataBase];User ID=[LoginForDb]@[serverName];Password=[myPassword];Trusted_Connection=False;Encrypt=True;"” providerName=”System.Data.EntityClient” />