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

I would use
- docker image,
- test-data-ninja

http://www.codemonth.dk/code_is_good/dev_qa_prod.assert?condition=codemonth:::20::Easily-generate-millions-of-rows-of-random-test-data-using-a-PLSQL-API .

• utPLSQL v3 for unit testing

Cheers
Jacek

On 11 Aug 2017 18:45, "Gerald Venzl" <gerald.venzl_at_oracle.com> wrote:

> Hey Chris,
>
> Many people use Docker for this these days.
> Docker integrates well with almost all CI/CD tools and it allows you to
> spin up a DB fast and just throw it away afterwards, which makes it perfect
> for Unit Testing.
> If you don’t even need any data or not much, it’s a great fit.
> If you do need a lot of data or more sophisticated snapshot and rollback
> then probably not so much.
>
> Another benefit of Docker is that Community Edition is free which is
> probably all you need for unit testing.
> Community Edition also ships in the Oracle Linux addons if you happen to
> run on OL.
>
> Thx,
> ---------------
>
> Gerald Venzl | Senior Principal Product Manager
> Email: gerald.venzl_at_oracle.com | Phone: +1.650.633.0085 <+16506330085>
> Oracle ST & Database Development
> 400 Oracle Parkway | Redwood Shores | 94065 | USA
>
> On Aug 11, 2017, at 10:35, Kellyn Pot'Vin-Gorman <dbakevlar_at_gmail.com>
> wrote:
>
> Which would result in a storage purchase, scripting project to manage it
> all and lock into hardware. Delphix and a couple others work on any
> hardware, are cloud mobile and have a self-service portal so the DBA
> doesn't have to manage it all. The new pricing model makes it worth the
> look!
>
> Yes, I work for Delphix...:)
>
> Kellyn Gorman
> Technical Intelligence Manager
>
> On Fri, Aug 11, 2017 at 1:31 PM Stefan Koehler <contact_at_soocs.de> wrote:
>
>> Hey Chris,
>> you don't need any special product for this purpose - just a CoW
>> filesystem with snapshot technology like ZFS :)
>>
>> Best Regards
>> Stefan Koehler
>>
>> Independent Oracle performance consultant and researcher
>> Website: http://www.soocs.de
>> <https://urldefense.proofpoint.com/v2/url?u=http-3A__www.soocs.de&d=DwMFaQ&c=RoP1YumCXCgaWHvlZYR8PQcxBKCX5YTpkKY057SbK10&r=zUfLpQOHlJTnMpyBPavQbdKRMt_LVE0xNvj73TLA4pQ&m=HdpAyoT7x6Lrc1Tzn5vM4Akby_wpG842bQEV3aruODc&s=uoe2_mIWZYIS115tKAaYX0r7QALuXiZxvhULSzWKSD0&e=>
>> Twitter: _at_OracleSK
>>
>> > Chris Taylor <christopherdtaylor1994_at_gmail.com> hat am 11. August 2017
>> um 19:25 geschrieben:
>> >
>> > 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
>> <https://urldefense.proofpoint.com/v2/url?u=http-3A__www.freelists.org_webpage_oracle-2Dl&d=DwMFaQ&c=RoP1YumCXCgaWHvlZYR8PQcxBKCX5YTpkKY057SbK10&r=zUfLpQOHlJTnMpyBPavQbdKRMt_LVE0xNvj73TLA4pQ&m=HdpAyoT7x6Lrc1Tzn5vM4Akby_wpG842bQEV3aruODc&s=PhZW7UpUQnZi_JN31FnzAI_J16qg7dXBnptd-jhSFJU&e=>
>>
>>
>> --
>
>
> [image: Kellyn Pot'Vin on about.me]
>
> Kellyn Pot'Vin-Gorman
> about.me/dbakevlar
>
> <https://urldefense.proofpoint.com/v2/url?u=http-3A__about.me_dbakevlar&d=DwMFaQ&c=RoP1YumCXCgaWHvlZYR8PQcxBKCX5YTpkKY057SbK10&r=zUfLpQOHlJTnMpyBPavQbdKRMt_LVE0xNvj73TLA4pQ&m=HdpAyoT7x6Lrc1Tzn5vM4Akby_wpG842bQEV3aruODc&s=PcyHrWG_Og5V5tM02fFWQOL6xjV3Z4h3lPOOgXMvR6o&e=>
>
>
>

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