| |

VerySource

 Forgot password?
 Register
Search
View: 725|Reply: 2

Problems with merge replication filter rows

[Copy link]

1

Threads

1

Posts

2.00

Credits

Newbie

Rank: 1

Credits
2.00

 China

Post time: 2020-1-29 21:20:01
| Show all posts |Read mode
Boss, please ask.
I am doing a merge replication of SQLSERVER, and some of the information in a table cannot be synchronized, so I restrict the conditions in the filter rows of the published items, but I do n’t know how to restrict the conditions on the subscriber, because it ’s like this Synchronous replication is bidirectional between the publisher and the subscriber. If only the publisher is limited, a part of the unwanted data on the subscriber will be synchronized to the publisher. Please enlighten.
Reply

Use magic Report

0

Threads

1

Posts

2.00

Credits

Newbie

Rank: 1

Credits
2.00

 China

Post time: 2020-8-13 08:45:01
| Show all posts
Subscribers do not need to qualify, only data that meets the publishing conditions will be synchronized to the publisher
Reply

Use magic Report

0

Threads

1

Posts

2.00

Credits

Newbie

Rank: 1

Credits
2.00

 China

Post time: 2020-8-18 11:00:01
| Show all posts
Have you made snapshots and transactions? Merge replication is bidirectional!
Reply

Use magic Report

You have to log in before you can reply Login | Register

Points Rules

Contact us|Archive|Mobile|CopyRight © 2008-2023|verysource.com ( 京ICP备17048824号-1 )

Quick Reply To Top Return to the list