Re: Comparing Data across platforms

There isn't an easy way to do this at present.  I began building a
differencing plugin a while back, but it's still in the experimental
phase of development. That said, one technique which is fairly labor
intensive is to create a data script for each table, save the script
as a file, then compare the scripts using a graphical diff tool like
WinMerge.  To create a data script, you would right-click on the table
and choose "Scripts -> Create Data Script".  To create a table
structure script, you would use "Scripts -> Create Table Script".  For
this you need to have the SQL Scripts plugin installed which is part
of the "standard" set of plugins.

Rob

On 10/18/07, Hale, Tina <HaleT@xxxxxxxxxx> wrote:
>
>
> We currently have a process that allows users to enter data into a Oracle
> Database and have it sync to a DB2 Database on an AS400.  I can currently
> query the data using SQuirrel in both environments.  Is there a way to
> 'join' the two connections to run comparisons queries of the data?
>
>
>
> Tina Hale
> Business Analyst
> Cintas Corporation - IT
>
> Phone : (513) 701-2087
> Fax   : (513) 573-4940
>
> E-mail: halet@xxxxxxxxxx
>
>  This e-mail transmission contains information that is intended to be
> confidential and privileged. If you receive this e-mail and you are not a
> named addressee you are hereby notified that you are not authorized to read,
> print, retain, copy or disseminate this communication without the consent of
> the sender and that doing so is prohibited and may be unlawful. Please reply
> to the message immediately by informing the sender that the message was
> misdirected. After replying, please delete and otherwise erase it and any
> attachments from your computer system. Your assistance in correcting this
> error is appreciated.
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >> http://get.splunk.com/
> _______________________________________________
> Squirrel-sql-users mailing list
> Squirrel-sql-users@xxxxxxxxxxxxxxxxxxxxx
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>
>

-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/