Articles & Content


Adventures in moving: Migrating legacy data to DB2 - Lessons learned (F03)

Topic: 2009 NA

Subtopic: DB2 for LUW

DATE: 2009-5-12 (01:30 PM - 02:30 PM)
SPEAKERS: Raul Delhumeau (Raul Delhumeau, Inc)

Legacy data is an often overlooked result of infrastructure consolidation or new application rollout projects. Even though it may reside in obsolete or unsupported environments, it is still of critical value to the organization for legal, auditing and research purposes. Successful migration of legacy data goes beyond physical relocation and should provide easy access to both ad-hoc queries and existing reports. This requires careful planning, practical thinking for a flexible execution and a clear understanding of its original format and usage. An overview of the key aspects of legacy data and the migration process will be followed by a step-by-step guided tour of the planning and execution of the migration process itself. The session is focused on practical application of the reviewed concepts as well as lessons learned along the way.

EXP. LEVEL: Intermediate


Overview of the value of legacy data and the challenges to migrate it - what needs to be migrated and how will it be used?

Examine the migration process in detail - research / map / define / execute / rollout.

Review the various data transfer strategies in order to choose the optimal one.

Coverage of the traps and pitfalls of data mapping and process do's and doníts.

Understand the importance of the final deliverables - a usable / "next generation" replacement for an existing data source.

Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.