RE: Enterprise Replication question

>Josh Marshall wrote > > I've got Enterprise Replication working nicely with a table > on Informix 9.40, > but I'm wanting to replicate the whole database between the > two servers. > > There is a situation where tables can be dynamically created > and I want these > to automatically be included in the replication. > > I'm happy to define all the tables in the replication > settings but how to get > the new tables added I haven't worked out (I prefer not to > manually do them > each time) > > If anyone can give any pointers it would be appreciated. The obvious and easiest way is with HDR which can co-exist with ER on 9.40. The alternative is to have a batch process that compares the tablnames in sysmaster with the tablenames in syscdr and creates a new replicate if it does not exist for that table. Easier said than done, but do-able. Colin Bull c.bull@videonetworks.com sending to informix-list