How to import a SDF file

Question

I started using a Sql Compact version of my DB and during the development it occured that the DB needs to be accessible over the network. Cause I wasn't able to find a way to share the SDF file over net without replication I need to import it into SQL Server 2008 (Express).

Any Ideas?

Answer 1

I solved my problem. GvS's advice gave the keywords to search for: http://bembengarifin-tech.blogspot.com/2008/08/generate-script-export-data-from-sql-ce.html

Answer 2

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.