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 Test Plan with example? Explain following in the test plan with examples What is being tested? What are pass/fail criteria? When will each test occur? What Hardware & Software environment is required? What features must be tested? What features will not be tested? What are the responsibilities of individuals & organisation in the project?

2418


What do you mean by Cause Effect Graphing? in which standard its mentioned?

1916


WHAT IS PROTOCAL TESTING..EXPLAIN? L2, L3 PROTOCALS TESTING MEANS WHAT?EXPLAIN BRIEFLY

6543


how can you test the web environment for security testing?

1690


Presently working in software company as a software test engineer with 1.5 yrs of experience but i am 2002 passout.Gap is 6 yrs.Is there any problem getting job in MNC? Which criteria HR follows for recruiting test engineer?

1815


Hello everybody, How many people do you think one sprint team can have in average?

1514


how to generate id in testdirector? a) Td id 1 b) td id 2 c) td id 3 d) td id 4 which is correct answer please any one of the tell me and mail me

2047


what is date field test case

1698


What is bug severity?

912


I have cleared written test and one Technical round in one company? now i have to face an Client Round through telephony? Any body have faced client round, how will it be , wil they ask technical or is it only formality round? im nervous, plz let me know wat all they may ask? i have this round on monday?

2696


When have you had to focus on data integrity?

2394


Discuss what test metrics you feel are important to publish an organization?

4560


how to write defects in excel sheets when defects occured

1771


how many meeting in realtime environment? what are they?plz explain?

1741


In interview How do explain in Testcase of Calcuator,Cellphones, Email testing?

1987