Hiyas, folks.
I've got two databases loaded up on my server - the "regular" eq database, and the PEQ_Lucin database. My server is running off the "regular" databsae, but there's a lot of stuff that I'm pulling out a bit at a time from the PEQ_Lucin database. One of the things I kept running into was wanting to see if there was an item in one database not in the other. Below is a perl script that will allow you to input your "first" database name, your "second" database name, your "table" name and your "compare column" name. It will then print out a list of items in the second database that are not in the first one. There's probably a way to do this in SQL, but I couldn't find it, so here's a script that might be useful to someone.
Usage:
unique.pl -f database1 -s database2 -t table -c column
So...this program will load up the column from the table you specific in the 2nd database and see if that item exists in the first database. If it doesn't, it will print out that row for 'ya, and at the end will tell you how many differences there are.
I get an error when I upload the script. You can find it at
http://www.verycarr.com/apps/scripts/unique_items.pl
Perl Script to Compare Two Database Tables - What's Different?
Threaded Mode
