Functional testing

Functional testing is a set of tests in which new and existing functionality of the 

system are tested after migration. Functional testing includes all components of 

the RDBMS system, networking, and application components. The objective of 

functional testing is to verify that each component of the system functions as it 

did before migrating, and to verify that new functions are working properly.

Integration testing

Integration testing examines the interaction of each component of the system. All 

modules of the system and any additional applications (Web, supportive 

modules, Java programs, etc.) running against the target database instance 

should be verified to ensure that there are no problems with the new 

environment. The tests should also include GUI and text based interfaces with 

local and remote connections.

Performance testing

Performance testing of a target database compares the performance of various 

SQL statements in the target database with the statements' performance in the 

source database. Before migrating, you should understand the performance 

profile of the application under the source database. Specifically, you should 

understand the calls the application makes to the database engine.

Volume/load stress testing

Volume and load stress testing tests the entire migrated database under high 

volume and loads. The objective of volume and load testing is to emulate how the 

migrated system might behave in a production environment. These tests should 

determine whether any database or application tuning is necessary.

Acceptance testing

Acceptance tests are carried out by the end users of the migrated system. Users 

are asked to simply explore the system, test usability, and system features, and 

give direct feedback. Acceptance tests are usually the last step before going into 

production with the new system.

Post migration tests

Because a migrated database can be a completely new environment for the IT 

staff, the test plan should also encompass examination of new administration 

procedures like database backup/restore, daily maintenance operation, or 

software updates.

268 

MySQL to DB2 UDB Conversion Guide