0

I'm currently creating a solution for a software that were developed in 2005 and beside using some more modern technologies, the company wants to keep supports of the old windows embedded compact edition based phones until they can replace everything.

I tried using ErikEJ's Export2SQLCE and SqlCEcmd command tools and thought I found the solution, until I realised the older application is using SQL Server CE version 3.0, whereas ErikEJ's can only convert to 3.5 or 4.

Is there any way to convert an existing SQL Server table into SQL Server CE version 3.0?

If not, is there any way to connect into a SQL Server CE file (.sdf) from a nodejs server and send queries?

Thanks!

Improve this question
3
  • Update your solution to use 3.5 ? Commented Apr 13, 2021 at 14:07
  • Unfortunately, I cant. The solution is something old, that is currently running on 400 different devices around the world, and the company would rather not ask them to get sent back just to update the solution. keep in mind that its really old, and the newer solution involves an express server with a react client, this is just to enable usage of the older devices until they are disposed Commented Apr 13, 2021 at 14:11
  • It should be possible to re-build SQLceCMD against 3.1. Commented Apr 13, 2021 at 15:26
Related questions
11
Methods to migrate SQL Database (mdf) to SQL Compact Edition (sdf)
0
Converting an SQL Server database to an SQL Server Compact database. And back
1
how to convert an SQL server 2005 .mdf to SQL server CE .sdf?
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.