Design and Application of Data Migration System in Hetertogeneous Database

With the development of economic system reform in China, trans-regional economy presents rapid growth trend, and requires establishing an rapid, stable trans-regional clearing system between banks. In this paper we study the approach and process of data migration and take a bank's database as an example. Especially, we introduce the basic functions of each module in data migration process and the test procedures after data migration. The process of data migration have two steps. First, tables to be migrated, primary key and foreign key are created in object database. Then data in source database are migrated into object database. This paper is based on database migration project and detailedly introduces technique issues of data migration involving manual work, which may contribute to organizations that have data migration demonds.