sql server replication: Dial-in Replication process -- sql server replication

Dial-in Replication process

Winanjaya
5/30/2006 10:59:02 PM

sql server replication:

Dear All,

I want to implement replication with centralized subscriber topology (1
subscriber at HO with 5 publishers in 5 cities), I had problem with 2 cities
(A & B), currenty they have not on-line network connection to HO, I thought I
want to setup dial in connection for each server (A & B) ..so the replication
process will be automatically run when the subscriber dialled into the server
and it also automatically hang up the connection when the replication process
finished, .. is it possible? .. BTW I am using SQL Server 2005..

Any prompt reply would be appreciated..

Thanks a lot in advance
Regards
Winanjaya

Re: Dial-in Replication process

Hilary Cotter
5/31/2006 5:26:09 AM

Yes, it is possible. Follow the instructions here.

http://support.microsoft.com/kb/241149/en-us

These are for sql 2000, but they apply for 2005 as well.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

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

[quoted text, click to view]