April 3, 2014 at 4:36 pm
Hi All,
I have a replication setup on Views if some one is altering one of the view it should replicated on Subscriber server am I correct ?
Please let me know.
Thanks
April 3, 2014 at 9:13 pm
If you publication(s) were set up to replicate schema changes then it will replicate. ALTER TABLE, VIEW, PROCEDURE, FUNCTION, TRIGGER will be replicated. ALTER TABLE D-ROP COLUMN is always replicated to all subscriptions whose partition contains the columns being dropped, regardless of if this setting was set.
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
April 4, 2014 at 12:04 am
Also if publication not set up to replicate schema; you need to remove and add from subscriber & publication. Also need to run snapshot agent to pickup the change.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 4, 2014 at 4:40 pm
Thanks for the reply ,
I have schema changes enabled but when I alter one of the view add one more column but it didn't reflect on the rep side. I have setup replication using backup and restore and in Initialize subscription and snapshot via backup. Do I need to do something else to make sure changes are going threw?
thanks a lot
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply