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

Explain Testing process in your organization?

1278


hi i want manual testing interview question(3+exp)please tell me

1736


what is the relation between all tabs in quality center & explain the testing process in quality center with tabs?

1808


can anyone tell me few critical bugs in ecommerce project.

5809


wat are the questions would the project leader ask about the project?? please do send the answers early.

7215


What is the difference between action & script ?

2223


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?

2311


What is showstopper defect?

905


Hi, I want "Intergraph" placement papers for experienced people which was conducted recently in Hyderabad. Thanks, Purnima.

2160


Hi Could someone please provide Siebel Testing Interview questions for 5 years exp.

4665


What is alpha testing?

882


What is six sigma?

989


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

1684


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?

1740


Why performance testing is performed? What are tools of performance testing?

967