CDC on table with no PK

Hello everybody, I have a need for replication from Informix IDS 12.10 to another database vendor. One possibility is to use the CDC to get the changes from IDS to replicate to the target. Is it possible to use the CDC API on table with no primary key ? Thank you for your answers, P. Fornaciari

Mechanically possible, but dangerous. Updates and deletes would affect all rows that happen to be duplicates. It is a REALLY poor schema that has tables without at least a unique index key even if it isn't declared as a primary key formally. FYI, there is a 3rd party product that does heterogeneous replications between Informix and other vendors' databases in both directions if needed. Not cheap but then you don't have to roll your own and debug it. Take a look at dbmoto: http://www.hitsw.com/products_services/dbmoto.html Though they will probably tell you the same thing I have. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Fri, Jan 9, 2015 at 9:39 AM, PHILIPPE FORNACIARI < p.fornaciari@irium-tech.com> wrote: > Hello everybody, > > I have a need for replication from Informix IDS 12.10 to another database > vendor. One possibility is to use the CDC to get the changes from IDS to > replicate to the target. > > Is it possible to use the CDC API on table with no primary key ? > > Thank you for your answers, > > P. Fornaciari > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --089e013d1c3a56383e050c3ae7fc

Thanks for your answers. Regards, Philippe Fornaciari IRIUM Software Technologies 13 RUE JACQUES MONOD BP 90396 17001 LA ROCHELLE CEDEX 1 FRANCE Tel +33 (0)5 46 44 75 76 Fax +33 (0)5 46 45 34 17 Email p.fornaciari@irium-tech.com Web www.irium-group.com  Please consider the environment before printing this e-mail Les informations contenues dans ce courrier, y compris les éventuels documents joints, peuvent être confidentielles. Ce courrier est destiné exclusivement au(x) destinataire(s) et aux personnes autorisées par le(s) destinataire(s). Si vous n’êtes pas le destinataire visé, nous vous informons par la présente que la loi interdit strictement toute diffusion, copie ou divulgation de cette communication. Si vous avez reçu ce message par erreur, nous vous saurions gré d’en informer immédiatement l’expéditeur par courrier et de supprimer ce message de vos systèmes. IRIUM n’est responsable - ni ne souscrit à – aucune opinion, recommandation, conclusion, sollicitation, offre ou accord ou encore information contenu(e)s dans cette communication. IRIUM décline toute responsabilité en cas de préjudice résultant de l’utilisation de l’Internet et/ou du courrier. -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art Kagel Sent: vendredi 9 janvier 2015 17:47 To: ids@iiug.org Subject: Re: CDC on table with no PK [34443] Mechanically possible, but dangerous. Updates and deletes would affect all rows that happen to be duplicates. It is a REALLY poor schema that has tables without at least a unique index key even if it isn't declared as a primary key formally. FYI, there is a 3rd party product that does heterogeneous replications between Informix and other vendors' databases in both directions if needed. Not cheap but then you don't have to roll your own and debug it. Take a look at dbmoto: http://www.hitsw.com/products_services/dbmoto.html Though they will probably tell you the same thing I have. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Fri, Jan 9, 2015 at 9:39 AM, PHILIPPE FORNACIARI < p.fornaciari@irium-tech.com> wrote: > Hello everybody, > > I have a need for replication from Informix IDS 12.10 to another > database vendor. One possibility is to use the CDC to get the changes > from IDS to replicate to the target. > > Is it possible to use the CDC API on table with no primary key ? > > Thank you for your answers, > > P. Fornaciari > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --089e013d1c3a56383e050c3ae7fc ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.