What kind of test cases are need to be included in the
database migration testing?



What kind of test cases are need to be included in the database migration testing?..

Answer / jyothi

Testing should cover the hardware, the SQL Server
installation, security, database objects, data, and performance.

Physical architecture of the database. Have the data files,
transaction log, tablespaces, and other items that comprise
the database been created correctly? Has the SQL Server
instance been properly configured?


Security. Have the logins and users been correctly created?
Have the appropriate permissions been assigned? Is the
database physically secure?


Logical architecture of the database. Have the tables,
views, stored procedures, triggers, and other database
objects been created successfully?


Data. Have the contents of the tables been transferred
correctly? Do tables contain the correct numbers of rows? Is
the data valid?


Functionality. Do the stored procedures, triggers, views,
and other items comprising Transact-SQL code operate in the
same manner as the original Oracle objects?


Performance. Does response time and throughput meet
requirements and match user expectations?

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More Manual Testing Interview Questions

dif b/w localisation and globalisation testing breifly explain ?

1 Answers  


Hi can anyone Explain smoke testing with real time examples

3 Answers   Student,


wht is ISO standards

1 Answers  


please give information about ERP Projects and how V-model use in project

0 Answers  


What is the diffrence between BUILD & RELEASE ?

3 Answers   ACS, Resience,






Write down the template for test case.

5 Answers   Hexaware, IBM, Infotech, Wipro,


What are the five dimensions of the Risks?

2 Answers  


Why do u choose Testing as ur career?

10 Answers   Minecode,


Write an algorithm to find an palindrome

2 Answers   Zycus Infotech,


what type of diffects we can find while preparing the test plan

3 Answers   G S Lab, Patni, Saba,


list of methods that is used to document the requirements of a software.

0 Answers  


hai friends i did my bcom (distance with out inter)and iam pursuing mca(distance alagappa university)iam learning testing cource in ameerpet can i elgibel for testing jobs pls guide me … …and send details to rangavijetha@gmail.com..thanks

0 Answers  


Categories