tags:

views:

103

answers:

1
Q: 

Backup/Restore database for SQL Server continuous integration testing.

What is the best way to restore a SQL Server database on our testing server from a snapshot taken in production. Database is running on Windows Server 2003 with SQL Server 2008

We are using Bamboo along with Ant scripts for continuous integration running on Ubuntu.

I want to be able to restore the database to a backup taken from production and apply the latest update scripts.

Any advise is greatly appreciated.

A: 

DbUnit can probably help you.

http://www.dbunit.org/

Nate  2010-05-06 20:18:48

related questions

Automated Unit Testing with JavaScript
Eclipse 3.3.2/MyEclipse doesn't recognize xml as ant files
Files not extracted from .jar file when run
Ant OS-specific copy task
How do you create a MANIFEST.MF that's available when you're testing and running from a jar in production?
Maven or Ant?
Compiling mxml files with ant and flex sdk
Ant is not able to delete some files on windows
How to compile a java application which uses Google webdriver from comand line without ant
Worth migrating to Rake?
How do I use Nant/Ant naming patterns?
Is there a simpler way to deploy to WebSphere?
ant build.xml windows white space in path
How do I generate Emma code coverage reports using Ant?
How do I get javadoc to link to the Java API using an Ant task?
Is there a way to generalize an Apache ANT target?
Why am I getting a ClassCastException when generating javadocs?
Recommend a build tool for a large legacy Java project.
Best Apache Ant Template
Where do I get the Antlr Ant task?
Ant's <javac> tasks throws StackOverflowException
JNI and Java: ant calling make or make calling ant?
Ant build scripts, antcall, dependencies, etc
Can someone give me a working example of a build.xml for an EAR that deploys in WebSphere 6
How much of the Web build process do you/should you automate?