As you might know SQL Server Compact Edition (SSCE) in its newest version 4.0 is not supported on Windows CE or Mobile.
No kidding, I know this sounds weird for a technology originating from these devices.
But focus seems to have “shifted” a bit for Microsoft.
However, one feature I always admired in SSCE is the easy data transfer through merge and snapshot replication as well as Remote Data Access (RDA). And guess what, this is not supported in 4.0, as well.
A new version taking away essential features for the embedded market is quite a blow. Sad, I must say, but there seem to be a workaround to re-enable a very usable mobile feature as fellow MVP Erik Ejlskov Jensen found out. He has even provided some source code as am example.
All not supported of course!
Cheers to Erik!