CODEWITHSUNDEEP
sql-server-2005replication
Ragalante
Ragalante

Reputation: 341

How to use the wizard to replicate 2 tables into one using a join?

I have one app with one database, and I need to make a replication of some of those tables, and also include one new table which is a join of more than one of those tables.

I tried transaction replication, but the filter for the tables only allows me to modify the 'where' clause.

Anybody can help me with this?

Upvotes: 2

Views: 79

Answers (1)

Joe Stefanelli
Joe Stefanelli

Reputation: 135858

I'd replicate the two tables in question as-is, then create a view on the subscriber to represent your desired join.

Upvotes: 2

Related Questions