Database Migration in Investment Banks or any other place is done for the improvement of technology leading to a better performance. For example the same query fired on Sybase 15 database would take lesser time as compared to Sybase 12. The database migration can be between different versions of the same database for example Oracle 9i to Oracle 10g or migration to a different type of Database example Sybase to Oracle.
Test Approach for Database Migration Testing
The test approach for database testing is very crucial since in any investment bank the data is of utmost importance. If data is not migrated properly on the new database then the results could be disastrous. Hence, it is very important to use an approach which takes care of the existing data being migrated smoothly and the new data can be created like it was before migration.
Also, it is very important that the existing functionalities of the application do not change after the migration. So, the regression phase in database migration is also very important. If the migration is from one version of the database to another version of the same database, then running a sanity pack is enough generally but if the migration is to a different kind of database then running a regression pack is inevitable.
It is always advisable to do the database migration in parts in the following cases
- When the database is huge
- When the database migration is to a different type of database
The testing approach for Functional testing should take care of the following steps-
- Before the developers run the build for database migration, extract the data which is already present on the older database with all the details and verify the data after the database has been migrated
- After the database has been migrate, create the same sort of data that you were able to successfully create before the database migration
- Also try operations like amending and deletion after the database has been migrated on the new and old data.
- Also, try to perform all the operations which involves querying database
No comments:
Post a Comment