Home > IT Answers > Development > What steps are involved when source DB is a Oracle and target db is SQL Db?
Mayurkhe
295 pts.
 What steps are involved when source DB is a Oracle and target db is SQL Db?
Data Migration Testing, Manual Testing, Oracle Database, Quality assurance
How to test  when source DB is a Oracle and target db is SQL Db?

What  to test  in particular when source DB is a Oracle and target db is SQL Db?

I have worked on when both the target DB  and Source Db was SQL Server.How is it different when Source Db is ORacle and Target DB is SQL Server.

[o:p][/o:p]

Software/Hardware used:
ASKED: December 31, 2009  9:23 AM
UPDATED: January 2, 2010  2:05 AM
RELATED QUESTIONS
Answer Wiki:
Not much is different. You just tell the SQL Server that the source is Oracle. You'll need to have a decent amount of rights on the Oracle database, I believe that the SQL Server will add some triggers to the Oracle tables so that it can keep track of what needs to be replicated. Like every major system change this should be tried in a QA/Test environment first.
Last Wiki Answer Submitted:  January 2, 2010  2:05 am  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _