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.
| 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? |
 |
|
|
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! |
 |
|
|
|
|
|