From Sybase To Oracle Database Migration Project

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. 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.Base on the P&A system database migration project, this thesis will detailed describe the technique in all the phases of Sybase to Oracle migration process. Especially discuss the topic of 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 focuses on the database technique discussion and does not bring the code logic extracting into development cycle. How to combine the two techniques into the database migration process will be the next phase research topic and will be the direction of database migration.