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. Data Science

    Data science is a field of Big Data that seeks to provide meaningful ...
  2. Data Mining

    Data mining is a a process used by companies to turn raw data ...
  3. Data Warehousing

    Data warehousing is the electronic storage of a large amount ...
  4. Data Loss

    Data loss occurs when valuable and/or sensitive information on ...
  5. Data Exhaust

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

    A data privacy technique that seeks to protect private or sensitive ...
Related Articles
  1. Investing

    How Credit Rating Risk Affects Corporate Bonds

    Credit migration risk is a vital part of the credit risk assessment, specifically with regard to corporate bonds which underlie numerous rating changes.
  2. Investing

    Investigating The Stock Premium Puzzle

    The Three-Factor Model tries to demystify the baffling small-cap and value return premiums.
  3. Managing Wealth

    Data Integrity Analyst: Job Description & Average Salary

    Learn about the average salary of a data integrity analyst and the required skills, education and previous experience needed to fill this role.
  4. 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.
  5. 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.
  6. Tech

    Predictive Analytics Drives Return for Investors

    A new industry of predictive analysis has developed to make sense of big data and give investors real-time buy and sell recommendations based on the patterns forming in the data long before traditional ...
  7. Insights

    Could Europe's Migrant Crisis Help its Economy?

    Middle class migrants are uniquely positioned to contribute to economic growth in Europe.
  8. 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.
  9. 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.
  10. 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.
  1. What is the most important type of data used in business analytics?

    Consider what makes data useful in business analytics, and why companies should search for the types of data that provide ... Read Answer >>
  2. 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 >>
  3. 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 >>
  4. What impact does Moore's Law have on the electronic sector?

    Understand the groundbreaking implications of Moore's Law on the economic health of several industries, including semiconductors ... Read Answer >>
Hot Definitions
  1. Inflation

    Inflation is the rate at which prices for goods and services is rising and the worth of currency is dropping.
  2. Discount Rate

    Discount rate is the interest rate charged to commercial banks and other depository institutions for loans received from ...
  3. Economies of Scale

    Economies of scale refer to reduced costs per unit that arise from increased total output of a product. For example, a larger ...
  4. Quick Ratio

    The quick ratio measures a company’s ability to meet its short-term obligations with its most liquid assets.
  5. Leverage

    Leverage results from using borrowed capital as a source of funding when investing to expand the firm's asset base and generate ...
  6. Financial Risk

    Financial risk is the possibility that shareholders will lose money when investing in a company if its cash flow fails to ...
Trading Center