Re: db object comparisons

On 9/12/07, Robert Manning <robert.m.manning@xxxxxxxxx> wrote:
> On 9/12/07, David Durham, Jr. <david.durham.jr@xxxxxxxxx> wrote:
> > Does Squirrel SQL have a way to compare SQL catalogs for differences
> > in schemas, tables, procedures, constraints, etc.?
> >
> > I'm looking for results along the lines:
> >
> >   catalog a is missing table x, which is present in catalog c
>
> At the moment, I'm working on a plugin that will allow you to diff two
> tables and get a listing of columns that are different and how they
> differ.  No support yet for schema/catalog comparison yet.  That is
> probably a few months away.

That's great.  I'm happy with Squirrel as an SQL workbench type of tool.

I've actually written some catalog comparison type of tools in the
past using JDBC metadata.  Another thing that's useful, besides
meta-data comparisons, is a comparison of the actual data.  In the
case of a table, a row-count is sometimes useful pseudo-equivalency
test.  It also gives you an idea of how expensive a record values
comparison would be.  I'd be willing to donate time to a db comparison
plugin for Squirrel, but I'm not yet familiar with the source code for
Squirrel.

Thanks,
Dave

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/