Merge replication update timing

I am new to replication and have setup Merge replication (SQL2k) to synch
with laptops. I made some data changes on the Publisher and then synched
with the laptop and it got the new data. Then, I added a test table and 2
rows of data on the Publisher. After a few minutes I tried to synch again
and did not get the table changes. Is there something I have to do with the
Snapshot Agent in order to make that new table and data get to the laptop?
Thanks.
David
David - you'll need to run the snapshot agent then the merge agent to have
this new table included.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Is there a way that I can do this with system stored procedure? if so,
do you know what they are? e.g. sp_?
Thanks.
David
*** Sent via Developersdex http://www.codecomments.com ***
|||David - sp_start_job.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Boy, when I create Microsoft Access replication it just automatically
grabbed the new table and data without me doing anything. I guess SQL
Server takes more work?
David
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:OvgdFn1$FHA.1028@.TK2MSFTNGP11.phx.gbl...
> David - sp_start_job.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
|||Paul,
How do I run the Merge Agent manually? Can I do it in EM? I was able to
run the Snapshot Agent but I do not see where I can run the Merge Agent.
Can you help?
p.s. The same server is both publisher and Distributor, if that helps.
David
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:OvgdFn1$FHA.1028@.TK2MSFTNGP11.phx.gbl...
> David - sp_start_job.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
|||Interesting - I never knew Access did this. I'm not too sure that this is
ideal though. If you added a completely unrelated and large table it would
be a pain if it was automatically added.
Cheers,
Paul
"David" <dlchase@.lifetimeinc.com> wrote in message
news:OdjxfH2$FHA.3136@.TK2MSFTNGP15.phx.gbl...
> Boy, when I create Microsoft Access replication it just automatically
> grabbed the new table and data without me doing anything. I guess SQL
> Server takes more work?
> David
> "Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
> news:OvgdFn1$FHA.1028@.TK2MSFTNGP11.phx.gbl...
>
|||David,
you should see the merge agent when you expand the replication monitor. If
the subscription is pull, then just run the job on the subscriber (merge
agent is synonomous with a job that runs merge.exe).
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Use the conflict viewer to determine if these changes were conflicts and
were rolled back.
Also are you using any filtering? It is possible that these changes where
filtered out by the filter.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"David" <dlchase@.lifetimeinc.com> wrote in message
news:%23%23JQ5N0$FHA.4012@.TK2MSFTNGP10.phx.gbl...
>I am new to replication and have setup Merge replication (SQL2k) to synch
>with laptops. I made some data changes on the Publisher and then synched
>with the laptop and it got the new data. Then, I added a test table and 2
>rows of data on the Publisher. After a few minutes I tried to synch again
>and did not get the table changes. Is there something I have to do with
>the Snapshot Agent in order to make that new table and data get to the
>laptop? Thanks.
> David
>
|||I see that in Replication Monitor but it has a red X on the folder and also
on the Publishers folder. I don't know where to look for why the red X is
there. Also, ALL subscribers will be anonymous as they are laptops that
will be disconnected from the network from time to time. Did I do anything
wrong? This is my first (test) laptop and I want to get this right before
deploying into production.
p.s. Data changes are replicating, but the new table is still not getting to
the anonymous subscriber. Also, I tried running the start from the merge
agents folder and it prompted me for a username and password for the laptop
database.
David
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:OUkYiy2$FHA.2652@.TK2MSFTNGP09.phx.gbl...
> David,
> you should see the merge agent when you expand the replication monitor. If
> the subscription is pull, then just run the job on the subscriber (merge
> agent is synonomous with a job that runs merge.exe).
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>