Migrate from SQL Compact Edition to SQL Server
The installation of Orchard CMS is really fast and you do not even need SQL Server because Orchard CMS can run with SQL Server Compact. SQL Compact is great for development and small websites e.g. Landing Pages. In this post I will show how to migrate from SQL Compact Edition to SQL Server in 5 simple steps.
Download the ExportSqlCE40.exe from here and copy the ExportSqlCE40.exe to SDF location e.g. \src\Orchard.Web\App_Data\Sites\Default
Open CMD in the SDF folder (Shift + Right Click, …Read More