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

suppose a new application is given to u and asked complete report with in one hr what will do?

4 Answers  


How will you test language converter e.g. (English to Spanish) without Automation tool? OR What are the test cases or scenarios for language converter? Conditions: 1. without Automation tool, 2. You know only English language. 3. Make sure the tests should produce 80-90% pass result.

2 Answers   Mastek,


what is testplan? and can you tell the testplan contents?

2 Answers   IBM,


PLS SEND REAL TIMERS, WHAT IS SOA TESTING..IM TRYING 3+ YR.. I HAVE GOOD KNOWLEDGE ON MANUAL TESTING... NOW IM NEW TO LEARN "SOA TESTING" IS BEST OR NOT? BEFORE LEARNING SOA TESTING ANY SKILLS ARE REQUIRED..... AND NOW WHAT IS THE MARKET FOR SOA TESTING... AND IT IS BASED ON PROGRAMMING OR NOT?

0 Answers  


What is Database normalisation

3 Answers  


What is System Testing Phase? Which types of testing will be conducted in system testing phase?

1 Answers  


We r developing one Web Site for construction company. In that Web site we have different option like About Us,Contact Us,Home,Sites,Site Map,Search Etc........ and front page of that web application contains 6 different pictures means single page contain 6 pics etc... write Test plan ,Test Scenarios,Test Case ....Plz answer this question ASAP

5 Answers  


1.What is the purpose of ?check-in?,? check-out??

6 Answers   Eka Software,


Diference between sanity & somke testing?

6 Answers  


Explain 5 Test Matrics?

2 Answers   Persistent,


What is difference between web site testing, desktop application testing and wireless application testing? what is the difference in testing strategy to test them?

0 Answers  


what is difference between smoke test and exploratory test.?

1 Answers  


Categories