Migrating SQL server compact 3.5 to Sqlite

Srikanth Aakuthota 1 Reputation point
2022-11-07T11:15:01.687+00:00

Hi,

We are migrating our operating system from WEC7 to WEC2013, and as part of that migration, we are moving our database from SQL Server compact to SQlite.

What is the best way to upgrade the customer database in the field without losing data? Please share your experience if you have one.

Part of my research I found that ExportSqlCe.exe (thanks to ErikEj) can be used to export your database schema and data, later using sqlite3.exe to create Sqlite database by importing the file exported. This would not solve my problem as these tools are developed to run on regular .Net framework runtime. However we need these tools to run on .net Compact Framework runtime.

Regards,
Srikanth

Windows for business Windows for IoT
SQL Server Other
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.