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
精彩评论