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.
Author |
Topic |
netjam
Starting Member
37 Posts |
Posted - 2008-04-27 : 21:57:05
|
Is there any way to transfer a new columns from publisher to subscriber without dropping a subscriptions.A few columns were added (by script) to a Table on publisher.I tried to reinitialize subscription, start snapshot agent but no success |
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-27 : 22:53:41
|
Tried add columns with sp_repladdcolumn? |
|
|
netjam
Starting Member
37 Posts |
Posted - 2008-04-27 : 22:56:48
|
no just alter table.I'll give a try. Thanks |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-28 : 00:32:55
|
check this outhttp://www.replicationanswers.com/AddColumn.asp |
|
|
netjam
Starting Member
37 Posts |
Posted - 2008-04-28 : 22:28:15
|
It does the job.However exec sp_repldropcolumn requires more attention if existing column has constraintsprocedure will fail.I had to remove column from subscriber manualy then drop constraint on publisher and only then run sp_repldropcolumnThanks |
|
|
|
|
|