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

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

On 10/5/06, Robert Manning <rob...@gm...> wrote:
> On 10/5/06, Matthew Hixson <hi...@po...> wrote:
> > What about using Create Table Script and Create Data Script to create
> > text files which you could then run through diff?
> >    -M@
>
> It's crude but I've used this method before when pressed; and I
> recommended this to the original poster.
>
> Rob

Ah yes, but of course you didn't see my original post, because SourceForge
was rejecting emails from GMail users at that point in time.  Here is what I
said in my post that was probably never delivered:

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 choose "Create Table Script" and each table's
DDL will be added to the SQL editor.

Rob