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
on "Databases" for your local database and select "Import Data-tier Application" to run the wizard.
Select the file created from the PowerShell script. Name the new database something convenient.
After the db is created you will need to create a user and configure the website to connect to it.
I got this from Umbraco Support but I don't see it documented, so I thought I'd share it here.
We have a database which we developed locally before using Umbraco cloud. How we can restore that local database to Umbraco cloud? Would you help with us because we didn't hear any support from Umbraco HQ?