column addition in er replication
Posted in 2019
Topics: General Discussion
We are planning to use er replication. During testing phase we created the replica using template but found that column addition is not being replicated. We did not find any switch/flag in defining or realizing the template that enforce the schema synchronization as we can do in case of replicates(using --name=y) Here are the steps we followed: cdr define server -A /tmp/er108t/atsdir -R /tmp/er108t/risdir -c ids_net_pri_108t --init ergrp2 cdr define server -A /tmp/er108t/atsdir -R /tmp/er108t/risdir -c ids_net_rep_108t -L -S ergrp2 --init ergrp cdr define template empdept -C ignore -S trans --master=ergrp2 --database=testdb cdr realize template empdept ergrp2 cdr realize template empdept -c ergrp2 --autocreate --syncdatasource=ergrp2 --extratargetrows=keep --target ergrp Here ergrp2 is master node. But adding column on master node does not replicate on other partitipant node We are using informix 12.1FC7 regards, Kamran
Schema changes aren't in the scope of regular ER. What you're after is the 'flexible grid' -> https://www.ibm.com/support/knowledgecenter/SSGU8G_12.1.0/com.ibm.erep.doc/ids_e rp_560.htm