9

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?

Sven Hecht
  • 1,337
  • 1
  • 16
  • 23

4 Answers4

5

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

Sven Hecht
  • 1,337
  • 1
  • 16
  • 23
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.

Slider345
  • 4,558
  • 7
  • 39
  • 47
1

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.

GvS
  • 52,015
  • 16
  • 101
  • 139
  • I also want the schema of the tables not just their content. If I could just convert the sdf tables into sql... – Sven Hecht Nov 14 '08 at 13:25
0

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.

bart
  • 7,640
  • 3
  • 33
  • 40