Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Does replication allow Script Changes ? Expand / Collapse
Author
Message
Posted Thursday, April 3, 2014 4:36 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Today @ 4:39 AM
Points: 52, Visits: 825
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
Post #1558303
Posted Thursday, April 3, 2014 9:13 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, October 16, 2014 6:18 PM
Points: 3,952, Visits: 7,170
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; They'll drag you down to their level and beat you with experience"
Post #1558351
Posted Friday, April 4, 2014 12:04 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 21, 2014 2:56 AM
Points: 2,603, Visits: 2,061
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."
Post #1558372
Posted Friday, April 4, 2014 4:40 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Today @ 4:39 AM
Points: 52, Visits: 825
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
Post #1558677
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse