Is there an error in Help ?

Hello
I've found something like that in SqlServer2000 help:
"How to synchronize push subscriptions with alternate synchronization
partners (Enterprise Manager)
1.. On the Subscriber, expand the Replication Monitor and Agents
directories, select the Merge Agents directory, right-click the publication,
and then click Agent Properties.
2.. On the Steps tab, double-click the subscription agent step, and add
the -SyncToAlternate switch in the Command text box.
"
My Megre Agents directory is empty ! At the publisher there are some
publications in it.
I'm using Merge replication and I wanted to protect this replication if my
default publisher would go off-line.
Have I made some mistake or help is wrong ? Can this be done by some other
way ?
Best Regards
Wojciech Znaniecki
right click on the merge agents folder. Is show anonymous agents selected?
If not select it.
Do they show up now?
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Wojtek Z" <wojtas_z@.poczta.fm> wrote in message
news:ch4f7u$829$1@.atlantis.news.tpi.pl...
> Hello
> I've found something like that in SqlServer2000 help:
> "How to synchronize push subscriptions with alternate synchronization
> partners (Enterprise Manager)
> 1.. On the Subscriber, expand the Replication Monitor and Agents
> directories, select the Merge Agents directory, right-click the
publication,
> and then click Agent Properties.
> 2.. On the Steps tab, double-click the subscription agent step, and add
> the -SyncToAlternate switch in the Command text box.
> "
> My Megre Agents directory is empty ! At the publisher there are some
> publications in it.
> I'm using Merge replication and I wanted to protect this replication if my
> default publisher would go off-line.
> Have I made some mistake or help is wrong ? Can this be done by some
other
> way ?
> Best Regards
> Wojciech Znaniecki
>
|||Yes, it is checked, I've tried both with and without it.
Best Regards
Wojciech Znaniecki
Uytkownik "Hilary Cotter" <hilary.cotter@.gmail.com> napisa w wiadomoci
news:%23yWEAOCkEHA.2652@.TK2MSFTNGP15.phx.gbl...[vbcol=seagreen]
> right click on the merge agents folder. Is show anonymous agents selected?
> If not select it.
> Do they show up now?
> --
> Hilary Cotter
> Looking for a book on SQL Server replication?
> http://www.nwsu.com/0974973602.html
>
> "Wojtek Z" <wojtas_z@.poczta.fm> wrote in message
> news:ch4f7u$829$1@.atlantis.news.tpi.pl...
> publication,
add[vbcol=seagreen]
my
> other
>
|||I have seen cases where you deploy a publication via a script from one
database to another on the same server and don't modify the merge agent or
snapshot agent name, and this causes the agents not to show up in the
publisher.
If this is the case, script our your publication, drop it, rename the
publication and change the snapshot and merge agent names and run the script
again.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Wojtek Z" <wojtas_z@.poczta.fm> wrote in message
news:ch6alt$f7h$1@.atlantis.news.tpi.pl...[vbcol=seagreen]
> Yes, it is checked, I've tried both with and without it.
> Best Regards
> Wojciech Znaniecki
> Uytkownik "Hilary Cotter" <hilary.cotter@.gmail.com> napisa w wiadomoci
> news:%23yWEAOCkEHA.2652@.TK2MSFTNGP15.phx.gbl...
selected?[vbcol=seagreen]
> add
if
> my
>
|||Hello
I've made it some other way. I have found lthis little HowTo from
http://support.microsoft.com/?kbid=321176#4
by the way - regards to support.microsoft.com ;)
Wojciech Znaniecki
Uytkownik "Hilary Cotter" <hilary.cotter@.gmail.com> napisa w wiadomoci
news:evyX8fOkEHA.636@.TK2MSFTNGP12.phx.gbl...
> I have seen cases where you deploy a publication via a script from one
> database to another on the same server and don't modify the merge agent or
> snapshot agent name, and this causes the agents not to show up in the
> publisher.
> If this is the case, script our your publication, drop it, rename the
> publication and change the snapshot and merge agent names and run the
script[vbcol=seagreen]
> again.
>
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> "Wojtek Z" <wojtas_z@.poczta.fm> wrote in message
> news:ch6alt$f7h$1@.atlantis.news.tpi.pl...
wiadomoci[vbcol=seagreen]
> selected?
synchronization[vbcol=seagreen]
and[vbcol=seagreen]
> if
some
>

Is there an easy way to synchronize two tables in different databaes using a SQL

news.valornet.com wrote:
> Hi,
> I am going to be writing an application where a server has MS SQL 2K on it
> with some tables that I will need locally on some notebooks when they aren
't
> connected to the server. I need to also create other tables for my
> application so I figured I would create tables to match the ones I need fr
om
> the server in the same local database on these notebooks. I could probabl
y
> delete the local table and then use a select into from the server to refil
l
> it again, but is there a better way? Like some sort of synchronization
> where you specify both tables and only the changes from the source table a
re
> applied to the destination table?
> Thanks,
> Alan
> [url]http://www.evelopment.com[/url]
> Home of Partition Boot Manager and Large Drive Tools utilities!
Are the laptops going to have SQL installed on them? If so,
transactional replication should do the trick. Publish the master
tables (from the server), and have each laptop subscribe to those
publications.Hi Tracy,

> Are the laptops going to have SQL installed on them? If so,
> transactional replication should do the trick. Publish the master
> tables (from the server), and have each laptop subscribe to those
> publications.
Thanks for responding.
What I am trying to do is pull a certain few tables from the server and
store them locally. I would prefer to do this with SQL code and a button in
my application called "Synchronize". The customer clicks synchronize and
then it executes some SQL to bring the local tables in sync with the network
ones. The tables aren't so large that they can't be completely emptied and
recopied from the network each time. I am writing in C++ using a component
called SDAC (www.crlab.com) to issue SQL commands. I can create two
connection components but each one can only see its connection to the server
it is configured for. I've taken a look ad sp_addlinkedserver, and wonder
if this is the direction I should go. Any ideas?
Thanks,
Alan
[url]http://www.evelopment.com[/url]
Home of Partition Boot Manager and Large Drive Tools utilities!