Is there a tool to migrate a SQL Express Database to SQL CE?

Question

Are there any tools available (prefer if free) to transfer tables and data from SQL Express 2005 to SQL CE 3.5?

I have a small app that uses SQL Express and since it is using Linq-to-SQL I want to change it to use SQL CE 3.5 so that users don't need to install the DB engine in order to use it and to simplify backups having them only copy the .sdf file.

Answer 1

I just need the same yesterday. Googling I have found two options:

Better Option: Primeworks Data Port Wizard

Works great for me. Is full trial for 30 days

An option that didn't work for me:

Johny Cant Code Exporter free (google it, SO dont letme post another link)

Cheers

Gaspar