Upgrading for database structure

70 pts.
Tags:
Java/J2EE
JBoss application server
MySQL Database
Oracle
SQL Server
SQL Server 2005
WebLogic Server
WebSphere Application Server
hello everyone 
Maybe my previous question was not the correct question to ask.
I am in the middle of making an application upgrade which includes DB structure upgrade with keeping Data "data loss is not accepted here".
I have a complex DB structure in my application which depends "in some cases heavily depending" on database specific features.
I use SQL Server "2005/2008" , Oracle "10g" mainly, but MySql is also used.
current modifications include:
* new IDs created and modified, some of these IDs have foreign keys  ,related to specific Field names that are new created ...
* modifications of Field types, lengths , charsets ...
here are notes about my case:
* some tables are partitioned. and some of them include LOB data.
* some tables are used as archived data "almost 100M records in some tables"
* data has to be moved as smooth as possible with NO LOSS.
My Questions are:
- Is there a best practice scenario to do this upgrade? 
- as mentioned before , my application is depending on a lot of database specific features , how can migration plan be optimized to work with major 2 DB engines "SQLSERVER / Oracle"?
- Is upgrading better or creating new DB Schema and applying new structure modified? then migrate this data? in such case how can i handle sequences , ... to make sure no errors occur in runtime?
thanks in advance
sorry for the stray ,,,
have a good day all.


Software/Hardware used:
SQL Server , Oracle , Java , J2EE , Linux , Virtualization

Answer Wiki

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

the best way to to this upgrade, is to use an ETL like Talend ou Informatica.
Talend is an open source we use it for our data migration.
for more informations you can visit talend web site
best regards

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