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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

what are the advantages of manual and automation testing ? and which one would u term as efficent testing and effective testing ?pls do reply thankx in advance

1445


What is frame level testing and how do we test it?

1971


Can you explain regression testing and confirmation testing?

704


How can write testcases on a code under development pls give asnwer

1539


what is meant by application server and its functions?

6167






3.if a questions asked as,what is the quality standards you are following? what i need to tell.

1365


Hi, Anybody knows about Hexaware company..

1680


Test Cases For Router&Switch

2064


What is un-installation testing?

659


what is acid testing?

2133


what are the risks and contingencies u had in ur project?

2054


What impact ratings have you used in your projects?

685


How we will do Memory Testing? There is any tool to do that testing and to whome this testing to be performed?

1513


Explain Operational Acceptance Testing with example ?

894


Inwhat basis the time is allocated for testing the application?

1424