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 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?
What do you mean by Cause Effect Graphing? in which standard its mentioned?
WHAT IS PROTOCAL TESTING..EXPLAIN? L2, L3 PROTOCALS TESTING MEANS WHAT?EXPLAIN BRIEFLY
how can you test the web environment for security testing?
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?
Hello everybody, How many people do you think one sprint team can have in average?
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
what is date field test case
What is bug severity?
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?
When have you had to focus on data integrity?
Discuss what test metrics you feel are important to publish an organization?
how to write defects in excel sheets when defects occured
how many meeting in realtime environment? what are they?plz explain?
In interview How do explain in Testcase of Calcuator,Cellphones, Email testing?