After having many disasters with trying to getting merge replication to get work with occasionally connected mobile devices and PDAs using SQL CE we've decided to give the Synchronization framework a go.
We have a scheduling application which has a master SQL 2005 DB which updates SQL CE DBs on multiple mobile devices. The master scheduling table has a dateoccurs field which is when the event happens and this table can have records for multiple years in it - somewhere around 10s of thousands of records.
Obviously we don't want the mobile apps SQL CEs to have this many records - just the ones a week either side of the current date. Is there a way to filter the records being transferred using the Sync Framework to the mobile devices? I can't see any code on how to filter the data based on date anywhere on the M'soft site
Thanks!