EFFECTIVE DATABASE MIGRATION STRATEGY - THE NEED FOR ADDRESSING DATABASE MIGRATION CHALLENGES OF TODAY, TOMORROW AND BEYOND

Prabin R. Sahoo

Abstract

Database migration is considered to be a least priority activity in software industry. This is a wrong perception as database migration in reality becomes a nightmare to many who have experienced it. As the migration process starts to the new target system, migration issues crop up which pile up gradually and become unmanageable during the migration process. That is why to eliminate the migration issues require highly effective database migration strategies. There are several papers where migration strategies have been mentioned, and there are a number of tools those have been developed for successful database migration, yet database migration issues still persists and organizations find it difficult to adapt an effective migration strategy. Organizations spend enough in purchasing tools to do the migration. By the time one realizes that the business is suffering after the post migration, it is too late. A huge amount is spent in the repair process. This is not because of lack of migration strategy, rather lack of effective migration strategy. For example: Using a migration tool can be a strategy, however before that an assessment is required to find out how much percentage of tool can do and how much percentage required to build in-house tools, how would the database behave after migration etc? Such analysis are lacking in today’s migration strategy. This paper proposes an effective approach towards database migration to address migration assessments, the migration issues, also improvising reusability.

References

  1. EMC, 2007. Data Migration Considerations: A customer Engineering Residency.
  2. Joseph R. Hudicka, 1998. An overview of Data Migration Methodology, http://www.dulcian.com/Articles/Over view_Data_Migration_Methodology.htm.
  3. Gints Plivna, 1997. Data Migration from old to new application: an experience, Oracle.
  4. Premier International Enterprises, 2004. Inc. Rapid Application Development for Data Migration, 221 North LaSalle, Chicago.
  5. Philip Howard, 2007. Data Migration, TOWCESTOR, UK Christopher Burry, David Mancusi, Avanade, 2004. How to plan for data migration, http://www.computerworld. com/s/article/93284/How_to_plan_for_data_migration ?ta..
  6. Todd Muirhead, Dave Jaffe, Paul Rad, 2005. Migrating Oracle Database 10g from Sun server to Dell Servers, Dell Power Solution.
Download


Paper Citation


in Harvard Style

R. Sahoo P. (2011). EFFECTIVE DATABASE MIGRATION STRATEGY - THE NEED FOR ADDRESSING DATABASE MIGRATION CHALLENGES OF TODAY, TOMORROW AND BEYOND . In Proceedings of the 13th International Conference on Enterprise Information Systems - Volume 1: ICEIS, ISBN 978-989-8425-53-9, pages 335-338. DOI: 10.5220/0003418103350338


in Bibtex Style

@conference{iceis11,
author={Prabin R. Sahoo},
title={EFFECTIVE DATABASE MIGRATION STRATEGY - THE NEED FOR ADDRESSING DATABASE MIGRATION CHALLENGES OF TODAY, TOMORROW AND BEYOND},
booktitle={Proceedings of the 13th International Conference on Enterprise Information Systems - Volume 1: ICEIS,},
year={2011},
pages={335-338},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0003418103350338},
isbn={978-989-8425-53-9},
}


in EndNote Style

TY - CONF
JO - Proceedings of the 13th International Conference on Enterprise Information Systems - Volume 1: ICEIS,
TI - EFFECTIVE DATABASE MIGRATION STRATEGY - THE NEED FOR ADDRESSING DATABASE MIGRATION CHALLENGES OF TODAY, TOMORROW AND BEYOND
SN - 978-989-8425-53-9
AU - R. Sahoo P.
PY - 2011
SP - 335
EP - 338
DO - 10.5220/0003418103350338