CODEWITHSUNDEEP
sqlitesql-server-ce
PKHUN
PKHUN

Reputation: 13

Convert a SQL Server CE edition database file (.sdf) to a sqlite3 supported database file

I am looking for a way to support a existing SQL Server CE Database file (*.sdf) on a sqlite3. Can someone help me to find a way to Convert a SQL Server CE database file (.sdf) to a sqlite3 supported database file? Does sqlite3 library provide any utility to do so ?

Upvotes: 0

Views: 4274

Answers (1)

CL.
CL.

Reputation: 180070

You could export to a CSV file, then import that into SQLite. However, CSV files cannot represent all data types.

The tool at http://exportsqlce.codeplex.com/ allows to export a database as an SQL script, which can then be executed directly in SQLite to recreate it there.

Upvotes: 1

Related Questions