What are the possible test scenarios that need to be tested when a dat

1.	What are the possible test scenarios that need to be tested when a database gets migrated from one SQL server to another?
Answer» Firstly, when migration happens, we need to be aware of all the changes and enhancements are done in the new SQL server. Based on this information, design your test case SUITE by considering the FOLLOWING points: What is the data type used? What is the length of the fields used in the server? Are the database objects CREATED as EXPECTED in the new SQL server? Perform stress testing on the new SQL server to identify any risks ASSOCIATED with the migrated environment.

What are the possible test scenarios that need to be tested when a database gets migrated from one SQL server to another?

Answer»

Firstly, when migration happens, we need to be aware of all the changes and enhancements are done in the new SQL server. Based on this information, design your test case SUITE by considering the FOLLOWING points:

What is the data type used?
What is the length of the fields used in the server?
Are the database objects CREATED as EXPECTED in the new SQL server?
Perform stress testing on the new SQL server to identify any risks ASSOCIATED with the migrated environment.

Discussion

No Comment Found

Related InterviewSolutions

What are the differences between GUI Testing and Database Testing?
How will you fetch the values from TableA that are not present in TableB without using the NOT keyword?
Is it possible to have multiple primary keys in a table?
How do you check for an error in a stored procedure consisting of 1000s of lines of code?
How can you validate the tables and columns in the database?
What are the best practices that need to be followed while performing database testing?
What are the most commonly occurring issues that are faced during database testing and how can they be solved?
How can you test the data integrity in database testing?
How can you validate the ACID properties? Explain with an example.
How can you test Transactions in SQL Databases?

What are the possible test scenarios that need to be tested when a database gets migrated from one SQL server to another?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment