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

What are all the basic elements in a defect report?

4 Answers  


Who will perform Integration Testing?

17 Answers  


what is Waterfall model?

9 Answers  


If you have 1000 test cases which takes atleast 4 months for execution and now project has to be delivered within 2 weeks how will you execute your test cases. Which ones should be executed first.

11 Answers   GXS,


i want to take the questions of software testing of QA infotech company

0 Answers   Infotech,






if yahoo ceo asks you to do performance testing for yahoo site, what are the inputs you ask from them?

0 Answers   QA, SmartData, Yahoo,


How do u write integration test cases?do u have any special format?

4 Answers   IndiumSoft,


what is the difference between web applications and lient server applications

3 Answers  


Risk analysis consist of A)1 step b)2nd step c)4 step d)6 step Which is correct Answer please any one tellme and mail me

2 Answers   CashEdge,


What is junit & api?

0 Answers  


How much konwledge of server require for a software tester.?

2 Answers  


I would like to reserve railway ticket online and paying the fare through net banking. Friends help me to write test cases???? Give answer for this as soon as possible...

3 Answers   360Logica,


Categories