Geek Answers Handbook

How to convert SQL CE 3.5 database to SQLite

I started a project using SQL CE 3.5 in Visual Studio 10. But now I found out that the database is very slow. I tested SQLite a bit and it is much faster.

Is there a way that I can easily convert a SQL CE 3.5 database (sdf) to SQLite?

+7
source share
2 answers

I have a tool to "flush" the entire SQL Compact file as an SQL script, which can then be run against SQLite db - http://exportsqlce.codeplex.com

+11
source
  • Export CSV files from SQL CE, import into SQLite or
  • Use ODBC to connect to both databases and move data from one to the other.
+2
source

More articles:


All Articles