Merge Replication: Suscriber don't get updates.

Question

Hi, we have an application running on SQL CE 3.5 and the server on SQL Server 2005. The merge replication works fine, but when the subscriber send the updated data, it doesn't get the new data of the server, the subscriber has to delete the database and then synchronize with the server in order to get the new data.

All the tables are marked as "Download" on the replication configuration. Any ideas of what we are missing?

---

Bizzare what men find attractive

Answer 1

Can you check if you are using the Upload option on the ExchangeType property?

http://msdn.microsoft.com/en-us/library/ms173485.aspx

---

Alberto Silva Microsoft MVP - Device Application Development - http://msmvps.com/AlbertoSilva moving2u - R&D Manager - Microsoft Certified Partner - Mobility Solutions - http://www.moving2u.pt

Answer 2

Which version of SQL Server 2005 are you running. SP2 at least is highly recommended.

---

http://erikej.blogspot.com Erik Ejlskov Jensen - Please mark as answer, if this was it.

Answer 3

Yes, we're working on SP2.

---

Bizzare what men find attractive

Answer 4

i checked our replication code and we don't have set the ExchangeType. I google it and by default it's set bidirectional but i don't know if that applies to sql ce.

---

Bizzare what men find attractive

Answer 5

Can you script your publication and share it?

---

Alberto Silva Microsoft MVP - Device Application Development - http://msmvps.com/AlbertoSilva moving2u - R&D Manager - Microsoft Certified Partner - Mobility Solutions - http://www.moving2u.pt

Answer 6

I guess it won't be necessary, i added the property you told me in the SqlCeReplication object, and now the mobile application finally got the updates when it sends data!

---

Bizzare what men find attractive