Post reply

UAT Testing and reverting back committed transcation

  • June 2, 2011 at 5:22 am

    #238517

    SQL 2008 R2 enterprise

    Win 2008

    64 bit

    UAT Testing:

    Anyone know of an easy way to execute a stored procedure or execute a tsql command that can revert back all committed transactions when the tests are completed.

  • June 2, 2011 at 5:25 am

    #1333012

    DB Snapshot or backup/restore.

  • June 2, 2011 at 5:27 am

    #1333016

    Backup and restore?

    Meaning: take a backup of the db before starting the tests and restore from backup once the tests are completed.

    Question aside: why do you have to revert to the state before the tests? If the reason is "it's a production db" I strongly recommend to setup a separate test environment...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • June 2, 2011 at 5:54 am

    #1333031

    cheshirefox (6/2/2011)

    Anyone know of an easy way to execute a stored procedure or execute a tsql command that can revert back all committed transactions when the tests are completed.

    Take a database snapshot before you start, revert to it once you're done

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • June 2, 2011 at 6:31 am

    #1333051

    We've recently started using fitnesse with DbFit for automated acceptance testing and TDD on the database side. It allows you to role back transactions when complete.

    http://www.fitnesse.info/dbfit:reference

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply