Restore SQL Azure Bacpac in local SQL SERVER

You can restore the bacpac file from a SQL Azure Database in a local SQL SERVER Deploy, using the Management Studio.

1. Just Right click on Connection > Databases and select "Import Data-tier application..."
2. Select "Next" on the introduction step.
3. Click Browse to locate the bacpac file
4. Alternatively, you can import from a bacpac file in the AZURE storage, but I wouldn't recommend that due to performance issues
5. Click Next

An you are all set


Check out my new book about R Language http://www.amazon.com/dp/B00SX6WA06