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
Explain Testing process in your organization?
hi i want manual testing interview question(3+exp)please tell me
what is the relation between all tabs in quality center & explain the testing process in quality center with tabs?
can anyone tell me few critical bugs in ecommerce project.
wat are the questions would the project leader ask about the project?? please do send the answers early.
What is the difference between action & script ?
1)can u tell me, what is the roles and responsibles for database tester in DB testing from requirement stage to UAT stage....2) what are the i/p documents he wants and who wil give the i/p docs. to DB tester.and tell me what exactly db test case means what?
What is showstopper defect?
Hi, I want "Intergraph" placement papers for experienced people which was conducted recently in Hyderabad. Thanks, Purnima.
Hi Could someone please provide Siebel Testing Interview questions for 5 years exp.
What is alpha testing?
What is six sigma?
ive been looking for a junior tester job for quite some time now, but most company keep requisting for experienced staffs, but if i dont start from somewhere how do i get the experience
Build with fixes has been deployed on QA environment if asked by your manager to reproduce how can you reproduce the issues? (by using the previous build) Can you access the previous build? If so ,what are the tools or how can you access?
Why performance testing is performed? What are tools of performance testing?