December 16, 2009 at 12:20 pm
How can the applications be tested after applying a service pack on sql server 2005? We have few access applications and was wondering what needs to be tested and what would be the best way to do it to make sure that everything is functionaing properly after the Service pack.
December 16, 2009 at 1:42 pm
Trooper09 (12/16/2009)
How can the applications be tested after applying a service pack on sql server 2005? We have few access applications and was wondering what needs to be tested and what would be the best way to do it to make sure that everything is functionaing properly after the Service pack.
Setup a test server configure the application, check if every thing works. Apply SP3 and restart the SQL Server and start testing the application again.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
December 16, 2009 at 1:57 pm
The necessary things have already been setup , the question is what exactly needs to be tested, I have never looked at these aplicatins and now has been asked to test them. So I am wondering what should be the approach....
Should i be using the application and Identifying the various functionailities and make sure that they function the same way on the test server as well after the SP has been applied
OR
Should I target the main functionalities that have been changed with the help of SP3 and should I be laying my eyes on these changes after the Service pack has been applied.
I really need a quiker way to do it and I beleive second option would be a good idea...any suggestions?
December 16, 2009 at 6:32 pm
Do you have an internal QA department?
Previous test cases for the application?
Are you able to go through the application given certain scenarios and receive expected results?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 18, 2009 at 8:38 am
Do you have an internal QA department? - No
Previous test cases for the application? - No
Are you able to go through the application given certain scenarios and receive expected results?
I have never looked at it , but the problem is trying to figurre out what scenarios have to be checked and what should be expteced?
Is there a way that the data can be captured which is entered by the users on prod and the same info can be given in test (after SP3) to check the results. I am sure there are few tool but was wondering which would be the best one.
December 18, 2009 at 8:41 am
By the wat the application was not developed in house - it was bought from a vendor. So I guess there would be no way that I could get the test cases.....
December 18, 2009 at 8:49 am
At this point, it would be the archaic method of interviewing the users. Watch what they enter and verify the results. Repeat the process when testing the upgrade.
Alternative, get a few of the users to volunteer to test the app for you in the test environment.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 18, 2009 at 9:39 am
I was afraid that I would be left with this option....I guess I will have to go though the pain ...
Any tool that would help me in gathering the info being fed by the users in to prod , to be fed into test environment to compare the results?
December 18, 2009 at 9:50 am
You can run profiler, that will more or less create a trace that you can use for playback. As far as testing the app though - it wouldn't catch any of the errors that might be application specific.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply