|
Answer» For data load testing:
- You need to have knowledge about source database (data tables, columns, associated constraints, data types) and destination database (data tables, columns, data types, and constraints).
- You need to check the COMPATIBILITY between source database and destination database via the DTS PACKAGE.
- You need to Open corresponding DTS package in SQL Enterprise Manager and run the DTS package (If you are using SQL Server).
- Then you need to compare the COLUMN’s data of Source and the TARGET.
- You have to check the number to rows of Source and Target.
- After updating data in the Source database, you need to check whether the changes have been reflected on destination database or not.
- You need to check about junk character and NULLs.
- Database load testing, check the VOLUME of the database server to process the queries, and also check the response time of database server and client.
For data load testing:
|
