sql server replication: Adding fields in Transactional Replication -- sql server replication

Adding fields in Transactional Replication

sqldba
5/12/2006 10:31:51 AM

sql server replication: I need help to add fields on couple of publisher database(articles). i want
to know best of adding fields & how to apply schema update on Subscriber
side. i know little bit about sp_repladdcolumn. but details steps will be

Re: Adding fields in Transactional Replication

Paul Ibison
5/12/2006 5:03:32 PM

To be honest the details in BOL are pretty straightforward, and generally
you'll need only the first 3 arguments, eg:
exec sp_repladdcolumn @source_object = 'tEmployees'
, @column = 'TempForename'
, @typetext = 'varchar(100) NULL'
, @publication_to_add = 'tTestFNames'
Not all changes are supported of course - changes to PKs, identities etc,
and there are issues with republishing, but almost everything else is fine.
In SQL Server 2005 this is supported via ALTER TABLE so I assume you are
tlaking about SQL Server 2000.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)