Implementation of Large Database Migration Tool Based on Metadata-driven

With the upgrade of data model,companies need to migrate the original data stored in the database to the new database,the general practice is through the development of special software to achieve,but simply rely on the tools of database system provided can not meet the actual data migration needs.Through the study of ETL model and metadata-driven technology,in combination with the needs of China's oil data centers,large-scale data migration,defined the general framework of the data migration model system.The study was focus on the key technologies-the express of mapping schema,describe and storage with metadata.Finally,the use of metadata is drived the implementation of the ETL engine functions.The technical and functional has been applied in large-scale data migration of China's oil data centers.