CODEWITHSUNDEEP
sql-serversql-server-2008compact-frameworkimportsdf
Sven Hecht
Sven Hecht

Reputation: 1337

How to import a SDF file

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?

Upvotes: 9

Views: 27637

Answers (4)

Slider345
Slider345

Reputation: 4758

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.

Upvotes: 2

Sven Hecht
Sven Hecht

Reputation: 1337

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

Upvotes: 5

bart
bart

Reputation: 7767

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.

Upvotes: 0

GvS
GvS

Reputation: 52518

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.

Upvotes: 1

Related Questions