Database migration testing in Testing Fundamentals - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is database migration testing?

Database migration testing is the process of verifying that data is correctly moved from one database to another without loss or corruption.

beginner

Why is data validation important in database migration testing?

Data validation ensures that the data in the new database matches the original data exactly, preventing errors and data loss.

intermediate

Name two common types of database migration testing.

1. Schema migration testing - checks if database structure is correctly migrated.<br>2. Data migration testing - checks if data is accurately transferred.

intermediate

What is a good way to check data integrity after migration?

Compare row counts, run checksum or hash functions on tables, and verify key data fields between old and new databases.

beginner

What could cause migration testing to fail?

Possible causes include data loss, mismatched data types, missing tables or columns, and incorrect data transformations.

What is the main goal of database migration testing?

A To improve database speed

B To ensure data is moved correctly without loss

C To create new database tables

D To delete old data

The main goal is to verify that data is transferred correctly and completely.

Which of the following is NOT a focus of database migration testing?

A Data accuracy

B Schema correctness

C User interface design

D Data integrity

User interface design is unrelated to database migration testing.

What method can help verify data integrity after migration?

A Running checksum comparisons

B Changing database passwords

C Deleting old tables

D Adding new columns

Checksum comparisons help confirm data has not changed during migration.

Which problem might cause migration testing to fail?

A Backing up data

B Using a faster network

C Adding indexes

D Data loss during transfer

Data loss is a critical failure in migration testing.

Schema migration testing checks for:

A Correct database structure

B Data accuracy

C User permissions

D Network speed

Schema migration testing ensures the database structure is correctly moved.

Explain the key steps involved in database migration testing.

Think about what you do before, during, and after moving data.

Describe common challenges faced during database migration testing and how to address them.

Consider what can go wrong and how testers check for problems.