Design And Implementation Of A Database Data Migration System

Data migration tool is one of database system management tools. it will migratedata if the old database system and the new database system switches. And whether tomaintain the accuracy of the data in the existing database system,and make the newsystem normally running smoothly, is an important basis on judging a data migrationtool. Currently, several databases of which the market share is relatively high have theirown data migration tools, such as DTS for Microsoft SQL Server and Oracle WarehouseBuilder tool for Oracle.The data migration system based on DM database is designed on referring to thecurrent domestic and international migration system and developed by using interfaces ofJDBC. The overall structure consists of three parts, which are storage center, statementscomposing center and controlling center. Storage center will store the sourceof database objects, such as schemas and tables and other objects. Statementssynthesis center is used to synthesis SQL statements, that are read thestatement select, insert, and write statements and create statement create. Controllingcenter is overall controlling of these the three parts, solving the problems that how tocommunicate the three parts, like the human brain for human.And the most important part of data migration is transforming data type. JDBC datatype can be converted as an intermediary between the database model and data type.Under this model, data type mapping between JDBC data types and the "source" or"objective" database is a JDBC data type mapping chain. Then through the "source" and"target" database JDBC data type mapping, Then follow the corresponding relationshipbetween the time during the data migration, you can type thecorresponding data through JDBC JAVA data types read data from the sourcedatabase, and then through a similar approach poured into its new target database. This process is the data type conversion processing.The method of Logic control on the migration is that for all tasks to be migrated,first creating the table structure, and then migrating the data, finally for the migrating ofall primary and foreign key and index. This method avoids migration problems which isbrought by references between objects as tables.