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:
Steps to migrate:
- Navigate to the file system where your SDF file is
- Copy/Paste the ExportSqlCE40.exe into the same folder
- Open a command prompt and change directory to the same folder above
- Run the following command:
ExportSqlCE40.exe "data source=INSERTDBNAMEHERE.sdf" database.sql
- You will then see a new file
database.sql
- Open SQL Server Management Studio > Create a new database
- Run the
database.sql
against the new database you just created
🙂