Category: SQL Server

Umbraco’s site installation comes with an SDF database. For obvious reasons, I needed to migrate this to SQL Server. Below are the steps I took to make it work. Before proceeding to the steps below, you will need to install following: ExportSqlCE40.exe which you can download from here SQL Server Compact 4.0 Runtime from here

Took me a while to find out, but deploying a SQL Server database to Azure is actually very easy. Make sure you have your Azure connection details ready! The below instructions / screenshots are from SSMS 2016. Should work for older versions too, although you might see different wordings. Open SQL Server Management Studio (SSMS) and