SPONSORS:






User Tag List

Page 1 of 2 12 LastLast
Results 1 to 10 of 11
  1. #1
    Member
    Join Date
    Jun 2002
    Posts
    34
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Database migration testing

    We are changing /upgrading our database archietecture and want to use an
    automated tool to test the database migration .We envision the tool helping us
    out with creating database queries, running those queries (possibly unattended)and using something like a diff/compare tool to validate the results .
    Can Silk Test help us out with this ......


    ------------------
    Fawad Rana
    Performance Testing Engineer
    Gelco Information Network
    Fawad A Rana
    QA Manager
    OptumHealth-A Division of UnitedHealth Group

  2. #2
    Senior Member
    Join Date
    Jun 2000
    Location
    Hartford, CT, USA
    Posts
    163
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Database migration testing

    Yes. As a matter of fact, I found Silk very helpful... in most of my back-end testing...

    Since comparing complete rows is what I haven't done, you might want to experiment first about how will U store a complete row in a Record... and then again reading and comparing...

    ------------------
    Jaimini Bhatt
    jaiminita@hotmail.com
    jaiminita@yahoo.com
    Jaimini Bhatt

  3. #3
    Senior Member
    Join Date
    Dec 2001
    Location
    Bozeman, MT, USA
    Posts
    265
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Database migration testing

    so do you want to verify that the data is the same on both DB's? Can you be a little more specific?

    ------------------
    Ryan McCullough
    Accelrys Inc.
    ryan@accelrys.com
    Ryan McCullough
    RightNow Tech. Inc.

  4. #4
    Member
    Join Date
    Jun 2002
    Posts
    34
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Database migration testing

    yes , we need to run similiar queries on both database( QA and Production) and validate that there are no issues with the data migration

    ------------------
    Fawad Rana
    Performance Testing Engineer
    Gelco Information Network
    Fawad A Rana
    QA Manager
    OptumHealth-A Division of UnitedHealth Group

  5. #5
    Junior Member
    Join Date
    Sep 2002
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Database migration testing

    Yes this is very much possible in Silk, you can execute the same quey on two different databases and store the results in different files. Now you can compare these files either using routine provided by silktest or by invoking some third party comparison tool (CSDiff is good one) to find out the differences.

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

  6. #6
    Member
    Join Date
    Jun 2001
    Location
    Bedford, MA, USA
    Posts
    85
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Database migration testing

    It seems like you can probably use the functions in the attached include file, in particular: CompareTabularDataSets().
    This function can be used to compare the output of database queries.
    I have used these functions to do exactly what you are doing now - testing DB migration.

    What you REALLY need is the Database class I have developed for SilkTest. It's esentially a wrapper for Silk's native DB_ calls, but much simpler to use and more powerful. Only trouble is it's tightly integrated with the rest of my test frame so you'd have to take a bunch of include files with it. Let me know if you are interested.

    Good Luck.
    - Jim


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

  7. #7
    Member
    Join Date
    Jun 2001
    Location
    Bedford, MA, USA
    Posts
    85
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Database migration testing

    Jaimini,

    The Database class greatly simplifies database operations in SilkTest.
    In your script/testcase you make single method calls like RunQuery(), Update(), Insert(), DbDelete(), etc. and it
    automatically makes all the required DBTester calls for you. You don't have to deal with connection handles,
    sql statement handles, or fetch loops.

    There are also methods for file-based DB operations such as RunSqlCmdsFromFile(),
    InsertFromFile(), MakeFileFromQueryOutput().

    In addition there are useful properties such as iNumRowsReturned, bLastQueryStatus and sNullTranslationValue.


    As for the other include files - I have a library of classes and functions for all kinds of automation operations. These classed are not tied to any particular application or environment.

    The attached zip file includes a sample test script showing use of the database class, the results file output of that script, and an overview document of the other files in the library.

    Have fun and let me know if you are interested in using any of this.
    - Jim


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

  8. #8
    Senior Member
    Join Date
    Jun 2000
    Location
    Hartford, CT, USA
    Posts
    163
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Database migration testing

    Hi Jim,

    "What you REALLY need is the Database class I have developed for SilkTest. It's esentially a wrapper for Silk's native DB_ calls, but much simpler to use and more powerful. Only trouble is it's tightly integrated with the rest of my test frame so you'd have to take a bunch of include files with it. Let me know if you are interested."


    Can U elaborate how your class and other inc's work?

    [This message has been edited by jaiminita (edited 03-27-2003).]
    Jaimini Bhatt

  9. #9
    Senior Member
    Join Date
    Aug 1999
    Location
    MA
    Posts
    129
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Database migration testing

    If you're comparing large amounts of data you'll find that the DB_* functions through ODBC will be quite slow.

    I had to implement the database comparison in Java using JDBC to get reasonable performance.

    For example in my case running equivalent code in SilkTest took 12 minutes to compare the database (302 tables with varying amounts of rows), and in Java took 30 seconds on same hardware / software.

    ------------------
    Steven Tyler
    SQA Automation Team Manager
    Workforce Central Group
    Kronos Incorporated
    E-Mail: styler@kronos.com
    www.kronos.com
    Improving the Performance of People and Business™
    Steven Tyler
    Manager - Performance Engineering

    Kronos Incorporated
    tel: +1 978 947 4219

  10. #10
    Senior Member
    Join Date
    Aug 1999
    Location
    MA
    Posts
    129
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Database migration testing

    Yeah, I neglected to mention the key reason we looked to Java. The problem was that we knew SilkTest would not scale to do customer database compares when we got further along with the project.

    The 12 minute SilkTest compare was on a small demo database with 39 employees and not much transaction history. This meant that if I tried a 3,000 employee customer database with years of history we'd be waiting hours for results in SilkTest, instead of minutes with the Java tool.

    Plus, implementing in Java took less than 10 business days counting implementation, test, and adding a few new features to the tool.

    ------------------
    Steven Tyler
    SQA Automation Team Manager
    Workforce Central Group
    Kronos Incorporated
    E-Mail: styler@kronos.com www.kronos.com
    Improving the Performance of People and Business™

    [This message has been edited by styler (edited 03-30-2003).]
    Steven Tyler
    Manager - Performance Engineering

    Kronos Incorporated
    tel: +1 978 947 4219

 

 
Page 1 of 2 12 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

vBulletin Optimisation provided by vB Optimise v2.6.0 Beta 4 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
User Alert System provided by Advanced User Tagging v3.0.9 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Questions / Answers Form provided by vBAnswers (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
vBNominatevBulletin 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:15 PM.

Copyright BetaSoft Inc.