One of the problems I was encountering while programming under the Microsoft Stack was a lack of modularity: if you wanted to write C# code and run it on something other than IIS, you're in for a lot of work. If you wanted to switch your database to something more flexible, cheaper, and portable than SQL Server, you're not going to have a good time. If you want to integrate open-source projects and they aren't supported or updated on NuGet, you're in for a dependency fight. If you want to run…
So, you're interested in porting over your Umbraco site from SQL Server CE. There are a number of benefits, the most important of which is scale and security: SQL Server CE can only contain up to four gigabytes of information and is fast approaching being out of date and unsupported. Naturally, as a site administrator, you'd prefer to use SQL Server from this decade. We went ahead and ported our website from SQL Server 2008 CE to SQL Server 2015. Here's how to do it: Step 1: Port over your cu…