Way to diff two SQL CE Databases

views:

answers:

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 databases 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.

+1 A:

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.

ErikEJ 2010-08-09 17:10:04

+1 A:

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.

Dour High Arch 2010-08-10 00:05:38

I am trying to be able to roll out a new version of my database with out having to overwrite the database (on a local sql ce db). The hope was to make it part of my build process (just output a change script that can be run on the client machine). I will take a look at Merge Replication just in case it can help me.

Vaccano 2010-08-16 16:53:24

ansaurus

tags:

views:

answers:

Way to diff two SQL CE Databases

related questions