Re: Developers wanting individual Unit Test (no data) databases - suggestions?
Date: Fri, 11 Aug 2017 11:53:20 -0700
Message-Id: <1B02F61B-16BF-4B38-B2E3-38125350C4B1_at_oracle.com>
I would be remiss not to suggest hot clone/refresh PDBs to an Oracle forum:
SQL> create pluggable database oe_dev from oe_at_prod_system no data;
If cloning from an EE prod system to an SE dev env. there is no Multitenant licensing costs for single tenant
in the dev env. and the operation is storage agnostic.
An example of how some customers leverage this via REST calls to provision the PDB:
thanks,
jpm
> On Aug 11, 2017, at 11:30 AM, Gerald Venzl <gerald.venzl_at_oracle.com> wrote:
>
> If you don’t need the data and just want to run a local database on a laptop that they can develop and run tests against then really Docker is the way to go. :)
> People have done it before and are unit testing this way: https://github.com/oracle/docker-images/tree/master/OracleDatabase/samples/prebuiltdb <https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_oracle_docker-2Dimages_tree_master_OracleDatabase_samples_prebuiltdb&d=DwMFaQ&c=RoP1YumCXCgaWHvlZYR8PQcxBKCX5YTpkKY057SbK10&r=hiDGYU-Eo9j8HVX_-povc-fRVvZ6ACBK_fWiVQK2zrc&m=4v5W7cUWtYPd987gBFq8r7cWk-zj9kI63w-WIO6dA9U&s=90ERNzUtLHkxHTVSpQtyxZt4UNKowWK2xVLnY2FzBc8&e=>
> It allows you to spin up a DB in a matter of seconds and if they have done something wrong or want to start from scratch they can just throw away the container and spin up a new one.
>
> Happy to help exploring this further, you got my email.
>
> Thx,
> ---------------
>
> Gerald Venzl | Senior Principal Product Manager
> Email: gerald.venzl_at_oracle.com <mailto:gerald.venzl_at_oracle.com> | Phone: +1.650.633.0085 <tel:+16506330085>
> Oracle ST & Database Development
> 400 Oracle Parkway | Redwood Shores | 94065 | USA
>
>> On Aug 11, 2017, at 11:06, Chris Taylor <christopherdtaylor1994_at_gmail.com <mailto:christopherdtaylor1994_at_gmail.com>> wrote:
>>
>> We really don't need the data. Theoretically we'd have an empty Unit Test master db to use.
>>
>> Already sent a reply back to Kellyn so those same questions apply to you but with one additional:
>>
>> These new copies, could any of these be run on developer workstations instead of a server? Does Delphix have a way to facilitate bringing a copy down to a workstation (since we're talking about 70-100 GB only without the actual data).
>>
>> Chris
>>
>>
>> On Fri, Aug 11, 2017 at 12:59 PM, 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-lReceived on Fri Aug 11 2017 - 20:53:20 CEST