Tracking Changes in SQL CE

[DaveD]

Hi,

Apologies if I'm in the wrong newsgroup.

We are developing a PDA app that uses SQL CE.
However we will be synchronising with various non SQL
Server data sources and will have to develop at least some
of our own custom data synchronisation solutions.
We are looking for a means to track changes on the SQL CE
database. We only want to synchronise added/edited/deleted
data.

We are aware of the RdaTrackOption to track changes in
data since the last 'pull' when making use of RDA on the
PDA.
Is it possible to make use of the functionality of RDA
when the synchronisation is not strictly tied to SQL
Server ?
We would still be 'pulling' data but it wouldn't always be
from a SQL source.

If the RdaTrackOption is not available for use , is
anyone aware of any alternative methods to track changes
on the SQL CE ?

Thanks in Advance,

DaveD

 

[Cowboy \(Gregory A. Beamer\)]

Best group for SQL Server CE is the microsoft.public.sqlserver.ce.

I have not played around with SQL Server CE enough to know what the best
option, so I am including this reply in the SQL Server ce group, as well. As
a generic answer, however, I would suggest some form of timestamp mechanism
and keeping track of the last time there was an update to the non-SQL
sources. This should help with sync.

As you are well aware, CE works best with SQL Server as a replication(?)
partner, as the plumbing is built in. The RDA Tracking can likely be used
with other systems, but you will have to poke into the SDK to get to it. I
would consider firing off this question

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

**********************************************************************
Think Outside the Box!
**********************************************************************