Replication and an added column

[jeffmoore64]

Hi,
I'm replicating a database. In one of the tables tables on the subscriber I have had to add a column that is populated by a stored procedure.
The problem is, when I run the snapshot it recopies the table and my column disappears. Is there some neat trick to get around this issue? I don't want to make the change to the distributor database since it's running a Japanese ERP program and is 8000 miles away....
TIA
Jeff

 

[ptheriault]

no there is not, when you run the snap shot it creates script for each object with a drop statement, so when that script gets run on the subscriber it drops and recreated the objects. You have two choices here. don't run the snap shot agent unless there is a change in the schema or add the column on the published database. As a third choice you could create the alter statement and add it as a step to the snap shot agent job.

- Paul
- Database performance looks fine, it must be the Network!