Re: Testing schema reset as night service ?

From: Shakespeare <whatsin_at_xs4all.nl>
Date: Thu, 20 Mar 2008 22:39:01 +0100
Message-ID: <47e2d97c$0$14361$e4fe514c@news.xs4all.nl>

"timo" <timo.talja_at_luukku.com> schreef in bericht news:gbpEj.36$2f2.28_at_read4.inet.fi...
> Hi,
> Any proposals how to reset schema used for testing purposes every night ?
>
> Idea is to clear db from test cases made during working day.
>
> Does it go like this - and what are alternative ways (tools ?) to do it:
> -exp a dmp when db is clear
> -at nighttime run a .sh script to remove that testing schema
> -imp that schema from dmp
>
> BR, Timo
>
>

Here's another option: use vmware, take a snapshot; do what ever you like and return to your snapshot!

Shakespeare Received on Thu Mar 20 2008 - 16:39:01 CDT

Original text of this message