Re: Comparing row counts between 2 dbs

[Emmitt Dove]

Albert,

Very nice, and thank you!

One interesting side note: I ran it here, and afterwards could not find the compare.rb* files. Very puzzling. Then I realized that I had STATICDB set ON. Naturally, in that state the CREATE SCHEMA command is disallowed. However, the CREATE TABLE commands executed and created temporary tables in the second database. I viewed the differences (there were some, all understandable in terms of changes I made to the database since) and, when I DISConnected, the whole process was cleaned up with no residuals except the .DAT files, and those I can delete in the CMD file.

Wunnerful!

Here you go:

-- ----------------------------------------------------------------------
-- Compare.cmd

Emmitt Dove
Manager, DairyPak Business Systems
Blue Ridge Paper Products, Inc.
40 Lindeman Drive
Trumbull, CT  06611
(203) 673-2231
[EMAIL PROTECTED]
[EMAIL PROTECTED]

================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: INTRO rbase-l
================================================
TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: UNSUBSCRIBE rbase-l
================================================
TO SEARCH ARCHIVES:
http://www.mail-archive.com/rbase-l%40sonetmail.com/