views:

121

answers:

0

Hi,

Currently we are using xml files as local data store for our disconnected application, there is proposal to move to SQL CE database.

Can some one with experience of SQL CE provide some pros and cons of using sql compact, for example data type support etc. As Central DB server we are using SQL Server2005.

One of the requirement is to merge local store with central DB, and we don't want any data loss.

Thanks