Thread by @thecodemancer_

Without effective testing, there's no way to know if your database has been migrated correctly. There are many things you need to verify.

🧵1/10

#databases #databasemigration #dataengineering #sql #googlecloud

1. Was the database schema migrated correctly?
2. Has all the data been migrated?
3. How about user logins?
4. Can all of the users still connect and can users only access the data they're permitted to access?

🧵2/10

#databases #databasemigration #dataengineering #sql

There are basically three categories of testing that needs to be considered; structural, functional and non-functional.

🧵3/10

#databases #databasemigration #dataengineering #sql #googlecloud

Structured testing. Test to ensure that:

👉 All tables have been migrated.
👉 Fields, data types, lengths, and constraints were migrated as expected.
👉 All indexes have been created.
👉 Primary-foreign key relationships have been created.

🧵4/10

#dataengineering #sql

Structured testing. Test to ensure that:

👉 Primary and foreign keys match correctly in related tables.
👉 All stored procedures and triggers were migrated.
👉 User logins were migrated successfully.

🧵5/10

#databases #databasemigration #dataengineering #sql #googlecloud

Functional testing. Test to ensure that:

👉 All data was migrated correctly.
👉 Stored procedures and triggers work as expected.
👉 User logins wok as expected.

🧵6/10

#databases #databasemigration #dataengineering #sql #googlecloud

Functional testing. Test to ensure that:

👉 User can only perform operations and access data as permitted.
👉 Querys and views continue to return expected results.

🧵7/10

#databases #databasemigration #dataengineering #sql #googlecloud

Non-functional testing. Types of non-functional tests include:

👉 Performance testing to ensure that queries and transactions complete quickly enough to meet user expectations.

🧵8/10

#databases #databasemigration #dataengineering #sql #googlecloud

Non-functional testing. Types of non-functional tests include:

👉 Load testing to ensure that the application performs at peak demand.
👉 Stress testing to find the load at which the database breaks.

🧵9/10

#databases #databasemigration #dataengineering #sql #googlecloud

Do you know another category of testing that needs to be considered?

--
👨‍💻

👉 I tweet about my data-journey and some tips and resources along the way. Follow me for more.

🧵10/10

#databases #databasemigration #dataengineering #sql #googlecloud

@threadreaderapp
unroll