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 is functional testing terminologies
What are the possible test scenarios around AVS check of any credit card? (Testing through payment gateway online) (What are the fields we should check while checking AVS and CVV)
What is known as data-driven testing?
what risks do u faced u r projest how do you solve
What kind of input do we need from the end user to begin proper testing?
what are the risks and contingencies u had in ur project?
what is the technical challange you faced in your module.please ans me the question i just want example can me any example please very important
What is Cyclometric testing?
how to write defects in excel sheets when defects occured
How do your characteristics compare to the profile of the ideal manager that you just described?
What is user acceptance testing (uat)?
what is system testing? as test eng, what do u do in sys testing? who invoves in sys testing?
What are the main key components in web applications and client and server applications?
1.How to maintain the Bug status Report? 2.What is project based Company and product based company?
What impact ratings have you used in your projects?