How do I copy SQL Azure database to my local development server?

Question

Does anyone know how I can copy a SQL Azure database to my development machine? I'd like to stop paying to have a development database in the cloud, but it's the best way to get production data. I copy my production database to a new development database but I'd like to have that same database local.

Any suggestions?

Answer 1

You need to have Microsoft SQL Server Management on your computer and then connect to your Azure SQL Database. 

Here are the steps: