How to migrate from SQL Compact Edition (sdf file) to SQL Server 2012 Express

[JohnS]

I have written a script to migrate the sdf file to SQL.

Converting Compact SQL database to SQL Express (script)

This collection of scripts will convert a Compact SQL (*.sdf) database to SQL Express 2012 database and update SambaPOS to use the database. Requirements 1… SambaPOS should be working using the Compact SQL database -> SambaPOS4.sdf 2… Install SQL Express 2012 exactly as documented here - DO NOT follow step 4. Using SQL Express 2012. and do not run SambaPOS after installing SQL Express. 3… Locate SambaPOS4.sdf and place all of the files from the attached ZIP file into this location. The locat…