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 is the growth in the volume of structured and unstructured ...
  2. Data Science

    Data science is a field of Big Data which seeks to provide meaningful ...
  3. Data Analytics

    Data analytics is the science of drawing insights from raw information ...
  4. Cloud Storage

    Cloud storage is a way for businesses and consumers to save data ...
  5. Customer Relationship Management ...

    The principles, practices, and guidelines that an organization ...
  6. Business Intelligence (BI)

    Business intelligence (BI) refers to the procedural and technical ...
Related Articles
  1. Investing

    Investigating The Stock Premium Puzzle

    The Three-Factor Model tries to demystify the baffling small-cap and value return premiums.
  2. Tech

    Data Analyst: Job Description & Average Salary

    Learn about a data analyst career and how much money you can expect to make. Understand the skills and education needed to become a data analyst.
  3. 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.
  4. 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.
  5. Personal Finance

    Financial Data Analyst: Job Description & Average Salary

    Learn about the average salary for a financial data analyst position and the skills, education and experience employers require of candidates.
  6. Investing

    How Will Brexit Affect the EU Employment Market?

    Now that Britain has voted to leave the European Union, how will that decision affect its employment market?
  7. Tech

    Data Analyst: Career Path & Qualifications

    Explore becoming a data analyst, one of the hottest careers in the current economy; learn about the career paths and the qualifications you need to get hired.
  8. Tech

    Alphabet Is Top PayPal Choice for Cloud Hosting (GOOGL, AMZN)

    While PayPal will benefit from migration to cloud, Google will get a high profile client considering the operations and scale of PayPal
  9. 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.
  10. Tech

    Common Interview Questions for Data Analysts

    Learn how to prepare for your data analysis job interview by having solid answers to these common questions that measure your knowledge and effectiveness.
  1. What are some of the drawbacks of industrialization?

    Learn about the major drawbacks of industrialization, such as environmental damage, income inequality, overcrowding of cities, ... Read Answer >>
  2. What are some common functions of business intelligence technologies?

    Understand the common functions of business intelligence technologies, and learn how business intelligence is used to increase ... Read Answer >>
  3. What data does the Bureau of Labor Statistics collect?

    Collected data includes unemployment numbers, inflation, prices, pay and benefits, time use of Americans, import/export numbers ... Read Answer >>
  4. What is the difference between business intelligence and business analytics?

    Find out what differences, if any, exist between business intelligence and business analytics, and learn the role of each ... Read Answer >>
  5. 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 >>
  6. What area of the consumer price index (CPI) should I use if there is no CPI for the ...

    Learn what data is published by the Bureau of Labor Statistics and how to use the various Consumer Price Index data sets ... Read Answer >>
Hot Definitions
  1. Call Option

    An agreement that gives an investor the right (but not the obligation) to buy a stock, bond, commodity, or other instrument ...
  2. Standard Deviation

    A measure of the dispersion of a set of data from its mean, calculated as the square root of the variance. The more spread ...
  3. Entrepreneur

    An entrepreneur is an individual who founds and runs a small business and assumes all the risk and reward of the venture.
  4. Money Market

    The money market is a segment of the financial market in which financial instruments with high liquidity and very short maturities ...
  5. Perfect Competition

    Pure or perfect competition is a theoretical market structure in which a number of criteria such as perfect information and ...
  6. Compound Interest

    Compound Interest is interest calculated on the initial principal and also on the accumulated interest of previous periods ...
Trading Center