Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: SUSPECT: RE: Quick and dirty way to compare table contents

Re: SUSPECT: RE: Quick and dirty way to compare table contents

From: Jared Still <jkstill_at_gmail.com>
Date: Sat, 4 Mar 2006 14:52:20 -0800
Message-ID: <bf46380603041452tf8eefa5la0ed578eb9429269@mail.gmail.com>


It must be said: What ever you did in
Access for comparing strings could be
better done in Perl.

--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist


On 3/4/06, Ethan Post <post.ethan_at_gmail.com> wrote:

>
> I deal with a lot of different db's in which configuration data may
> differ, for example a row in one table stores the value that is
> displayed for a control on a form. This type of thing can get out of
> sync pretty easily between various qa/test environments and source
> control. I went ahead and wrote a program in Access a few weeks ago
> that is working pretty nicely which will do a complete compare of two
> tables (assume no longs and such) and log all the changes that need to
> be made, as well as make the changes if I like. Works well on small
> tables. Started writing it in PLSQL and was way too complicated based
> on my requirements. So chalk one up for MS Access and ODBC for all you
> detractors! I am sure there are some tools that do this (Toad likely)
> but I needed to exclude certain columns (timestamps), wanted to be
> able to compare tables of different names with same structure, wanted
> to be able to create tables to store the data in etc...basically the
> requirements meant write it myself. It was actually pretty simple
> based on what it is doing.
>
-- http://www.freelists.org/webpage/oracle-l
Received on Sat Mar 04 2006 - 16:52:20 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US