Re: How do I "suspend" merge replication while I extract data from central table?

the best approach is to drop the subscriptions and publications and make the
changes. You can try to disable the triggers make changes, and then
re-enable them. However the results may be unpredictable.

--
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



<reefbreakbda@xxxxxxxxxxx> wrote in message
news:1175416990.053051.174730@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Is there a standard practice to "hold" Merge replication so that the
data collected at the central server (in a remote sales order
application) can be periodically 'removed' to another part of the
system without clashing with ongoing replication from clients?

I'm experiencing my clients initiating replication, and therefore
inserting more rows, whilst the server SSIS job transfers and deletes
rows collected in the central table to the order processing tables,
thus losing data.

My implementation is SQL 2005 Express clients using Merge Websync to a
SQL 2005 standard central server.

Any advice/recommendations would be appreciated!



.

Relevant Pages

  • Re: Offline scenario with low bandwith
    ... SQL replication transmits only changes. ... > with datasets or diffgrams sent from the mobile users. ... > GPRS to the central server. ...
    (microsoft.public.sqlserver.ce)
  • Re: Synching between Access and MSSQL
    ... Look at SQL Server replication. ... How long will the clients be disconnected, i.e. max number of days without ... > SQL database and the clients would work offline with this data and later ...
    (microsoft.public.access.externaldata)
  • Merge replication and spids left behind
    ... We are using Merge replication with clients from remote offices (SQL ... Since the orphaned spid is blocking, ...
    (microsoft.public.sqlserver.replication)
  • Changing field length for Merge
    ... I am using Merge replication, pushing subscriptions to clients, and SQL ...
    (microsoft.public.sqlserver.replication)
  • Re: Offline scenario with low bandwith
    ... The idea of replicating a 40-60MB database across GPRS is not going to ... replication strategy. ... with datasets or diffgrams sent from the mobile users. ... GPRS to the central server. ...
    (microsoft.public.sqlserver.ce)
Loading