Import and Export data from SQL Azure

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

SQL Azure connection string

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=&quot;Server=tcp:[serverName].database.windows.net;Database=[myDataBase];User ID=[LoginForDb]@[serverName];Password=[myPassword];Trusted_Connection=False;Encrypt=True;&quot;” providerName=”System.Data.EntityClient” />