tool for stored proc. (written in oracle/sql) execution?

9 Nov 2005 8:40 AM

B Deepak

Hi,

Can somebody suggest a tool with which I can compare the result obtained
after execution of stored procedure in oracle and sql?
Basically, I have migrated my stored procedure written in sql 2000 to
oracle. Now I want to check whether result obtained after execution of
oracle SP will be remain same as that of the sql stored procedure execution
result.

Any help will be appreciated

Thanks in Advanced,
Deepak

9 Nov 2005 5:40 PM

David Gugick

B Deepak wrote:

> Hi,
>
> Can somebody suggest a tool with which I can compare the result
> obtained after execution of stored procedure in oracle and sql?
> Basically, I have migrated my stored procedure written in sql 2000 to
> oracle. Now I want to check whether result obtained after execution of
> oracle SP will be remain same as that of the sql stored procedure
> execution result.
>
> Any help will be appreciated
>
> Thanks in Advanced,
> Deepak

If you save the results to the same file format (e.g. CSV), you can probably
use a simple file compare utility (like the fc.exe command line utility
which comes with Windows or windiff.exe). You could also dump the results
from the SQL Server into a table with a unique index on all columns and try
and insert the data from the linked Oracle database. If the row counts to
start are the same and no rows get into the table, you're probably fine. You
could select from the SQL Server table where NOT EXISTS in the other (and
vice-versa).

Also, some third-party tools like Taod for SQL Server from Quest can perform
data comparisons on two tables.

--
David Gugick
Quest Software