all groups > sql server replication > february 2007 >
You're in the

sql server replication

group:

Vertically filtering columns


Vertically filtering columns MittyKom
2/7/2007 11:31:00 AM
sql server replication:
Hi All

I have a 2 tables Tab1 and Tab2 with the same schema but on two different
databases as below:

Tab1
Col1 Col2 Col3
1 a a1Z
2 b b2Z

Tab2
Col1 Col2 Col3
1 ax a1
2 bx b2

After replication

Tab2
Col1 Col2 Col3
1 ax a1Z
2 bx b2Z

Is it possbile to replicate Tab1 excluding/vertically filtering Col2 into
Tab2 without inserting anything in Tab2..Col2? The tricky part is Tab2 must
still have Col2 records unchanged. I have tried a transactional and snapshot
Re: Vertically filtering columns Paul Ibison
2/7/2007 10:55:53 PM
I'd replicate table1 as it is, and then have a view on the subscriber which
amalgamates the data in this fashion.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com

AddThis Social Bookmark Button