Sunday, October 25, 2009

Scope of Migrating to Oracle

My wife hates spiders and after heroically saving her last week from one she asked through her fingers how big it was. My best description was
"It was bigger than a small spider, but smaller then a big spider".

I dont know if that desciption fits here, but let me try and jam it into a incredibly weak analogy.

Migrating from Sybase to Oracle is not simple yet its not incredibly difficult.

Hmm , not great is it. Lets start again.

Here are the parts (I can think of) you need to think about when migrating

  • Database : Data + Stored Programs

  • Scripts : ETL and Backup/Restore

  • Applications : Custom Apps and 3rd Party Apps

  • Hardware : You may want new hardware / storage

  • DBAs and Developers : May need training

  • Users : May need training if the application changes. For Example you may write a Application Express App.

Performing a migration by hand is possible but there are tools available for free from Oracle which help along the way.

1 comment:

  1. Siebel CRM Online Training, ONLINE TRAINING – IT SUPPORT – CORPORATE TRAINING http://www.21cssindia.com/courses/siebel-crm-online-training-156.html The 21st Century Software Solutions of India offers one of the Largest conglomerations of Software Training, IT Support, Corporate Training institute in India - +919000444287 - +917386622889 - Visakhapatnam,Hyderabad Siebel CRM Online Training, Siebel CRM Training, Siebel CRM, Siebel CRM Online Training| Siebel CRM Training| Siebel CRM| If you’re serious about a career in IT, 21st Century would like to provide you a guidance don’t hesitate to organize a free demo session. For any further information regarding the courses once go through our website Visit:http://www.21cssindia.com | Call Us +917386622889 - +919000444287 - contact@21cssindia.com

    ReplyDelete

About Me

A Principal Engineer in the Oracle SQL Developer Team. Views are my own.