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

Replication of Replications

Is it possible to have a pull subscription and then have a pull
subscription of that subscription? We want to have a server wich
replicates to 2 or more laptops wich will be replicated out to 3 or
more ppc all running sever - msde - sqlce?
Not as such, but it is possible to republish:
A publishes to B
B publishes to C
etc
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||with merge, this is doable. With Transactional replication you will have to
select the option to include DRI on your table articles so the primary keys
will be in place on your subscriber tables. Otherwise you won't have PK's on
B, to replicate to C.
"Shane Lim" <gslim@.blizzardice.com> wrote in message
news:i0alv0l0c35ppj2goua1k4uvdlpngi3fo0@.4ax.com...
> Is it possible to have a pull subscription and then have a pull
> subscription of that subscription? We want to have a server wich
> replicates to 2 or more laptops wich will be replicated out to 3 or
> more ppc all running sever - msde - sqlce?
|||Hilary's answer is more accurate - using alternative synchronization
partners is a possibility in merge replication as well as republishing.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Alright I setup all of my databases as publications and I can create a
pull from the master to the second slave. Everything looks good
except my articles are not visible. When I try to add them I get an
error saying that I cannot create duplicate tablenames. When I try to
create a pull to the second database the error I get states that it
cannot get a mergearticle list. Any ideas?
On Sat, 29 Jan 2005 11:25:37 -0500, "Hilary Cotter"
<hilary.cotter@.gmail.com> wrote:

>with merge, this is doable. With Transactional replication you will have to
>select the option to include DRI on your table articles so the primary keys
>will be in place on your subscriber tables. Otherwise you won't have PK's on
>B, to replicate to C.
>
>"Shane Lim" <gslim@.blizzardice.com> wrote in message
>news:i0alv0l0c35ppj2goua1k4uvdlpngi3fo0@.4ax.com.. .
>

Replication Not working for a table

We have about 20 tables setup for replications . All std.
setup . Replication is using stored procs created by SQL
Server instead of the Statements. All tables are fine
except one table stpped changing data at all. No errors
etc.
What should I do.
Table has 2 coulms as PK . using SQL stored proc,
sp_msIns..,sp_msUpd.., sp_msdel..
What could be wrong. PLease help. All other tables are
fine.
No Primary key or columns have been changed at all .
ThanksYour table name contains white spaces or special characters? If so,
rename your stored procedures.
MoreThanInsane
---
Posted via http://www.mcse.ms
---
View this thread: http://www.mcse.ms/message1340150.html

Replication Move Merge Snapshot folder

At present our snaopshot folder for merge replication(mainly) and our snapshot replications are on a seperate server. We now need to move the folder to a new server.
Anybody explain how we will do this and what affects it will have
ThanksYou can use Alternate location on the Snapshot tab of configuration dialog. This will actually give an advantage because then you'll be able to use compression on resulting snapshot files (it is not supported for default location).|||I will try that in testing and that is well documented

Replication monitor error but no error?!

Hello again,
The root node of my SQL Server replication monitor is showing a red X but
all the actual replications listed underneath are OK. What might be causing
this and how can I get rid of it! My DBA is getting twitchy...
Thanks
Will
If you run profiler and navigate to the replication monitor, you should see
why this is happening. The replication monitor gets its info from
tempdb.dbo.MSreplication_agent_status and running
sp_MSload_replication_status refreshes this table. As restarting the SQL
Server Service causes the tempdb to be recreated from the model database,
this also removes the problem.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .

Replication Information

Hi everybody,
I′m a beginner in Replication, and I need to find out information about
Replication. If anybody knows "Replications for Dummies or Beginners", let me
know. Thanks a lot.
Richard_SQL
Um.... I just completed a book on snapshot and transactional replication. I
would recommend it highly.
BOL is actually pretty good. You might want to try to fight through the
wizards they are really pretty intuitive.
You can also download a free sample chapter on how to set up replication on
your server in the link below. This should help you get going.
Other than that post back here when you have problems and someone will help
you.
Hilary Cotter
Looking for a SQL Server replication book?
Now available for purchase at:
http://www.nwsu.com/0974973602.html
"Richard_SQL" <Richard_SQL@.discussions.microsoft.com> wrote in message
news:AFBE0979-D662-4E63-9016-5517F99C43CC@.microsoft.com...
> Hi everybody,
> Im a beginner in Replication, and I need to find out information about
> Replication. If anybody knows "Replications for Dummies or Beginners", let
> me
> know. Thanks a lot.
> Richard_SQL
|||On 2004-12-06, Hilary Cotter <hilary.cotter@.gmail.com> wrote:
> Um.... I just completed a book on snapshot and transactional replication. I
> would recommend it highly.
>
Do you explain the desing philosophy behind the replication process in your
book?
Mike
"I can do it quick. I can do it cheap. I can do it well. Pick any two."
Mario Splivalo
msplival@.jagor.srce.hr
|||To the best of my ability I did. I was not content with merely a collection
of snapshots, or a re-write of BOL. Getting answers from Microsoft was
difficult in many cases. I was not interested in making a quick buck, but
rather interested in learning replication in great depth, and writing about
what I had learned.
From my work in this newsgroup I think I have know pretty well the full
spectrum of questions on replication and I attempted to answer them to the
best of my ability.
Download the sample chapter. I think this is representative of the depth I
go to in the entire book.
Hilary Cotter
Looking for a SQL Server replication book?
Now available for purchase at:
http://www.nwsu.com/0974973602.html
"Mario Splivalo" <majk@.fly.srk.fer.hr> wrote in message
news:slrncrbec7.360.majk@.fly.srk.fer.hr...
> On 2004-12-06, Hilary Cotter <hilary.cotter@.gmail.com> wrote:
> Do you explain the desing philosophy behind the replication process in
> your
> book?
> Mike
>
> --
> "I can do it quick. I can do it cheap. I can do it well. Pick any two."
> Mario Splivalo
> msplival@.jagor.srce.hr