We are attempting to setup a master republisher model for horizontal
scaling of our mobile devices. We currently have what will be the
republisher with CE's connected to it. The goal being I do not want
to cause re-inits and data loss from the CE's to the republisher when
I add the master.
What I have done is take a backup of our republished data and put it
on the master. So I have the exact same schema/data in both my
republisher and my master. Life is good, I setup the Master
publication with @pre_creation_cmd = 'none' (If the table already
exists at the Subscriber, no action is taken) this is so it will NOT
drop the tables and recreate them. I already have the data in place
and I just want to replicate the changes. The problem I am having is
once the master to republisher script is in place and I try to sync a
CE, the changes are NOT replicated to the master. It is like since I
said pre_creation_cmd = none, it does not care what changes anymore
for the data that already existed.
Any one can fix this problem?
View Complete Post