Changes to a replicated db

[Hansje]

Hi there,
We have to aply changes to a replicated database. Basically a tablefield has to change from varchar(60) to varchar(80). These changes are aplied to the subscriber, but to aply them to the publishing db its looks like we have to drop the subscriptors, then aply the changes and add the subscriptor again. Since it concerns a pretty large database, more than 30 Gb, the initialization will take quiet some time. Is there no way to implement such a change without stopping the replicationprocess?

TIA,
Hans Brouwer

 

[eramgarden]

But you're doing the dropping replication for one table only, arent you?

 

[Hansje]

Yeah, found out how to do that.
Tnx,
Hans Brouwer