Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have a table that is published via transactional replication. A developer has requested modifying the subscribed table to add a column that is to be used for reporting purposes. The column will be updated via an outside process.

It is not prudent to add the column to the published table and insert the data there as the data that is needed to update the column is on the subscriber server.

Is this possible? Is there a better way?

share|improve this question
add comment

1 Answer

up vote 1 down vote accepted

Yes, this can be done. It isn't recommended as if you need to re-initialize the subscription the column will be lost and the values would need to be repopulated. Can the value be stored as a computed column? If so, then just add it to the publisher which would then replicate the change to the subscriber.

share|improve this answer
    
I hadn't thought of the fact that the data would be erased upon reinitialization. Thanks! –  Josh Bond Jul 8 '11 at 16:21
    
No problem. Happy to help. –  mrdenny Jul 8 '11 at 21:52
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.