Enterprise Replication - Compare data in 2 tables
Lloyd S asked how to compare data in two tables under Enterprise Replication when the replica's record count differed from the primary. Obnoxio The Clown asked for the version. Madison said v10 has cdr check to detect differences, and mentioned a toolkit to find and repair them. Jairo Gubler said they built Java applications to compare and synchronize tables on Informix 7 and 9.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hi All, Is there a way to compare data in two tables in ER. I have a table in my replication server in which the count of records does not match the primary server. Is there a way to determine that. Thanks in advance. Lloyd
Lloyd S said: > > Hi All, > > Is there a way to compare data in two tables in ER. I have a table in my > replication server in which the count of records does not match the > primary > server. Is there a way to determine that. ER may or may not do it for you. It depends on the version, which you did not bother to tell us. -- Bye now, Obnoxio "... no bill is required as no value was provided." -- Christine Normile -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean.
In v10, we have the cdr check which will detect this. Also I did a talk at a user conference in which I described a tool kit which contained the means to do this and to repair the differences. Al= so I will be doing a simlar 'took-kit' talk in the conference in Aniheim...= = "Lloyd S" = <lloyd_s@rediffma = il.com> = To Sent by: ids@iiug.org = ids-bounces@iiug. = cc org = Subj= ect Enterprise Replication - Compare= 10/06/2006 01:21 data in 2 tables [7590] = PM = = = Please respond to = ids@iiug.org = = = Hi All, Is there a way to compare data in two tables in ER. I have a table in m= y replication server in which the count of records does not match the pri= mary server. Is there a way to determine that. Thanks in advance. Lloyd ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. =
We developed some generic JAVA applications for comparing and sincronizing tables on INFORMIX 7 and 9. Jairo Gubler Obnoxio The Clown escreveu: Lloyd S said: Hi All, Is there a way to compare data in two tables in ER. I have a table in my replication server in which the count of records does not match the primary server. Is there a way to determine that. ER may or may not do it for you. It depends on the version, which you did not bother to tell us. -- Jairo Gubler Supervisor SIC - TBD - Tecnologia em Banco de Dados DÍGITRO TECNOLOGIA E-mail: [1]jairo.gubler@digitro.com.br Fone: +55 48 3281-7213 / +55 48 3281-7000 Fax: +55 48 3281-7381 / +55 48 3281-7299 Site: [2]www.digitro.com References 1. mailto:jairo.gubler@digitro.com.br 2. http://www.digitro.com/