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 is product backlog...

2 Answers   HCL, Wells Fargo,


how do you determine what to test?

2 Answers  


What if an organization is growing so fast that fixed testing processes are impossible? What to do in such situations?

0 Answers  


Please Tell me About Fish-Bone Model. Thanks in Adv.

0 Answers  


How u test 3 Drop Down menu means one is for state,other is for city and Pin code test these drop down

2 Answers  






What exactly is quality control?

0 Answers  


Give two examples of HIGH SEVERITY and LOW PRIORITY.

4 Answers   MAHINDRA,


If tester found some bugs in the application then which format they will send it to development team.

4 Answers   CTS,


which test is used for memory leakage?

8 Answers   HCL,


testing is a process or methodology,diff between methodology and process?

6 Answers   BirlaSoft, Cap Gemini,


What is bottom-up approach?

0 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,


Categories