Transactional replication

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

swapna - 29 Jun 2006 16:17 GMT

Hi,

I have created transactional replication with 5 publisher.I want to alter a
column defination of one of the article.Should I drop the publication and
recreate the publication or is there an easy way out

Reply to this Message

Hilary Cotter - 29 Jun 2006 17:17 GMT

Copy the data to a holding table, Drop the column using sp_repldropcolumn,
add the new column definition using sp_repladdcolumn, and then copy the data
to the new column

Signature

Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

> Hi,
>
> I have created transactional replication with 5 publisher.I want to alter
> a
> column defination of one of the article.Should I drop the publication and
> recreate the publication or is there an easy way out

Reply to this Message

Paul Ibison - 30 Jun 2006 09:26 GMT

Please take a look at these articles:
http://www.replicationanswers.com/AddColumn.asp
http://www.replicationanswers.com/AlterSchema2005.asp
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Reply to this Message

swapna - 30 Jun 2006 12:34 GMT

Thanks a lot.It worked!

> Please take a look at these articles:
> http://www.replicationanswers.com/AddColumn.asp
[quoted text clipped - 3 lines]
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)

Reply to this Message