Synchronisation Informix UNIX -> Informix WGS NT
Posted in 1999
Topics: General Discussion
I have a requirement to synchronise, bi-directionally if possible, between a primary Informix instance (database) on a UNIX server (7.2x) and an Informix WGS instance (database) on WIN NT 4 workstation. The WIN NT instance will contain a cut-down version of the source data database tables, this user will be mobile. When connected to the back to the 'home' network (Dial-up or local) synchronisation with its equivalent records within primary UNIX instance is required e.g. mobile NT user has updated a customer record, a new customer record has been added to the primary instance. Primary recieves the row update from the NT (mobile) and applies, NT recieves the new customer row from the primary and adds this record. Any details of packages would be appreciated or and leads. Thanks. Colin -- DHL Systems Europe & Africa Sent via Deja.com http://www.deja.com/ Before you buy.
This is a job for Informix Enterprise Replication! Which is built into later 7.2x engines but performs best in IDS 7.31 or IDS.2000. Read the Enterprise Replication Manual which is available online at the Informix WEB Site>answers. Art S. Kagel Colin Taberman wrote: > > I have a requirement to synchronise, bi-directionally if possible, > between a primary Informix instance (database) on a UNIX server (7.2x) > and an Informix WGS instance (database) on WIN NT 4 workstation. The WIN > NT instance will contain a cut-down version of the source data > database tables, this user will be mobile. When connected to the back to > the 'home' network (Dial-up or local) synchronisation with its > equivalent records within primary UNIX instance is required e.g. mobile > NT user has updated a customer record, a new customer record has been > added to the primary instance. Primary recieves the row update from the > NT (mobile) and applies, NT recieves the new customer row from the > primary and adds this record. > > Any details of packages would be appreciated or and leads.