Need to restore a database to test against on each run

[PeteDuncanson]

To ensure we have a "clean" database each time we should really restore one a fresh at the start of each run.

Current thinking is to have a SQL CE database on disc as a "snapshot" that we can copy over to the /App_Data/ folder to replace the one we used for the last run. We could then mess around with the database via the Umbraco back office to add any content we want etc. take a copy of it for the "snap shot".

Need a script that will copy the snap shot db over the existing db before anything runs. Suspect this might need to be a JS task and I'm leaning towards adding this as a "npm script test" script for ease. Having a "npm script take-snap-shot" might be an idea too.

One issue we will have is SQL CE is meant to be getting ripped out of V8...