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?
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.
I was looking out to see if you could use ODBC to directly access the database file, but apparently, no... According to this forum thread your best bet is to try to access it through OLEDB/ADO.
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