SPONSORS:






User Tag List

Thanks Thanks:  0
Likes Likes:  0
Dislikes Dislikes:  0
Results 1 to 7 of 7
  1. #1
    Member
    Join Date
    Feb 2001
    Location
    USA
    Posts
    45
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Changing databases - what to test?

    The software that we develop is moving from a
    SQL-based system to an Oracle-based one.

    What are the things that will probably go wrong? Looking for input from testers who have delat with similar issues previously.

    ------------------

  2. #2
    Moderator
    Join Date
    Apr 2001
    Location
    Atlanta, GA, USA
    Posts
    2,167
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    2 Thread(s)
    Total Downloaded
    0

    Re: Changing databases - what to test?

    One big thing: Any searches you have against an Oracle database will be case sensitive unless you've coded around it. SQL searches are not case sensitive unless coded for.

    You'll need to do a full regression test. Every function that interacts with the database in any way may get munged.

    ------------------
    No electrons were harmed in the creation of this message.
    Jordan Gottlieb
    Qualitech Solutions, Inc.
    jgottlieb@qualitechsolutions.com
    Jordan Gottlieb
    Senior Consultant, Orasi Software
    Twitter: @JG_QA

  3. #3
    Senior Member
    Join Date
    Mar 2001
    Location
    UK
    Posts
    484
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Changing databases - what to test?

    I think SQL and ORACLE have a different treatment of NULL (empty) fields but I'm not sure what the difference is without searching for it.

    ------------------
    Softly, Softly catchee monkey...

  4. #4
    Senior Member
    Join Date
    Jul 2001
    Location
    Karachi, Pakistan
    Posts
    168
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Changing databases - what to test?

    Yes, whatever happens u have have to run a complete regression cycle .. and ofcourse the installation/setup will also have to re-tested (it is probbaly re-made) .... last year we switched from different SQL versions, there were certain errors .. so this is a completely new database!

    ------------------

  5. #5
    Moderator
    Join Date
    Aug 2000
    Location
    Vancouver, BC, Canada
    Posts
    1,189
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Changing databases - what to test?

    Rebuilding your stored procedures into PL/SQL is new development and therefore needs to be tested as such.


    ------------------
    Roland
    Roland Stens

  6. #6
    Junior Member
    Join Date
    Jul 2001
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Changing databases - what to test?

    The "order" in which the data is returned could be a big deal depending on your applications/server code. We also found some code was going directly to the db instead of calling the appropriate function, more of a coding standard than a db issue but nonetheless..bugs!

    ------------------

  7. #7
    Senior Member
    Join Date
    Aug 2001
    Location
    Denver, CO
    Posts
    295
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Changing databases - what to test?

    SQL Statements: Syntax, and the driver based Oracle use OCI. This is not as bad as DB2 i think.

    Configuration driver such as ODBC Vs. TNSNAMES.

    Oracle LOB supports is changing .. may be sub version in Oracle9i

    ------------------
    ================================
    IBM Certified Database Administrator
    Sun Certified Java Programmer
    Oracle Certified Associate

 

 

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 8.82%
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 04:11 PM.

Copyright BetaSoft Inc.