SPONSORS:






User Tag List

Thanks Thanks:  0
Likes Likes:  0
Dislikes Dislikes:  0
Results 1 to 7 of 7
  1. #1
    Apprentice
    Join Date
    Feb 2006
    Location
    Kent - England
    Posts
    16
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Is Full regression Testing Necessary after database Migration

    We are upgrading from Oracle 10 to Oracle 11g and i have been asked to organise Testing of a couple of applications in the Test environment after the Migration. The Operation team handling the migration seem to think FULL Functional regression of the Application is required. I however dont think it is necessary since no code changes were made.

    In my opinion a few tests covering Access, searching, sorting, uploading data and deleting records should suffice. What do you think?

    Regards
    HD

  2. #2
    Moderator
    Join Date
    Mar 2002
    Location
    Tampa Bay
    Posts
    7,673
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0
    I would be a little leery of cases where Oracle has decided to disable a previously-deprecated function. If they did that (and I don't know that they did between 10 and 11g) you would, in effect, have a code change.

  3. #3
    SQA Knight
    Join Date
    May 2006
    Location
    Playa Del Rey, California, United States
    Posts
    2,596
    Post Thanks / Like
    Mentioned
    17 Post(s)
    Tagged
    1 Thread(s)
    Total Downloaded
    0
    Tests can lean more towards data validation in instances where stored procedures and triggers are used.

    Also performance testing is necessary as some of the indexes may not have the same impacts/performance as they did previously.

    Also how is the database migrated? If it's being rebuilt from source vs. a straight DB dump, there may be issues with hotfix alters that may not be applied.
    David Lai
    SDET / Consultant
    LinkedIn profile

  4. #4
    Apprentice
    Join Date
    Feb 2006
    Location
    Kent - England
    Posts
    16
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0
    Thanks guys for your replies. This is a great site...
    Keep it up

  5. #5
    Moderator Joe Strazzere's Avatar
    Join Date
    May 2000
    Location
    USA
    Posts
    13,170
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)
    Total Downloaded
    0
    Quote Originally Posted by heavyd View Post
    We are upgrading from Oracle 10 to Oracle 11g and i have been asked to organise Testing of a couple of applications in the Test environment after the Migration. The Operation team handling the migration seem to think FULL Functional regression of the Application is required. I however dont think it is necessary since no code changes were made.

    In my opinion a few tests covering Access, searching, sorting, uploading data and deleting records should suffice. What do you think?
    We do testing because of a perceived risk.

    While none of your application's code has changed, you have to treat it as if ALL of the database has changed. You need to assess the risk that something in the database changes will adversely affect your application. Then you need to consider what you should do to reduce that risk.

    I'm in the midst of migrating our datacenter from one location to another. In addition to changing the location of the systems, we are also upgrading Oracle (and about a billion other pieces of the infrastructure, too). I've decided that a full, in-depth set of regression tests, followed by a prolong Beta testing period with our customers is necessary to reduce the risks in our system. Your mileage may vary.

    You certainly know your application far better than any of us can. Perhaps you know that your application was fine after a similar Oracle upgrade recently. Perhaps you've analyzed all the differences between Oracle 10 and 11, and determined that there will be no adverse impact on your application. And perhaps that led you to conclude that only a few tests are needed here.

    Good luck.
    Joe Strazzere
    Visit my website: AllThingsQuality.com to learn more about quality, testing, and QA!

  6. #6
    SQA Knight
    Join Date
    May 2006
    Location
    Playa Del Rey, California, United States
    Posts
    2,596
    Post Thanks / Like
    Mentioned
    17 Post(s)
    Tagged
    1 Thread(s)
    Total Downloaded
    0
    Just a anecdotal comment, I've been part of Oracle 11g migrations for 2 different companies I've worked for. The main issues we saw from the migration was mostly in reporting related features.
    David Lai
    SDET / Consultant
    LinkedIn profile

  7. #7
    Member
    Join Date
    Dec 2009
    Location
    Alabama, USA
    Posts
    116
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0
    I would test as much as possible for an Oracle 10 to 11 upgrade. One particular oddity we found was the difference in the way 10g and 11g manage their passwords. If I remember correctly, 10g clients and 10g databases were not case sensitive. Basically, both the client and DB converted the passwords to uppercase. We had an issue where a legacy system was still using a 10g client against the newly upgraded 11g DB. All was fine at first because 11g flags grandfathered accounts with a 10g flag, still treating them as case-insensitive. But, when we reset our password, the DB changed the account flag to 11g. Since the new password was camel-case, the legacy app with the 10g client converted the password to Ucase while the DB was now treating it as mixed. Was a bugger to figure out. Of course, if you're not using 10g clients, then I just spent 5 minutes crying over spilled milk.

 

 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Search Engine Optimisation provided by DragonByte SEO v2.0.36 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Resources saved on this page: MySQL 10.71%
vBulletin Optimisation provided by vB Optimise v2.6.4 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
User Alert System provided by Advanced User Tagging v3.2.8 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
vBNominate (Lite) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Feedback Buttons provided by Advanced Post Thanks / Like (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Username Changing provided by Username Change (Free) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
BetaSoft Inc.
Digital Point modules: Sphinx-based search
All times are GMT -8. The time now is 06:11 PM.

Copyright BetaSoft Inc.