February 26, 2009 at 11:13 am
Hey, All, Question: I'm running Transactional Replication and have my snapshot agent running every hour and my log reader & distribution agents running every 5 minutes. I've read that schema changes (e.g. add column) are replicated in 2005. If I add a column to an already replicated table, will the log reader agent pick it up when it runs or do I need to initialize the snapshot agent to register the change? Simply, my question is... does the log reader register schema changes or does only the snapshot agent handle schema changes? Thank you very much for your time! --Nic.
February 26, 2009 at 6:19 pm
NicholeRS (2/26/2009)
Hey, All, Question: I'm running Transactional Replication and have my snapshot agent running every hour and my log reader & distribution agents running every 5 minutes. I've read that schema changes (e.g. add column) are replicated in 2005. If I add a column to an already replicated table, will the log reader agent pick it up when it runs or do I need to initialize the snapshot agent to register the change? Simply, my question is... does the log reader register schema changes or does only the snapshot agent handle schema changes? Thank you very much for your time! --Nic.
if your publication has "replicate ddl changes" ON the Log reader picks it up and it will automatically be applied to the subscriber. No need to snapshot anything. Now if you add a new table the snapshot agent must be run.
* Noel
February 27, 2009 at 12:04 pm
Exactly what I needed to know - Thanks, Noel!
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply