Export data from the source database to a supported DB2 format
Use IMPORT or LOAD to populate the DB2 system
Correct any Referential Integrity or constraint failure issues
Perform tests against the source data and the DB2 data to check for accuracy and completeness
Data can be moved (often called "data migration") from one DBMS to another by using a number of commercially available
data migration tools (including porting and migration tools such as the IBM Migration Toolkit (MTK), WebSphere DataStage, and others).
In many cases, as the data is moved, parts of it are converted into a format that is compatible with DB2 (date and time data, for example). This process can be quite lengthy when there is a large amount of data, which makes it quite important to have the conversions well defined and tested.
In some cases, it still may be necessary to perform some customized conversions. Specialized data, such as time series and geo-spatial, may require extensive adjustments to work in DB2, depending on the proprietary format they were stored in. This process is usually performed through the creation of a small program or script.
