Re: [Squirrel-sql-users] Looking for ways to facilitate "diff" between two databases

[Robert M. <rob...@gm...>]

On 10/2/06, Karr, David <dav...@wa...> wrote:
> I was wondering whether SQuirreL can help me generate a "diff" report
> between two databases.  I'm mostly concerned about getting DDL
> differences, but content diffs of a limited subset of tables would also
> be useful.  I think I'll probably just have to write a Java utility to
> do this, but if SQuirreL can do part of this, that would be useful.
>

David,

Right now with SQuirreL you are limited to selecting the "Columns" tab of
a selected table and visually comparing the two table definitions.  (This
would be a few more steps ) but you could run "Create Table Script" on
each table whose DDL is to be compared and save the defs to two files
and diff with your favorite file editor (WinMerge, etc..)  You can also select
multiple tables when you chose "Create Table Script" and each table's
DDL will be added to the SQL editor.

Rob