| Database migration is a system upgrade project, which is to change the Database management system while still mantaining the existing system architecture, data, business logic and application interface. Such a system upgrade is usually out of business or system performance considerations. The entire migration process is often very large, which includes database objects migration, data migration, code migration, system compare testing, and many other technical aspects.The purpose of the database migration is to upgrade systems, and to resolve the existing problems of the current system functions and performance. Therefore, our first goal is to ensure that the logic is correct, and then we are going to enhance the performance of the System. These two parts are both an important part of the migration project. Also, because we will not change the logic of the original system architecture, we focus on the compare test between the original system and the system after migratrion. Comparative test can also be divided into correctness testing and performance testing: correctness testing is to ensure the logic function of the system after migration is totally the same with the original system, the same input can only generate the same output. It is also called validation; performance testing is to improve the performance of the original system under the same conditions. In addition, this paper introduced the synchronization between different Oracle server.This paper based on PnA financial system, and explained the above-mentioned problems and might-be issues in migration progress in detail. We focused on special code conversion and the performance improvement, and also covered all aspects of database migration. This paper can be a good reference value to other projects like this.Finally, this paper introduced what we will do in the future in database system migration project. That is, refactoring the Database System based on the understanding in the current logic. |
PDF Full Text Request