A-Z Popular Blog Data Search »
Technology Guides

4 Types of Data Migration

 , updated on
Data migration is the process of converting data from one format to another. It is typically performed to launch new or upgraded systems, services, infrastructure, functions or features. The following are the common types of data migration.

Export & Import

In some cases, tools support exporting data to a neutral format and importing that same format. For example, business software may allow data to be imported from delimited text files. This allows a data analyst to work with data in a spreadsheet to get it in the expected format and then import it.


Database scripts are a common way to import and export data from a database. This is essentially the same process as import/export with a script used as opposed to a user interface. If data is small enough, a spreadsheet may be used to prepare data for the target database. Alternatively, database operations such as SQL commands can often be used to create temporary tables and move things around until they fit into the new data model.

Extract, Transform, Load

Extract, Transform, Load (ETL) is a class of tools that provide support for data migration. ETL tools can typically handle large data sets. They are designed to connect to a number of data sources and automate transformations such as mappings and business rules to convert from one data model to another.


If data integration is being developed between two systems this can occasionally be leveraged to perform the initial data migration. Integration tools such as ESB have mapping and transformation capabilities that can handle a data migration. Tools designed for real time integration are typically considered somewhat resource intensive for a one time data migration. Nevertheless, they can potentially do the job.
Overview: Data Migration
The process of converting data from one data model and format to another.
Related Concepts


This is the complete list of articles we have written about data.
Abstract Data
Atomic Data
Big Data
Cohort Analysis
Dark Data
Data Analysis
Data Architecture
Data Attribute
Data Cleansing
Data Collection
Data Complexity
Data Consumer
Data Control
Data Corruption
Data Custodian
Data Degradation
Data Dredging
Data Entity
Data Federation
Data Integration
Data Integrity
Data Liberation
Data Lineage
Data Literacy
Data Loss
Data Management
Data Massage
Data Migration
Data Mining
Data Owner
Data Producer
Data Quality
Data Remanence
Data Risks
Data Rot
Data Science
Data Security
Data States
Data Transformation
Data Uncertainty
Data Veracity
Data View
Data Virtualization
Data Volume
Data Wipe
Decision Support
Deep Magic
Empirical Evidence
Event Data
Hard Data
Information Assurance
Legacy Data
Machine Data
Market Research
Master Data
Misuse of Statistics
Personal Data
Personal Information
Predictive Analytics
Primary Data
Primary Research
Qualitative Data
Qualitative Info
Quantitative Data
Raw Data
Reference Data
Small Data
Soft Data
Source Data
Statistical Analysis
Statistical Population
Structured Data
Transaction Processing
Transactional Data
Types Of Data
Unstructured Data
If you enjoyed this page, please consider bookmarking Simplicable.

Data Integration

A list of data integration techniques.

Data Virtualization vs Data Federation

The difference between data virtualization and data federation.

ESB Failure

When enterprise service bus fails, it is usually for one of two reasons.

Types Of Master Data

A list of criteria for deciding if something is master data or not.

Data In Transit

A definition of data in transit with examples.

Data Architecture

The definition of data architecture with examples.


The definition of digitalization with examples.

Integration Examples

An overview of integration with examples.


An overview of data with a list of examples.

Types Of Data

The basic types of data.

Dark Data

The definition of dark data with examples.

Data Massage

The mysteries of data massage.

Data Definition

Several useful definitions of data.


A definition of analytics with examples.

Data vs Information

The difference between data and information.

Hard Data vs Soft Data

The difference between hard data and soft data.

Human Readable

A definition of human readable.

Data Loss

The common types of data loss.
The most popular articles on Simplicable in the past day.

New Articles

Recent posts or updates on Simplicable.
Site Map