Umbraco Cloud uses SQL Azure in the cloud, but for local environments it normally pulls the data down to a
local SQL CE database using 'dark magic.' You can, however, pull down the Dev database and restore it to a
local SQL Server install. For this, use database.ps1 PowerShell script. You may need to Set-ExecutionPolicy RemoteSigned
to run the script. If you are using Windows 7, you may need to configure powershell to use .NET 4
(see http://tfl09.blogspot.com/2010/08/using-newer-versions-of-net-with.html).
In the script, set the location of the folder where you want the DB bacpac file to get saved. Once the file is saved, in SQL Server Management Studio 2014 in the Object Explorer, right click