Rob Tiffany (MS) is setting up an amazing SQL Mobile replication extravaganza for MEDC next week, which looks great.

http://blogs.msdn.com/robtiffany/default.aspx

One of Rob's screenshots shows some Windows Console applications syncing back to the 4 tier SQL Mobile environment.      That got me thinking, up until now I'd never tried building a proper .Net desktop application that will synchronise  just like a mobile device.

So today I thought I would give it a try.     After installing SQL Compact from

http://www.microsoft.com/downloads/details.aspx?FamilyID=e9aa3f8d-363d-49f3-ae89-64e1d149e09b&DisplayLang=en

I had a go at porting a mobile app. just to test the concept

15 minutes later,   I got it all working.    It works so, so well...

I'm now thinking about using a SQL Compact data-source for a Web-site.   It will be much cheaper to do this than pay for a hosted SQL Server.  Hmmm possibilities...