2-way Merge Replication(PDA<->SqlServer2000)

I am working on Windows mobile platform using C#. I am using Merge Replication to do synchronization between SQL Server2000 and SQL Server 2005 Mobile edition and t is working fine.

The Server Tables are copied in the Client DB. It works fine with one way, i.e., server pushing data to Client Database (in PDA), but when i tried to update from PDA database, server keeps over writting PDA databse.

The requirement is that before adding our PDA database as subscriber,there are some tables with same name and structure as in Server with some records. After that i added it as subscriber and sycnchronized.The tables in the server are going to overwrite the records in PDA. My requirement is to not overrite the records but it should update the existing table.

Is it possible....Can Any one Help meeeeeeeeeeeee plzzzzzzzzzz.

Move to Sql Server Compact Edition. Thanks!

Zero Dai - MSFT

|||You must move the initial data to the server tables, or add initial data in code on the PDA after the first sync.|||

Hi all,

Thanks for the reply and Sorry for the delay.I have a new problem that,I alredy mentioned you i am using Sql Server 2000 as publisher.....In that i alreay Configured one Databse as Publisher....it is working fine and now i want to use another database as a publisher in the same server........the problem is this time it is not asking for Snapshot location while publishing the Database

Once we mentioned it is sufficient or wat to do.........to get Snapshot.exe file........I am assumed that the previous snapshot is sufficient and synchronized bt giving DB name and publisher name...But it is giving Native error:29061.

Another thing i did was,I disabled the Database as Publisher and try to publish from the first.This time it is asking for snapshot location but in that location it is not creating any snapshot.exe.......and not even Snapshot folder.wat to do.plz help meeeeeeeeeeeeeee.......

Thanks And Regards

Ayyappa.k