A data warehouse (DW) is a collection of corporate information and data derived from operational systems and external data sources. A data warehouse is designed to support business decisions by allowing data consolidation, analysis and reporting at different aggregate levels. Data is populated into the DW through the processes of extraction,...
Data migration is the process of transporting data between computers, storage devices or formats. It is a key consideration for any system implementation, upgrade or consolidation. During data migration, software programs or scripts are used to map system data for automated migration.
Data migration is categorized as storage migration, database migration, application migration and business process migration. These scenarios are routine IT activities, and most organizations migrate data on a quarterly basis.
Data migration occurs for a variety of reasons, including:
Data migration may impact business operations when it creates extended downtime, compatibility and performance issues. Organizations use various strategies to minimize such impacts, including effective planning, technology, implementation and validation.
Planning, migration and validation are key to effective data migration. Planning requires a clear understanding of design requirements, such as scheduling, replication requirements, hardware requirements, data volume and data value. Prior to data migration, an organization typically communicates methodologies, installs migration software and configures required hardware.
Automated data migration minimizes human intervention and application downtime and enhances migration speed. Migration documentation facilitates tracking and reduces future migration costs and risks.
Once data migration is complete, an organization validates statistics to determine data accuracy. Finally, data cleaning facilitates improve data quality via the removal of unnecessary or repetitive data.
Read More »
Join 138,000+ IT pros on our weekly newsletter
Home | Advertising Info | Write for Us | About | Contact Us
2010 - 2015
Partner Sites :