local database synchronization between sql server database and local sql ce database

Im implementing application in which there is local database which uses S开发者_如何转开发QL CE. Each time app starts there has to be synchronization between local database and server database (to have new values in dictionary tables).

Problem is that mappings are different in sql ce and sql server 2008 when using entity framework.

Is it common problem ? is there any way to automate that ? Do you know about any good pattern ?

thanks for help, bye

You can use Merge replication, which supports (almost) all SQL Server 2008 datatypes. Issues relating to EF seem to be unrelated, can you elaborate... You must create the model based on a SQL Compact database, you cannot use a model created against a SQL Server database with a SQL Compact database

Have you tried ADO.Net Synchronization framework? See here