Export & ImportIn 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.
ScriptsDatabase 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, LoadExtract, 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.
IntegrationIf 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.