CODEWITHSUNDEEP
sql-server-2008replicationmerge-replicationtransactional-replication
Mohammad Sheykholeslam
Mohammad Sheykholeslam

Reputation: 1437

What's the solution for bidirectional Replication type on vertical filtered table(some of columns) in SQL Server 2008

Assume we have a table in two database instance like following:

CREATE TABLE StudentList
(
     StudentId int NOT NULL PRIMARY KEY,
     StudentName nvarchar(255) NOT NULL,
     StudentGrade int
)

We want to create a bidirectional replication between these two SQL Server 2008 instances on the first and second columns (vertical filtered) without removing the third column in the second table.

The peer-to-peer transactional and merge replication don't permit us for doing this.

What's the solution?

Upvotes: 4

Views: 568

Answers (2)

Brandon Williams
Brandon Williams

Reputation: 3755

@mirza - The filtered column is being dropped at the Subscriber because you are initializing with a snapshot and the Merge Article property @pre_creation_cmd is set to drop. To accomplish vertical filtering and not have the columns removed on initialization you will need to initialize the Merge Subscription without a snapshot. This way the column(s) will not be dropped at the Subscriber.

Upvotes: 1

Thakur
Thakur

Reputation: 2020

Merge replication allows filtering the articles as well as you can choose [CHECK/UNCHECK] which columns you want to be replicated.

Try to avoid bi-directional transactional replication as this feature will be removed in next version : http://msdn.microsoft.com/en-us/library/ms151718.aspx

Upvotes: 1

Related Questions