squirrel-sql-users

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

[Karr, D. <dav...@wa...>]

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.

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,

If you decide to write the utility yourself, consider giving it an open
source license so that someone might turn it into a SQuirreL plugin
in the future.

Rob

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

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

[Matthew H. <hi...@po...>]

What about using Create Table Script and Create Data Script to create  
text files which you could then run through diff?
   -M@

On Oct 2, 2006, at 11:40 AM, Karr, David 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.
>
> ---------------------------------------------------------------------- 
> ---
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to  
> share your
> opinions on IT & business topics through brief surveys -- and earn  
> cash
> http://www.techsay.com/default.php? 
> page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>

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

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

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

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

[richard j. <rdj...@gm...>]

Why not just use the xml file that the scheme data is stored in? True you
have to turn on caching to get it to save the file but I would think that
you could use it for your diff.

Richard

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
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share
> your
> opinions on IT & business topics through brief surveys -- and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>

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