How to import a SDF file

sql-server sql-server-2008 compact-framework import sdf

sql-server sql-server-2008 compact-framework import sdf

CodePlex has a couple of tools now which perfectly address this question.

These are IDE extensions.

If you are using SQL Server Management Studio Express or higher, get this one.

If you are using Visual Studio 2010 Pro or higher, get this one.

sql-server sql-server-2008 compact-framework import sdf

This is harder as it looks, because it doesn't seem to work with the SQL Server Import and Export wizard.

You could write a small program, that gets all data from your SDF file table by table/record by record, and then inserts them into the SQL database.

CodeHunter