What steps are involved when source DB is a Oracle and target db is SQL Db?

295 pts.
Tags:
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]
ASKED: December 31, 2009  9:23 AM
UPDATED: January 2, 2010  2:05 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following