Replication over Replication...

Hi all.

I have created two replications. One from the main server (ERP) to my Mobile Manager Application (MMA) and the other one is from the MMA to all Mobile Devices (Tablet PCs). The last replication works fine (MMA => MD). But when the first replication (ERP => MMA) tries to update the tables (which are the same on both replications) I get the error that the first table to update cannot be updated because it is included in a replication.

I'm not that much experienced working with replication, so I'm looking for some answers to try to solve this problem. Maybe there are some other methods to work this issue.

I'd really appreciate any help or suggestions to work this around.

Thanks.

Fabio.

Fabio,

It would help if you can provide more details. For example, do you use transactional replication (readonly or updatable?) between ERP and MMA and merge replication between MMA and MD? And what is the exact error message your are seeing? What are you trying to do when the error happens (like a DML update or running replication agent etc). Plus the version and edition of SQL Server on each machine.

Thanks,

Zhiqiang Feng

|||Make sure you setup ERP to MMA first and then setup MMA to MD.|||

Thanks Zhiqiang for your reply.

In order to give you a better vision of this issue I have to say that:

1. Things are configured exactly as you said (ERP => MMA - Transactional (but Readonly) it only updates MMA, and MMA => MD - Merge Replication).

2. I configured first the ERP => MMA Replication, create my initial snapshot and the propagate it to MMA. After that created my MMA => MD replication and followed the previous steps detailed before.

3. Everything works fine between MMA => MD publication and subscriptions.

4. SQL Sever versions for ERP and MMA are 2000 SP4 and MD are MSDE SP3a.

My problem issues when ERP => MMA replication tries to update the data at MMA Database. It seems to try to modify some tables on the MMA Server, which I don't understand because it is supposed to be done when propagating the initial snapshot. Another thing I didn't say (sorry for that) is that I have this 2 replications because my customer doesn't want to expose his main server to the internet.

On the MMA machine I control some data like orders approval, customer payments and deposits procedures.

Thanks again for the help. I appreciate so much.

Fabio

|||

Fabio,

I was trying to setup a test environment to simulate what you described, will update my findings with you once I have some results. By the way, what's the exact error message your re seeing? error number, description etc?

Thanks,

Zhiqiang Feng

|||

Hi Zhiqiang.

I have found the answer for my problem. Thanks a lot for your interest in helping me.

In this link: http://www.replicationanswers.com/Republishing2005.asp I found exactly what I was looking for.

It may help others which have the same case.

Thanks again. I really appreciate your effort.

Fabio.

|||

Glad to hear that problem got solved!

Thanks,

Zhiqiang Feng