Application Upgrade and Data migration

70 pts.
Tags:
Database
Development
Oracle
SQL Server
Web application development
Hello Sir/Mam
We have a web application that has an intensive usage of Database operations.
This application of course has some sort of sophisticated Database (tables, indexes, ...)  structure according to Database engine used. 
My question now is , what is the best practice to migrate old database structure to new one "including data of course".
any advice is very welcomed!!!
thanks a lot 
and
Best Regards


Software/Hardware used:
Database, Development, Oracle, SQL Server

Answer Wiki

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

The best practice for migration of data from one database platform to another database platform, involves first understanding and mapping your data and then ensuring that you are not using database specific features and if you are then to remap the relationship to a schema or set of schemas that your new database platform will support. Then you would use an ETL and there are a wide variety of ETL tools from open source tools with community and enterprise editions such as Pentaho Data Integration or Talend Integrator Suite to commercial ETL tools like Informatica PowerCenter, Oracle Data Integrator, Business Objects Data Integration.

Thanks Mortimer1

Well, I have a database specific features in my case.
And actually i am in the middle road either to migrate data or update current working DB structure and keeping data.

any help is very much welcomed

thanks a lot

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
  • Mshafie
    Thanks Mortimer1 Well, I have a database specific features in my case. And actually i am in the middle road either to migrate data or update current working DB structure and keeping data. any help is very much welcomed
    70 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