We help IT Professionals succeed at work.

SQL Replicaiton

saratcm
saratcm asked
on
Hi all,
If we add a column on publisher will that change reflect on subscriber without restarting the snapshot agent?
Comment
Watch Question

IT Engineer
Distinguished Expert 2017
Commented:
Adding a column to a table that is being replicated doesn't mean that column going to be replicated automatically. So the answer is no reflect at all.
David ToddSenior Database Administrator

Commented:
Hi,

It depends - you will need to add that column to the article, and then create a snapshot.

HTH
  David

Author

Commented:
Thanks