Way to diff two SQL CE Databases

I know ways to script a SQL CE Database, but does anyone know a way to diff two 开发者_如何学Pythondatabases and output a script sync one of them to the other (ie generate drops and inserts to make them the same).

I am looking for a way that I can update my hand held applications without having to copy over the existing database. The first step is to be able to make a change script.

Script the two SQL CE databases, and load them into 2 SQL Server Express tables, and use one of the many SQL Server compare tools to compare these.

Are you trying to copy changes in a local SQLS CE database to another local CE database? Or are you trying to replicate changes between multiple CE clients with internet access? If the latter, check out SQLS CE Merge Replication.