DB Migration from 8.1.7 to 10gR1

pts.
Tags:
CRM
Database
IBM DB2
Oracle
I want to migrate from 8i(8.1.7) to 10gR1 in a new server. I will shutdown 8i and run with 10gR1 in a new server. If any of my application not working with 10g ,i need to fall back to 8i in old server. Is it possible to take only the delta changes from 10gR1 which has happend for such duration and apply to 8i(8.1.7),if yes How, if no what is the best practice.

Answer Wiki

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

Think backwards. Leave 8i up as production and progress your changes to the 10g database, using 10g as parallel. Once you are assured that all transactions work, then convert finally to 10g and archive the old 8i database. Do not be too fast to make 10g production.

Second question – best practices. Create a test environment to parallel production, upgrade test to 10g and parallel enter all (or representative) transactions in test. Once satisfied with test, upgrade production. Keep two environments forever, using test for development and enhancement, and then progress approved changes after testing into production.

Discuss This Question: 1  Reply

 
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
  • Ajmalziyad
    [...] Address: http://itknowledgeexchange.techtarget.com/itanswers/db-migration-from-817-to-10gr1/ (0) Comments Read [...]
    0 pointsBadges:
    report

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