Replication over a slow wan link

From: "SKong" <sal@xxxxxx>
Date: Wed, 28 May 2008 22:16:29 -0400

I have a SQL 2000 database that I want to replicate over a slow WAN link. I
was going to place the distributor with the subscriber. Would that have a
significant impact on the performance of the Publishing database (OLTP)?
It's ok if the subscriber falls a little behind. I just don't want the
front end application being severely affected because of the implementation
of replication. Let's also say that the database is a medium busy database.
If any other information is needed for an accurate answer, please let me
know.

Thanks!

.

Follow-Ups:
- Re: Replication over a slow wan link
  - From: Hilary Cotter

Prev by Date: Re: new bcp tables after 2005 upgrade
Next by Date: Sysmergesubscriptions question
Previous by thread: Re: Couple of questions ...
Next by thread: Re: Replication over a slow wan link
Index(es):
- Date
- Thread

Relevant Pages

Re: on-line and near-line databases
... 'B' database) and only keep users from the last 30 days in the ... data restoration approach. ... Copy the records in the subscriber database which are to be ... ready and we 'replicate the execution of the ...
(microsoft.public.sqlserver.replication)
Re: Replication for Access
... I imported the tables, forms, queries, reports, and modules into and new ... database and regenerated the tables and links to create a new unreplicated ... When I try to replicate the data file it keeps saying the file is all ready ...
(microsoft.public.access.replication)
Selective Replication
... Have two schemas in the same database. ... used for currents an A_HIST is used to capture ... Using Triggers on 20 tables in A to replicate ... and have flexibility of possibly have the A_HIST schema in a different ...
(comp.databases.oracle.server)
Re: How to configure distributor...
... I take it you have a remote distributor, if so you should cluster it. ... Director of Text Mining and Database Strategy ... I sometimes have subscriber database in a transactional replication down ...
(microsoft.public.sqlserver.replication)
Re: Replicas
... The undocumented first rule with Access Replication: Only Replicate Tables. ... In my systems I have two database front ends that they can open. ... standard one for data maintenance, standard reports, etc and a personal play ... temporary and customised tables, queries, reports, etc. ...
(microsoft.public.access.replication)