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
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
What is frame level testing and how do we test it?
Can you explain regression testing and confirmation testing?
How can write testcases on a code under development pls give asnwer
what is meant by application server and its functions?
3.if a questions asked as,what is the quality standards you are following? what i need to tell.
Hi, Anybody knows about Hexaware company..
Test Cases For Router&Switch
What is un-installation testing?
what is acid testing?
what are the risks and contingencies u had in ur project?
What impact ratings have you used in your projects?
How we will do Memory Testing? There is any tool to do that testing and to whome this testing to be performed?
Explain Operational Acceptance Testing with example ?
Inwhat basis the time is allocated for testing the application?