Re: Developers wanting individual Unit Test (no data) databases - suggestions?

It's always kinda fun when someone says, "but I don't want the whole database - I just want X, Y, and Z from it".

OK. Don't look at everything. The full copy is available in minutes and takes no storage, what is so bad about that?

Or, if you absolutely don't want the extra stuff to exist, then do DROPs or TRUNCATEs as post-processing when cloning/refreshing the virtual database?

I can spin up an environment in a couple minutes, giving you full root, oracle, and delphix access, and you can check it all out.

On 8/11/17 12:06, Jacek Gębal wrote:
> I think the requirement is tho have empty db, so only code and
> structures would be cloned from prod into the master copy.
>
> On 11 Aug 2017 19:00, "Tim Gorman" <tim.evdbt_at_gmail.com
> <mailto:tim.evdbt_at_gmail.com>> wrote:
>
> This is how most (if not all) of 300+ customers use Delphix for
> virtualizing Oracle, MSSQL, DB2, Sybase, and application tiers.
>
> Make full-size, read-write clones quickly and cheaply, use them,
> get rid of them, or archive them for easy restore.
>
> If you want a full environment to play with and show you around, I
> can make one for you in a couple minutes.
>
> Full disclosure: I work for Delphix. Not sales, just enthusiasm.
>
>
>
> On 8/11/17 11:25, Chris Taylor wrote:
>> We've got a relatively large development group who want to have
>> many Unit Test databases (without data) that they can spin up on
>> demand and destroy when done.
>>
>> I'm curious what products are available that could facilitate
>> something like this?
>>
>> I was thinking something like this:
>>
>> Unit Test (UT Master) - code replicated from production nightly
>> (never used for testing)
>>
>> How could I facilitate users creating a copy on demand of
>> UTMaster using something like:
>>
>> VMWare or
>> Delphix or
>> Docker or
>> something
>>
>> I'm basically looking to see what options are to accomplish
>> something like this.
>>
>> I was thinking if we stood up UT Master on a VM, we could snap
>> the VM into another copy for a specific developer on demand.
>>
>> Chris
>>
>>
>>
>>
>>
>

--
http://www.freelists.org/webpage/oracle-l