How 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 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
- Export CSV file(s) from SQL CE, import into SQLite, or
- Use ODBC to connect to both databases and move data from one to the other
精彩评论