Enterprise Replication

IDS 9.4 (Linux) Hi all, I wonder if it's possible to replicate a complete database without replicating each table itself. We are using a tool which creates new tables, but we can't automatically specify the replication command for that new tables from outside that tool. We always have to look for new tables and, if we found one or more, we have to enter the replication statement "manually". For some other circumstances, we cannot use HDR. So, is there a way, to set up an enterprise-replication for a database, which automatically includes replication for new created tables? Thanks in advance! By Markus

Marquis de Bogier wrote: > IDS 9.4 (Linux) > > I wonder if it's possible to replicate a complete database without > replicating each table itself. > We are using a tool which creates new tables, but we can't automatically > specify the replication command for that new tables from outside that tool. > We always have to look for new tables and, if we found one or more, we have > to enter the replication statement "manually". > > For some other circumstances, we cannot use HDR. > > So, is there a way, to set up an enterprise-replication for a database, > which automatically includes replication for new created tables? I don't think there is a way at the moment for ER to do that. One reason is that, in general, the separate ER servers are autonomous, and may not have the resources available for every table - let alone a need to copy every table. That said, you have an interesting point. Why does your tool keep creating new tables? -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2005.01 -- http://dbi.perl.org/