The following forum(s) have migrated to Microsoft Q&A: All English Visual Studio Development forums!
Visit Microsoft Q&A to post new questions.

Learn More

Remove From My Forums

Regression testing with database

Question
0

Sign in to vote

I want to do some regression testing and I want to make backup of the database, so that at the end of the test I can have the initial data.

Also if i have this sequence: backup database ->test1->backup database->test2->backup database->test3->backup database, I want to be able at any time to start the execution of test3, so I need the database in the state right before test3.

Is there any automatic way of doing these database backups?

Friday, January 14, 2011 12:46 PM

Answers

0

Sign in to vote
There are several options that you have around this. how to do it can get somewhat more complicated though:

1. Use a tool like Lab Management and if the database is also on a VM, do a backup of the VM after the testing concludes and a restore before the test begins

(http://blogs.msdn.com/b/lab_management/archive/2009/05/27/application-build-deploy-and-test-automation-in-lab-management.aspx)

2. In the build workflow, use the Invoke Process to execute a set of SQL commands which detach/reattach/etc. the databases you need

(http://msdn.microsoft.com/en-us/library/ff805001.aspx <- this example is actually deploying a database with team build but shows the concepts)

3. You can also use (for automated tests) the setup and cleanup script (available in the .testsettings file to execute a script before and after the test starts

(http://msdn.microsoft.com/en-us/library/ee256991.aspx)

Backup and restore a sql server database from the command line: http://sysadmingeek.com/articles/backup-your-sql-server-database-from-the-command-line/

I've included links for all of these. Hope this helps.

Jeff Levinson | ALM MVP
Author, "Software Testing with Visual Studio 2010"
- Proposed as answer by niveditabawa_MSFT Tuesday, January 18, 2011 11:36 AM
- Marked as answer by niveditabawa_MSFT Thursday, January 20, 2011 4:40 PM
Friday, January 14, 2011 2:38 PM