I'm wanting to implement Enterprise Replication in a situation where I wish to have the whole database replicated (maybe even load balanced) between two Informix 9.4 servers. I have got it working nicely with one table, and assume that to get the rest of the database replicating I need to add each table individually.

Is this correct, or can I replicate the whole database?

If I can only specify the replicates at the table level, we need to get any new tables to be added to the replica. There is a situation where tables can be created and dropped by users, and I don't fancy having to manually add them to the replicates.

Any help appreciated