G'd day

Does anyone know if there is a way to use Enterprise Replication with a database when we have a few tables that do not have a primary key ?

Cheers,

Philippe

There is no way to do this.

You always need a primary key on a table when you
want to define a replicate on it, regardless if you
setup an update anywhere or a master-slave replication.

Also be careful if you currently have a unique index and
want to 'upgrade' this to a primary key in order to use
ER.
Your application might fail, because they receive different
error message during an insert of a duplicate key
in this table.

- table with unique index
-> -239 'could not insert new row - duplicate value....'

- table with primary key constraint
-> -268 'unique constraint violated'

That's what I thought.
I was told that with Oracle, you could actually 'define' a primary key while setting up replication. That means that you can choose a set of columns, and 'define' theùm as a 'replication primary key'.
I thought maybe that could exist in Informix to.

Thanks for your help Eric.