Home Forums Article Discussions Article Discussions by Author Discuss content posted by Alejandro Pelc SQL Unit Testing RE: SQL Unit Testing

  • April 8, 2009 at 5:49 am

    #974177

    RichardB (4/8/2009)

    sounds interesting.

    The main issues I guess would be around identities/autoincrements and anything with password in the call!

    Do you have some way of resetting the database after?

    Hi RichardB,

    you could either backup the database, run the test and then restore the backup or take a snapshot of the database and restore that after the unit test.

    This would guarantee a database being in the same state for each unit test run.

    Regards

    GermanDBA

    Regards,

    WilliamD