What is 'Data Migration'

Data migration is the process of moving stored digital information between computers, systems, or formats. Data migration occurs for a number of reasons, including server replacement or maintenance, a change of data centers, data consolidation projects and system upgrades. As much of a company’s corporate knowledge and business intelligence is contained in its data, any data migration project must be done carefully to minimize risks.

BREAKING DOWN 'Data Migration'

Data migration represents a significant risk to business continuity if it is not done properly. Loss of data is, of course, a worse case scenario, but companies must also deal with downtime, compatibility issues, and overall system performance issues. Data migration is made more difficult by large amounts of data, diverse formats of data, and divergent data habits within a corporation.

To minimize the risks of data migration, companies create detailed data migration policies that prioritize back ups, moving order and concurrent data environments when possible. If it is not possible for a company to run a pre-migration environment while the new environment is prepped, then there will be significant downtime as business operations on the current applications are suspended to allow for the data migration. This type of stop, transfer, and start data migration may be required when moving to new platforms or when there are hard limits on physical storage and swaps or fixes are needed on the existing storage technology.

Zero Downtime Data Migration

The zero downtime migration model depends on having enough storage to create and run two complete environments. A full copy of a company’s data is taken into the new environment and tested while employees stay in the old environment. The bugs are worked out of the new system, ensuring that all the applications still work and everything is where it should be. After testing is complete, a fresh copy is brought in and all the employees are switched over to the new environment. The old data environment is sometimes left open for a period of months so that employees can get files from the old data system but not write new data to those servers. In all data migrations, a post migration data audit is done to check for data loss.    

Improving Data Migration

One thing that can improve a data migration is to clean out and standardize data practices prior to migration. The organization of a company’s data is often a reflection of the different filing habits of its people. Two people with the same role may well use completely different practices. For example, saving contracts by vendor in one case and by fiscal year and month in another. Unifying data practices can be a much bigger job than actually migrating the data, but clean, coherently organized data backed up by clear policies helps to future proof a company’s data for many migrations yet to come.

  1. Big Data

    Big data refers to the growth in the volume of structured and ...
  2. Data Warehousing

    Data warehousing is the electronic storage of a large amount ...
  3. Data Exhaust

    Data exhaust is the chain of information resulting from a person’s ...
  4. Data Anonymization

    Data anonymization seeks to protect private or sensitive data ...
  5. Cloud Storage

    Cloud storage is a way for businesses and consumers to save data ...
  6. Data On-Boarding

    Data on-boarding refers to the process of bringing related offline ...
Related Articles
  1. Tech

    How Big Data Has Changed Finance

    The vast proliferation of data and increasing technological complexities continues to transform the way industries operate and compete.
  2. Tech

    Big Data in Financial Services Comes With Some Risks

    Big data is playing a larger role in finance but its application does not come without risks.
  3. Tech

    Financial Advisors' Next Big Tech Tool: Big Data

    Here's how big data is playing a crucial role in the work life of financial advisors and some strategies on how to take advantage of the technology.
  4. Investing

    Youtube's MLB Deal: Google's Big Play in Streaming

    As sports migrates away from cable, the big tech and media players are scrambling for a slice.
  5. Insights

    World Bank Data For Dummies

    Developing countries can't always afford to track the data crucial to setting the right economic policies and programs. That's where the World Bank steps in.
  6. Tech

    How Big Data Has Changed Marketing

    Big data has enabled marketers to enhance their customer engagement and customer retention strategies by providing insight into behavior and thoughts.
  7. Personal Finance

    Career advice: Financial analyst versus data analyst

    Learn the distinctions between financial analysts and data analysts, and determine which career is right for you based on your skill set and interests.
  8. Tech

    How Big Data Has Changed Insurance

    No longer confined to technology, big data has become integral to providing solutions to the insurance industry's long standing challenges.
  9. Tech

    Introduction To Accounting Information Systems

    Learn what an accounting information system is and the six main parts of this indispensable business asset for managing a company's financial data.
  10. Trading

    Time Running Out For Microsoft Bulls (MSFT)

    Six tests at October 2015 breakout support have failed to attract buying interest, raising odds for a breakdown that ends the long uptrend.
  1. When should I use seasonally adjusted data from the consumer price index (CPI)?

    Learn what seasonally adjusted data is, how it is determined, and when it should be used to evaluate the information gathered ... Read Answer >>
  2. What impact does a higher non-farm payroll have on the forex market?

    The employment report, released by the Bureau of Labor Statistics, is an economic indicator that contains data on the employment ... Read Answer >>
  3. Where can I find historical stock/index quotes?

    Finding historical quotes on stocks and indices online has never been easier. Use Investopedia's historical data tool for ... Read Answer >>
  4. Where can I find fiscal year data for publicly traded corporations?

    Access fiscal year data for publicly traded corporations that is required by the government to be readily available to the ... Read Answer >>
Trading Center