开发者

How Convert SQL CE 3.5 database to SQLite

开发者 https://www.devze.com 2023-02-16 15:40 出处:网络
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 did some t开发者_如何学Goesting on SQLite and thi is much faster.

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 did some t开发者_如何学Goesting on SQLite and thi is much faster.

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


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


  1. Export CSV file(s) from SQL CE, import into SQLite, or
  2. Use ODBC to connect to both databases and move data from one to the other
0

精彩评论

暂无评论...
验证码 换一张
取 消