I like to look at database issues but I've never used this module. It looks pretty awesome. So as curious as I was I decided to try it. In order to replicate the issue I made a little sample script. When I tried to use:

$oDB_Comparison->deep_compare(@aTable_Names);

I get several errors that are very familiar to me from some work with DBIx::Class. You need to have tables defined a certain way in DBIx::Class for the deep->compare to work (or so it seems to me). But you can use the basic compare without seeing the errors:

        $oDB_Comparison->compare(@tables);

[download]

Also, unless I have this line in my code:

        $oDB_Comparison->verbose;

[download]

no results print, so you want to add that in I think. You need to check your definition of $dbh1 and $dbh2 like mje said.

my $dbh1 = DBI->connect('DBI:DATABASE_TYPE:DATABASE_NAME:DATABASE_SERV
+ER','USERNAME','PASSWORD') || die "Error Connecting to \$dbh1: ".$DBI
+::errstr."\n";

[download]

Also see DBIx::Class

#!/usr/bin/perl

use strict;
use warnings;
use DBI;
use DBIx::Compare;

my $dbh1 = #SEE sample connect line above
my $dbh2 = #SEE sample connect line above

my $oDB_Comparison = db_comparison->new($dbh1, $dbh2);

my @tables = ('Table1', 'Table2);
$oDB_Comparison->verbose;
$oDB_Comparison->compare(@tables);

[download]

In reply to Re^2: Even though there are two separate database handles error shows need two separate database handles to compare by wallisds
in thread Even though there are two separate database handles error shows need two separate database handles to compare by Anonymous Monk

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.