How to compare results of stored procedures? RRS feed

  • Question


    We have a .NET application which works with MS SQL 2005 as data source.

    As one of our customer wanted data source as Oracle and hence we exported the schema, data and etc from MS SQL 2005 to Oracle and rewrote all stored procedures on Oracle by using some migration tool.


    We are able to bring up the UI (written in C# and ASP.NET) and able to perform some basics like logging and few other operations.


    Question: How to test result of each stored procedure on MS SQL 2005 with the result of its corresponding (re-written) stored procedure in Oracle DB?


    i)                    We want to see whether the newly written stored procedures on Oracle DB are functioning properly or not.

    ii)                   We have a total around 2000 stored procedure like this.


    Could some one suggest me whether is there any tool which will perform this activity or can we write a small utility by using some logic.


    Thursday, December 13, 2007 3:58 PM