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

Question

Hi,

Im implementing application in which there is local database which uses SQL 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

Answer 1

Have you tried ADO.Net Synchronization framework? See here

Answer 2

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