7 Replies Latest reply on Jan 22, 2015 8:09 AM by Mkirtley-Oracle

    Testing Data ETL'd from MS SQL Server to Oracle

    user5949888

      We have some data (19 tables, row counts from 8,000,000 down to 100) being ETL'd from MS SQL Server 2008 R2 to Oracle 11gR2 via IBM DataStage jobs. I've been asked to test the data, but am having trouble connecting to both databases in one connection so I can run my SQL comparisons.

       

      For example, I can connect to either database separately in SQL Developer, but running a query comparing data across the two doesn't seem possible. Can anyone recommend a way to do this? I'm not sure how to approach it.

       

      Steve