Heterogeneous Database Migration And Its Synchronization Issues

Database migration means to change the Database management system of a software while keep the original system architecture, data and business logic unchanged. This is often a large process which involves lots of technique content including database object migration, data migration, code migration, system testing, etc.The database migration process is also a system upgrade process. It aims to solve the existing problems, especially the performance problem, in the system, so performance tuning on the target system is also a very important aspect. Furthermore, in order to ensure the data safety and the safety of operating systems, and make the data synchronization about a new database with the original database is very important significance. Last, due to that the database migration project will not change the system logic; the test will focus on compare test. The compare test includes correctness test and performance test. Correctness test will ensure the migrated system has same business logic with the original system;Performance test will help us to shorten the program run time.Based on the ERP system of a tobacco's industry database migration project, this thesis will detailed study the technique in the solution of Sqlserver to Oracle migration process. The solutions, the techniques and the problems which encountered in various stages of the migration process are discussed in detail. Especially discuss the topic of special SQL conversion Oracle performance tuning, compare testing, etc. Based on the environment of the isomerous database migration, Having analysed the present status of data synchronization techniques,the thesis proposes a method of enterprise data synchronization based on SQL restoring against the database migration's environment. The method captures the logs of source database in way of trigger or log analyzer,restores the SQL statements which have altered source database, and records the logs. Then the target node gets these SQL statements from the log file, and executes these statements to update target database.This method has the characters of fully heterogeneous,flexibility,universality and high safety.This thesis discussed this case that the Sqlserver database to the Oracle database migration project and isomerous database synchronal solutions covers all the aspects of general database migration and synchronal engineering, and also will give the common isomerous database migration and synchronization a good reference.In this thesis, the author focuses on the isomerous database migration and synchronization discussion and does not bring the code logicextracting into technique development cycle. How to combine the two techniques into the database migration and synchronization process will be the next phase research topic and will be the direction of database migration and synchronal engineering.