Q
Problem solve Get help with specific problems with your technologies, process and projects.

Impact on apps of migration from Oracle 8 to 10g

We would like to migrate our database from Oracle 8.1.7 to Oracle 10g. We would like to know the impact for our application developed using Delphi and our other components.

We would like to migrate our database from Oracle 8.1.7 to Oracle 10g. We would like to know the impact for our application developed using Delphi and our other components. How can we find out whether Oracle 10g will support the features in the other components or not?

I am going to point you to two similar questions I answered last week:

Are Oracle 10g and VB 6.0 compatible?
Impact of Oracle 9i upgrade on Java front end

The only difference between your question and the previous one is that they are using VB 6, whereas your applications were created in Delphi.

It would be nearly impossible for me to predict what types of application issues you will encounter when you upgrade to Oracle 10g. I have no information about your application, the data or how it's used. The common theme (and the message I keep repeating to others with this type of question) across these questions is that you must test your upgrade in a non-production environment. The testing must be documented, thorough, and involve your application support folks as well as business users. As well, the upgrade process (especially one like this that is taking a database from Oracle8i to 10g) must be repeated several times, each time with extensive testing. Time spent testing is never wasted!

This was last published in May 2007

Dig Deeper on Oracle database export, import and migration

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

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

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close