ER Replication and IDS 9.4

We have IDS 9.4 (I know its an old version but we can't change because our ERP supplier wont support any other version) and we are looking at ER replication. Our live database has over 300 tables that we with to replicate onto another server. I've been doing some research and it looks like the easiest way to do the replication is to use an ER template of the entire database BUT this isn’t available in IDS 9.4 (only 10 and above). Do I need to specifically choose each table in the database and replicate each separately OR is there a better way of doing it ? thanks

I would look at replicating the entire instance with HDR. Is there any other tables in the instance? HDR is a much simpler thing to do here if you want everything replicated. Works in 9.40 too - we just moved our HDR pair up to 11.50 from 9.40. Jarrod Teale Team Lead - Manufacturing Execution Systems Automation & Process Control Group NZ Technical Fonterra Fonterra Extn: 77525 DDI: +64 7 850 7525 Mobile: +64 21 968 364 fax: +64 7 849 7855 email: jarrod.teale@fonterra.com -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of coleas Sent: Tuesday, 8 September 2009 6:02 p.m. To: informix-list@iiug.org Subject: ER Replication and IDS 9.4 We have IDS 9.4 (I know its an old version but we can't change because our ERP supplier wont support any other version) and we are looking at ER replication. Our live database has over 300 tables that we with to replicate onto another server. I've been doing some research and it looks like the easiest way to do the replication is to use an ER template of the entire database BUT this isn't available in IDS 9.4 (only 10 and above). Do I need to specifically choose each table in the database and replicate each separately OR is there a better way of doing it ? thanks _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list DISCLAIMER: This email contains confidential information and may be legally privileged. If you are not the intended recipient or have received this email in error, please notify the sender immediately and destroy this email. You may not use, disclose or copy this email or its attachments in any way. Any opinions expressed in this email are those of the author and are not necessarily those of the Fonterra Co-operative Group. http://www.fonterra.com/

> I've been doing some research and it looks like the easiest way to do > the replication is to use an ER template of the entire database BUT > this isn’t available in IDS 9.4  (only 10 and above). > Do I need to specifically choose each table in the database and > replicate each separately OR is there a better way of doing it ? As Jarrod already said, HDR is much preferred option in your case, but if your really need to stick with ER for any reason (i.e. different target platform), yes, since you cannot use templates you will have to create replicate for each table. With just a bit of scripting it's fairly easy do that, something along the lines: select "cdr define repl " || tabname || "_er <other replicate options>" from systables where tabid > 99 Of course, you'll have to adapt "other replicate options" to suit your needs, add participant definitions and so on... HTH Davorin