Re: tool for stored proc. (written in oracle/sql) execution?
- From: "David Gugick" <david.gugick-nospam@xxxxxxxxx>
- Date: Wed, 9 Nov 2005 12:40:53 -0500
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
.
- References:
- tool for stored proc. (written in oracle/sql) execution?
- From: B Deepak
- tool for stored proc. (written in oracle/sql) execution?
- Prev by Date: Re: Management Studio - Open File
- Next by Date: Re: Management Studio - Open File
- Previous by thread: tool for stored proc. (written in oracle/sql) execution?
- Next by thread: Re: 2005 Management Studio: Jobs Details (summary page)
- Index(es):
Relevant Pages
|
