How to "synchornise" or Merge data between SQLCE & SQL 2k server d

[Guest]

Hi Everyone,

Would appreciate if you could share your expertise in this area.

I have created SQL CE database on Pocket PC 2003 which contains all the
table I required (Pulled from SQL Server 2000). I have
two type of tables (1) Monthly Data Table (2) User Activity Related Tables.

Users are not allowed to any updates on Monthly Table on PcketPC and these
tables has to be pulled from SQL 2k server every month at specified date.

But, User Activity Table will be updated on Pocket PC devicr by user and
this data need to be transfered to SQL Server 2000 server by end of the day.
Next day morning prior to going to the field users has to pull their activity
table from the SQL 2k server. Activity tables at SQL 2k servcer can be update
by his line manager while users in the field.

Appreciate if you could shed some light to resolve this issue.

Regards

 

[Chris Tacke, eMVP]

You need to use a merge subscription with a publication that defines what
changes go in which direction. I'd recommend asking in a SQL newsgroup as
this would be the same for any replication subscriber, not just SqlCE

-Chris