| 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 exiting problems, especially the performance problem, in the system, so performance tuning on the target system is also a very important aspect. At the same time, 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.Base on the Information Resource Integrated Management System(IRIMS) database migration project for certain power supply company in Liaoning Province, this thesis will detailedly describe the technique in all the phases of Sybase to Oracle migration process. Especially discuss the topic of data migration, special SQL conversion, Oracle performance tuning, compare testing, etc. This case will cover all the aspects of Sybase to Oracle database migration project and also will give the common database migration a good reference.In this thesis, the author not only focuses on the database technique discussion, but also perfects the fuction of the original system, enhances the performance and the running efficiency of the original system. At present, this system has been used in certain Power Supply Company successfully, and gotten many good comments. |
PDF Full Text Request