Replication / sync SQL Server [MDF] database to CE database [SDF]

I have two database in SQL Server - one on a server-version as a MDF/LDF file and one CE database (SDF file) with the same structure ..

I'm required to do sync/replicate between these two databases .开发者_开发百科. is this scenario possible ?

---

This is definitely possible... there is a framework for this kind of stuff from MS - see http://msdn.microsoft.com/en-us/library/bb726002.aspx

EDIT:

Another option though not as flexible would be to use replication... for details see http://msdn.microsoft.com/en-us/library/ms171850%28v=sql.100%29.aspx