Enterprise Replication - Compare data in 2 tables
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/