Nick Randolph (fellow device dev MVP) and I have just achieved something this evening/morning (depending on timezone).
We have used SQL Compact to synchronise a database all the way from Sidney Australia to the Sheerness UK. That's a distance of 10,527 miles.
Here's the screenshot showing the synchronisation completing perfectly.

Thanks to Capespan's Kevin Cracknell's database that provided the sync. target.
You can see the Virtual Earth Map by clicking here
So just to recap, this shows that a partially connected database application can be used with a back-end database running 10,527 miles away.
Technorati Tags:
SQL Compact