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.

 All Forums
 SQL Server 2008 Forums
 Replication (2008)
 publication of only few columns from a table

Author  Topic 

AgaK
Yak Posting Veteran

86 Posts

Posted - 2011-04-11 : 18:05:51
Hi, I would like to add to the publication only few columns from a table. Any idea how to do that? Thank you AK

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-04-11 : 18:19:50
Just add them with ALTER TABLE ADD syntax. Schema changes will automatically replicate (default behavior) to the subscriber starting in SQL 2005.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

yadhu_cse
Constraint Violating Yak Guru

252 Posts

Posted - 2011-04-28 : 07:56:28
while adding articles to replication u can choose which r the colun u need for repliation.
Go to Top of Page

dinakar
Master Smack Fu Yak Hacker

2507 Posts

Posted - 2011-04-28 : 14:27:43
if you are asking about vertical filtering, check out sp_Articlefilter.

Dinakar Nethi
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/
Go to Top of Page
   

- Advertisement -