Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Reinitializing - Merge Replication

Author  Topic 

dshelton
Yak Posting Veteran

73 Posts

Posted - 2003-04-16 : 20:19:59
Can one help me with a Merge replication dilema, if so thank you.
Heres my dilema:
I'm using merge replication, and using a dynamic pull subsription on the subscriber. However, when i make changes on on the server on an filtered article, I find that i must reinitialize the subscription & dynamic snapshot for it to propergate the changes across to the subscriber. Is this wat replication suppose to do?

Also if I make an insert or deletion on the server on filtered articles, these changes arnt being propergated to the subscriber?

Can anyone tell me what I must do???



dshelton
Yak Posting Veteran

73 Posts

Posted - 2003-04-24 : 06:26:45
Ok. Can anyone tell me when is the best time to re-initialize the publication and the best time to reinit the subscription?
Im having so much trouble propergating the changes from the server to the client and vice versa.

Has anyone work with 2 way replication? using a dynamic snapshot? (host_name/suser_sname) with horizontal filters?

Go to Top of Page

cwillsh
Starting Member

2 Posts

Posted - 2003-04-28 : 10:07:03
The only problem we have had with our snapshot is when we started entering data at the remote site before we synced the snapshot with the master replica. It did not send those records to the master, but it did send all records entered after the initial sync. Our scenario: We actually did a backup of the master replica, then transported it to the remote site and restored it. The sites where we synced immediately, then started entering data have not had any issues. And we have not had any other problems, so far. Course, we've only been up for 7 days now!

Go to Top of Page
   

- Advertisement -