Kshell Script to Compare One Database on One Server to the Same

Posted in 2005

Clifton M. Bean — Mon, 28 Feb 2005 19:59:13 — source: IIUG Forums & Mailing Lists

I seem to remember someone already having written a script to do this and report any row count differences found. Before re-investing the wheel, I thought I would ask around. I looked through the IIUG Software Archives (or at least I tried to) and couldn't find what I was looking for. Any help out there ? :) Take care. Clifton

↪ replying to Clifton M. Bean

Clifton M. Bean — Tue, 01 Mar 2005 02:10:02 — source: IIUG Forums & Mailing Lists

Row count differences, with or without the system tables record counts. At this time though, I do not know if there will be direct connectivity between the two systems or not; I am presuming there will be; otherwise, it is a simple row count comparison using a temp table on the new server side. Take care. Clifton Jack Parker <vze2qjg5@verizon.net> wrote: You interested in rowcount differences or schema differences? j. ----- Original Message ----- From: "Clifton M. Bean" To: Sent: Monday, February 28, 2005 4:00 PM Subject: Kshell Script to Compare One Database on One Server to the Same Database on Another Server [4364] > I seem to remember someone already having written a script to do this and report any row count differences found. Before re-investing the wheel, I thought I would ask around. I looked through the IIUG Software Archives (or at least I tried to) and couldn't find what I was looking for. > > Any help out there ? :) > > Take care. > Clifton > > >